Skip to main content

Knowledge Center

Load Sales orders (COA) - INP/37224

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).

Field

Required

Format

Length

Example

Title

Description

ACCOUNT

Y*

100648

Customer identifier.

*Customer identifier (ACCOUNT) or Customer identifier from external system (ACCOUNTEXTID) is required.

ACCOUNTEXTID

Y*

Customer identifier from external system.

*Customer identifier (ACCOUNT) or Customer identifier from external system (ACCOUNTEXTID) is required.

ASSIGNEE

4689

User identifier (PID).

ASSIGNEEEXTID

External user identifier.

CONF

2023.10.10

Confirmed delivery date. Format yyyy.mm.dd

CUR

Y

NOK

 

Currency (Three character code following the ISO 4217 standard).

CUSPART

Y**

TXT

24

401321

Customer's product name (customer's internal name of the product).

**CUSPART, PART or PARTEXTID is required.

EXTID

External ID for Sales order (COA).

FREIGHT

Freight amount in Sales orders (COA) currency.

INTERN

Information notification in Sales order item (COAITEM).

ITMEXTID

External ID for the Sales order item (COAITEM).

LOC

TXT

3

OSL

Location (3 letters abbreviation).

MFR

TXT

16

ERP

 

Manufacturer (Short name/code of the manufacturer)

NOTE

Note to customer at Sales order item (COAITEM) level.

PART

Y**

TXT

Steel Pipe Ø 8" x 6000 mm

Part

Product name.

**CUSPART, PART or PARTEXTID is required.

PARTEXTID

External product ID.

**CUSPART, PART or PARTEXTID is required.

PAYTERM

Payment terms

PLANNEREXTID

External planner user identifier.

PLANNERPID

4598

Planner user identifier (PID).

PRICE

Y

Gross price in Sales order currency. (Represents price per unit before any discount is applied.)

PROJECTLEADEREXTID

External planner user identifier.

PROJECTLEADERPID

4698

Project leader user identifier (PID).

QYT

Y

Quantity (number of units which is ordered by customer).

REQ

YYYY.MM.DD

2023.10.10

Requested delivery date.

SHIPBYNO

1014

Shipping service ID.

SHIPPINGADRESSID

3

Address identifier which refers to an address for this customer that should be used as shipping address in the Sales order (COA).

UDF

UDF_NameOfCustomField

Custom field at main level of the Sales order (COA)

UDF1

UDF1_NameOfCustomField

Custom field for the Sales order item (COAITEM) level.

YOURITM

Customer reference number at Sales order item (COAITEM) level.

YOURNO

Y***

Customer reference number at Sales order (COA) main level.

***Required except when loading rental documents (DOCTYPE=RENTALORDER).

YOURREF

Customers reference. (Typically a person.)