[en] Load Sales orders (COA)
[en] To open the Input menu (INP) for Sales orders (COA), type INP in the program field and find COAUPLOAD in the list. Press ENTER to access the Input menu (INP) for Sales orders (COA). The users may upload Sales orders (COA) to the system by using the Input menu (INP).
[en] Field | [en] Required | [en] Format | [en] Length | [en] Example | [en] Title | [en] Description |
|---|---|---|---|---|---|---|
[en] ACCOUNT | [en] Y* | 100648 | [en] Customer identifier. [en] *Customer identifier (ACCOUNT) or Customer identifier from external system (ACCOUNTEXTID) is required. | |||
[en] ACCOUNTEXTID | [en] Y* | [en] Customer identifier from external system. [en] *Customer identifier (ACCOUNT) or Customer identifier from external system (ACCOUNTEXTID) is required. | ||||
[en] ASSIGNEE | 4689 | [en] User identifier (PID). | ||||
[en] ASSIGNEEEXTID | [en] External user identifier. | |||||
[en] CUR | [en] Y | [en] NOK | [en] | [en] Currency (Three character code following the ISO 4217 standard). | ||
[en] CUSPART | [en] Y** | [en] TXT | 24 | 401321 | [en] Customer's product name (customer's internal name of the product). [en] **CUSPART, PART or PARTEXTID is required. | |
[en] EXTID | [en] External ID for Sales order (COA). | |||||
[en] FREIGHT | [en] Freight amount in Sales orders (COA) currency. | |||||
[en] INTERN | [en] Information notification in Sales order item (COAITEM). | |||||
[en] ITMEXTID | [en] External ID for the Sales order item (COAITEM). | |||||
[en] LOC | [en] TXT | 3 | [en] OSL | [en] Location (3 letters abbreviation). | ||
[en] MFR | [en] TXT | 16 | [en] ERP | [en] | [en] Manufacturer (Short name/code of the manufacturer) | |
[en] NOTE | [en] Note to customer at Sales order item (COAITEM) level. | |||||
[en] PART | [en] Y** | [en] TXT | [en] Steel Pipe Ø 8" x 6000 mm | [en] Part | [en] Product name. [en] **CUSPART, PART or PARTEXTID is required. | |
[en] PARTEXTID | [en] External product ID. [en] **CUSPART, PART or PARTEXTID is required. | |||||
[en] PAYTERM | [en] Payment terms | |||||
[en] PLANNEREXTID | [en] External planner user identifier. | |||||
[en] PLANNERPID | 4598 | [en] Planner user identifier (PID). | ||||
[en] PRICE | [en] Y | [en] Gross price in Sales order currency. (Represents price per unit before any discount is applied.) | ||||
[en] PROJECTLEADEREXTID | [en] External planner user identifier. | |||||
[en] PROJECTLEADERPID | 4698 | [en] Project leader user identifier (PID). | ||||
[en] QYT | [en] Y | [en] Quantity (number of units which is ordered by customer). | ||||
[en] REQ | [en] YYYY.MM.DD | 2023.10.10 | [en] Requested delivery date. | |||
[en] SHIPBYNO | 1014 | [en] Shipping service ID. | ||||
[en] SHIPPINGADRESSID | 3 | [en] Address identifier which refers to an address for this customer that should be used as shipping address in the Sales order (COA). | ||||
[en] UDF | [en] UDF_NameOfCustomField | [en] Custom field at main level of the Sales order (COA) | ||||
[en] UDF1 | [en] UDF1_NameOfCustomField | [en] Custom field for the Sales order item (COAITEM) level. | ||||
[en] YOURITM | [en] Customer reference number at Sales order item (COAITEM) level. | |||||
[en] YOURNO | [en] Y*** | [en] Customer reference number at Sales order (COA) main level. [en] ***Required except when loading rental documents (DOCTYPE=RENTALORDER). | ||||
[en] YOURREF | [en] Customers reference. (Typically a person.) |