Looks close to Microsoft Great Plains becomes more and more popular, somewhat because of Microsoft muscles trailing it. Now it is targeted to the full-length array of horizontal and perpendicular marketplace people. Small companies use Small Business Manager (which is supported on the self profession - Great Plains Dexterity wordbook and runtime), Great Plains Standard on MSDE is for littlest to midsize clients, and then Great Plains serves the component part of the open market up to big corporations. There are individual writing tools acquirable and you emphatically want to cognise which one to use for disparate types of reports.If you are information chief who is asked to importation numerous data to Great Plains or mend or use illegally information from one institution to other - publication this and you will have the clues on wherever to expression more.1. Microsoft Great Plains Tables Structure - Launch Great Plains and go to Tools->Resource Description->Tables. Find the table in the straightlaced string. If you are sounding for the trade - it should be RM00101 - client master record.2. DEX_ROW_ID. This is personal identity file and all Great Plains tabular array has it - this is due to the Great Plains Dexterity engineering. This indian file is never utilized as a key area - so don't try to nexus your tables on DEX_ROW_ID. In defence if you requirement to transportation the array from one camaraderie to other you should use these queries:Select * into GL00100_BAK from TWO.dbo.GL00100
go
alter array GL00100_BAK descend indian file DEX_ROW_ID
go
insert into GL00100 select * from GL00100_BAK
go
drop array GL00100_BAK
go
alter array GL00100_BAK descend indian file DEX_ROW_ID
go
insert into GL00100 select * from GL00100_BAK
go
drop array GL00100_BAK