Load Goods reception (SSA) NETQTY - INP/67646
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 |
ACCOUNT | Y* | Supplier account number. The number should match the RamBase supplier number. *Either ACCOUNT or ACCOUNTEXTID must be present in the file. | ||
EXTID | BO-Fantomet | ID for the stockreference in old system. | ||
DATE | Y | YYYY.MM.DD | ||
LOC | Y | 3 | VAT | Location: A three character Warehouse Code, identifying a warehouse. |
CUR | Y | NOK | ||
QTY | Y | |||
PARTIT | Y* | Part IT. * PARTIT, PARTEXTID or PART must have a value. | ||
PARTEXTID | Y* | Product/Part ID in old system (Unique). * PARTIT, PARTEXTID or PART must have a value. | ||
PART | Y* | Servicetime | Part name. * PARTIT, PARTEXTID or PART must have a value. | |
MFR | 16 | MISC | Manufacturer. | |
PRICE | Y | |||
LOT | ||||
QUALITY | Field for Quality information on article, will be copied to Quality field on respective documents. | |||
NOTE | ||||
ACCOUNTEXTID | Y* | The supplier's unique ID from the legacy (old) system. To identify the supplier the transaction is to be connected to. *Either ACCOUNT or ACCOUNTEXTID must be present in the file. | ||
DEPNP | Department Number. | |||
PRJNO | Project Number. | |||
BESTIFUSEDBYDATE | 2020.03.30 | This is the date this product is best before, but it may also be good enough after this date. | ||
ORIGIN | 2 | NO | Two-character code (ISO 3166) identifying the default country where the product is produced. | |
PERIOD | ||||
PRODUCTIONDATE | ||||
CREATEPO | Y | If a corresponding Purchase order (SPO) should be created | ||
POEXTID | Purchase order ID in old system |