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 |
---|---|---|---|---|
EXTID | Y * | External ID to identify Articles from the Customer's system. * IT, PART or EXTID must be present in the file. | ||
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. | |
MFR | 20 | ACME | Manufacturer. The manufacturers have to be registered in the Manufacturer archive (MFR) in RamBase prior to the Article load. | |
PART | Y * | 35 | 190-489-A1 | Article name. * IT, PART or EXTID must be present in the file. |
PLINAME | Price list name. | |||
PLINO | 100000 | |||
SALESCUR | Y | NOK | Selling currency. | |
SALESFROM | 2005.06.200523 | Sales price valid from set date. Must be a value before SALESTO. | ||
SALESGM | 80 | Sales gross margin in percent (%). Will be calculated if SALESPRICE is set. | ||
SALESPRICE | 8.6 | Salesprice in the currency defined in SALESCUR, and the quantity defined in SALESQTY. | ||
SALESQTY | Y** | 5 | Quantity step for sales prices. ** Can not have a value if SALESPRICEGROUPAGREEMENT has a value. |