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 Dynamics / eEnterprise versions for MS SQL Server: 5.0, 5.5, 6.0, 7.0, 7.5, 8.0 and now 9.0. With…