Load Sales Order Requests (CPO) - INP/70769
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.
INP/70769
Field | Required | Length | Example | Description |
ACCOUNT | Y* | Customer identifier. Has to match a customer in ST>=2 and ST<9. *ACCOUNT or ACCOUNTEXTID must have a value. (If ACCOUNTEXTID is given in the file, and ACCOUNT is not given, the program will search for customer via the EXTID field in the Customer (CUS) application). | ||
ACCOUNTEXTID | Y* | The customer external ID. *ACCOUNT or ACCOUNTEXTID must have a value. (If ACCOUNTEXTID is given in the file, and ACCOUNT is not given, the program will search for customer via the EXTID field in the Customer (CUS) application). | ||
CARRIER | BRING | Name of transporter. | ||
CUR | Y | 3 | EUR | Currency. |
CUSPART | The customers part number. (If PARTEXTID is given in the file, the program will first try to find the product (ART) based on PARTEXTID. If ART is not found, the program will search via CUSPART from file, and by PART from file as third priority. If no product is found, the program will set product based on the Company setting (CSV) Unknown product for sales order). | |||
DELTERM | Delivery terms. | |||
DELTERMPLACE | A place related to DELTERM. | |||
INTERN | Info to be set in an DMS/I00 MSG. | |||
ISBLOCKEDFORPRODUCTION | If set to 1, the order will be blocked for production. | |||
MFR | The manufacturer for the product. | |||
NOTE | Note from the customer. | |||
PART | The product in the order. (If PARTEXTID is given in the file, the program will first try to find the product (ART) based on PARTEXTID. If ART is not found, the program will search via CUSPART from file, and by PART from file as third priority. If no product is found, the program will set product based on the Company setting (CSV) Unknown product for sales order). | |||
PARTEXTID | The external ID of the product. (If PARTEXTID is given in the file, the program will first try to find the product (ART) based on PARTEXTID. If ART is not found, the program will search via CUSPART from file, and by PART from file as third priority. If no product is found, the program will set product based on the Company setting (CSV) Unknown product for sales order). | |||
PRICE | The price of the product. | |||
QTY | Y | 10 | Ordered quantity. | |
REQ | 2019.10.25 | Must have the format YYYY.MM.DD or YYWW. | ||
REVISION | Requested product revision. | |||
SADDR1 | Mystery Lane 123 | First address line in the shipping address. | ||
SADDR2 | Post Box 9077 | Second address line in the shipping address. | ||
SADDRID | Shipping address. | |||
SATTN | Attention in the shipping address | |||
SCITY | NEDRE VATS | City/town/village in the shipping address. | ||
SEMAIL | Email address for this shipping address. | |||
SHIPBY | Preferred shipping method. | |||
SHIPCC | Country code is a two-character code identifying a country. The code follows the ISO 3166 standard. Will be validated against the CON archive in RamBase. | |||
SNAME | Doe | Company name, or a person's surname in the shipping address. | ||
SPHONE | +4752763390 | Phone number for this shipping address. | ||
SPOCODE | 5578 | Postal code in the shipping address. Will be validated against the POC archive in RamBase. Illigal values will be discarded. | ||
SSTATE | TN | A US state. | ||
UDF | CustomerPartnerOrderId | User defined field, main level. | ||
UDF1 | Prefix | User defined field, item level. | ||
YOURITM | The customers reference number. | |||
YOURNO | Y | Sales Order Request number. | ||
YOURREF | John Doe | Sales Order Request reference, typically a person. |