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