Load Goods reception (SSA) STOCKQTY - INP/67645
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 |