Load article sales prices
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. Must be a value before SALESTO. |
||
PLINO |
100000 |
|||
PLINAME |
|
|
|
Price list name. |