Datafile Home \| KB Home \| Advanced Search

copy

Article Number: 1824 | Rating: Unrated | Last Updated: Thu, Jun 22, 2023 at 4:54 PM

Datafile Software

copy

There are a number of versions of this:

copy="Dnnn" — This requires a dfd attribute too (see below) to state the primeindexed file from which the copy is to take place. In this form the element data is used as the key to the dfd lookup file, and the data found in data item Dnnn of the lookup file is used as the data required. This could be used, for example, to exchange an EAN product code with our own product code from the lookup file.

copy="Dnnn,Dmmm" — This is used where the element data item is still required in the data, but it is also required as the key to copy other data items from a lookup database. The item Dnnn in the lookup file is copied to the item Dmmm in the database being created or updated. The lookup database and the object database must both be defined by dfd1 and dfd2 attributes (see below). An example of its use is:

<PRODNUM dfd1="STA" copy="D031-SL-Nominal,D027-Nominal"
dfd2="PLA">D006-Stock </PRODNUM>

Used in (say) receipt of sales orders, this would take the stock code found as the data and put it into data item 6, and also use this code to lookup the stock file to copy the nominal code found at item 31 of the stock file into order detail data item 27.

copyx="Dnnn,Dmmm" — where "x” can take a value between 1-9, should be used instead of the unnumbered copy above, to allow more than one item to be copied (required because an attribute cannot be used more than once within an element).

Custom Fields