Order Processing and Other Files

With Datafile Diamond and Premier versions you may tailor the structure of the order processing files so that they contain the exact data you need for your system to operate efficiently. For example, if you import goods from the EC countries over the value threshold for which Customs and Excise need "Intrastat” returns completed, then you almost certainly will want to add data items to your system. These extra items would be needed to store commodity codes, the net weight of goods, and perhaps supplementary units such as the litre volume of liquids or the carat value of gold goods.

Your analysis may show you that you also need extra items in the purchase and stock ledger files. The powerful Copy Items facilities are defined not only within the Database Profiles of the Installation options, but you can also define further data manipulation specific to each document process.

Careful analysis of your needs will soon highlight the extra data items you need — and possibly some that you don’t. File structures are quickly changed using the Restructure a Database options.