Load Article sales prices - INP/14540
Possible fields to be loaded into RamBase are listed in the Field-column in the following table. The other columns in this table provide additional information about each field.
Field | Required | Length | Example | Description |
IT | Y * | #100000 | Internal typenumber is a unique ID that identifies the article. This will be assigned by the system when a new article is created. Format: #123456 * IT, PART or EXTID must be present in the file. | |
PART | Y * | 35 | 190-489-A1 | Article name. * IT, PART or EXTID must be present in the file. |
EXTID | Y * | External ID to identify Articles from the Customer's system. * IT, PART or EXTID must be present in the file. | ||
MFR | 20 | ACME | Manufacturer. The manufacturers have to be registered in the Manufacturer archive (MFR) in RamBase prior to the Article load. | |
SALESCUR | Y | NOK | Selling currency. | |
SALESQTY | Y** | 5 | Quantity step for sales prices. ** Can not have a value if SALESPRICEGROUPAGREEMENT has a value. | |
SALESPRICE | 8.6 | Salesprice in the currency defined in SALESCUR, and the quantity defined in SALESQTY. | ||
SALESGM | 80 | Sales gross margin in percent (%). Will be calculated if SALESPRICE is set. | ||
SALESFROM | 2005.06.200523 | Sales price valid from set date. | ||
PLINO | 100000 | |||
PLINAME | Price list name. |