Load Goods Reception (SSA) STOCKQTY
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. |
||
|
CUSTOMER |
Y* |
|
|
Customer account number for use if DOCTYPE=CUSOWNED (format: TEM-NO:CUS/100000). * Either CUSTOMER or CUSTOMEREXTID must be present in the file if DOCTYPE=CUSOWNED is used. |
|
CUSTOMEREXTID |
Y* |
|
|
Value in EXTID field on Customer can be used to find the right Customer, if DOCTYPE=CUSOWNED. This information will not be used if CUSTOMER is given in the file. *Either CUSTOMEREXTID or CUSTOMER must be present in the file if DOCTYPE=CUSOWNED is used. |
|
EXTID |
BO-Fantomet |
ID for the stockreference in old system. |
||
|
DATE |
Y |
YYYY.MM.DD |
||
|
DOCTYPE |
For example CUSOWNED. Different DOCTYPE can be set. If DOCTYPE=CUSOWNED is set, the file must contain CUSTOMER or CUSTOMEREXTID. |
|||
|
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. |
|||
|
STOCKLOCATION1 |
The placement of the goods in stock. |
|||
|
QTYSTOCKLOCATION1 |
Quantity of goods in stock. |
|||
|
STOCKLOCATION2 |
||||
|
QTYSTOCKLOCATION2 |
||||
|
STOCKLOCATION3 |
||||
|
QTYSTOCKLOCATION3 |
||||
|
STOCKLOCATION4 |
||||
|
QTYSTOCKLOCATION4 |
||||
|
STOCKLOCATION5 |
||||
|
QTYSTOCKLOCATION5 |
||||
|
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. |
||
|
DEPNO |
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. |
|
HEATNO |
|
|
|
A heat number is an identification coupon number that is stamped on a material plate after it is removed from the ladle and rolled at a steel mill |