Load Sales Order Requests (CPO)
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* |
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). |
||
|
YOURNO |
Y |
Sales Order Request number. |
||
|
QTY |
Y |
10 |
Ordered quantity. |
|
|
CUR |
Y |
3 |
EUR |
Currency. |
|
YOURREF |
John Doe |
Sales Order Request reference, typically a person. |
||
|
DELTERM |
Delivery terms. |
|||
|
DELTERMPLACE |
A place related to DELTERM. |
|||
|
UDF |
CustomerPartnerOrderId |
User defined field, main level. |
||
|
SHIPBY |
Preferred shipping method. |
|||
|
CARRIER |
BRING |
Name of transporter. |
||
|
SADDRID |
Shipping address. |
|||
|
SNAME |
Doe |
Company name, or a person's surname in the shipping address. |
||
|
SADDR1 |
Mystery Lane 123 |
First address line in the shipping address. |
||
|
SADDR2 |
Post Box 9077 |
Second address line in the shipping address. |
||
|
SCITY |
NEDRE VATS |
City/town/village in the 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. |
||
|
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. |
|||
|
SATTN |
Attention in the shipping address |
|||
|
SPHONE |
+4752763390 |
Phone number for this shipping address. |
||
|
SEMAIL |
Email address for this shipping address. |
|||
|
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). |
|||
|
MFR |
The manufacturer for the product. |
|||
|
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). |
|||
|
PRICE |
The price of the product. |
|||
|
REQ |
2019.10.25 |
Must have the format YYYY.MM.DD or YYWW. |
||
|
YOURITM |
The customers reference number. |
|||
|
NOTE |
Note from the customer. |
|||
|
INTERN |
Info to be set in an DMS/I00 MSG. |
|||
|
REVISION |
Requested product revision. |
|||
|
ISBLOCKEDFORPRODUCTION |
If set to 1, the order will be blocked for production. |
|||
|
UDF1 |
Prefix |
User defined field, item level. |