Skip to main content

Knowledge Center

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.

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.