The table design/architecture of Microsoft Dynamics GP, as we write the current version is Microsoft Great Plains 9.0, was done back in 1990th by Great Plains Software and what we are discussing here is applicable to the majority of Great Plains...
The power and persistence of a good idea constantly amazes me. Once an inspired perception of human activity takes root it is impossible to wipe it out and only with difficulty modified....