This section describes importing price lists.
Using the supplier's product numbers when importing prices
When importing into the price and discount matrix you can also add Sup after the ProdNo field to show that the product numbers in the file are the supplier's product numbers. The program then performs a look-up in the table Delivery alternatives using the supplier number on the price/discount line (if this has been specified) and the supplier's product number from the file to find our product number which is stored in the database.
Importing a table with something other than the primary key as a key
In such cases, there must be an = sign in front of the field which will count as the key.