Load Goods Reception (SSA) NETQTY
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 |