Load Purchase orders (SPO) - INP/76498
Load purchase orders (SPO). Purchase orders will be registered and forward automatically to a purchase order response (SOA) if a confirmation date is given. This load should be used for startup a new company.
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 | Format | Length | Example | Title | Description |
|---|---|---|---|---|---|---|
Account | Mandatory | 100648 | Supplier Id *Either ACCOUNT or SUPEXTID is mandatory | |||
ASSIGNEE | ||||||
ASSIGNEEEXTERNALREFERENCE | ||||||
CONF | Confirmed delivery date | |||||
CUR | EUR | Currency | ||||
CUSTOMER | ||||||
CUSTOMEREXTID | ||||||
DOCTYPE | ||||||
IT | TXT | 7 | #1000000 | IT | Product Id | |
ITMEXTID | External reference/Id to item/line | |||||
LOC | TXT | 3 | VAT | Loc | Location | |
MFR | TXT | 16 | AUDI | Mfr | Manufacturer | |
MPN | Manufacturers product name | |||||
NOTE | Will be concatenated with ORDEREXTID in NOTE in SPOITEM | |||||
ORDEREXTID | Mandatory | Purchase order Id in old system (will be added to NOTE on SPOITEM) | ||||
PART | Mandatory | TXT | Servicetime 232333 | Part | Product name | |
PRICE | Mandatory | Price | ||||
PRODUCTSEXTERNALREFERENCE | Products external reference (EXTID) | |||||
QTY | Mandatory | Quantity | ||||
REQ | Request delivery date | |||||
SUP | TXT | 5 | TEM-NO:SUP/100004 | SUP | Suppliers product name for a specific supplier Id | |
SUPEXTID | Mandatory | Supplier Id in old system *Either SUPEXTID or ACCOUNT is mandatory | ||||
SUPPART | JHC 1500 | SUPPART | Suppliers product name | |||
SUPPLIERSORDERREFERENCENUMBER | Suppliers order reference number | |||||
SUPPLIERSREFERENCENUMBER | Suppliers order item reference number | |||||
UDF | ||||||
UDF1 |