This import template does not include the order line internal number.
If this template is used for data export, this number is not on.
For imports and modifications of already existing orders, order lines are identified through the product codes.
If several order lines have the same product codes, the first line is always updated.

Special features

You can import the Quote no. field to specify the order source. This indication is for information only and will not update the potential quote recorded in the system.

The Quote no. is specified on the header and on order lines: to import this number, it must first be set up and entered with consistence on the header and order lines.

Import of dimension types on the line

You cannot force an analytical dimension type to a blank value. As a consequence, if analytical dimension fields are defined in the template, but these fields are blank in the import file, the default dimension codes linked to the document will still populate the fields.
To import the dimension types of a document line, it is necessary to add an additional level to enter the common table containing the analytical information on the line (CPTANALIN).

Error messages

The only error messages are the generic ones.

Tables used

This template can be used in import and export modes. The data is updated in the following tables :

Table

Table description

BPADDRESS [BPA]

Addresses

BPARTNER [BPR]

Business partner

BPCUSTMVT [MVC]

Customer transactions

BPCUSTOMER [BPC]

Customers

BPDLVCUST [BPD]

Ship-to customer

CPTANALIN [CAL]

Analytical accounting lines

FACILITY [FCY]

Sites

ITMBPC [ITU]

Customer product

ITMCATEG [ITG]

Product category

ITMFACILIT [ITF]

Products-sites

ITMMASTER [ITM]

Products

ITMMVT [ITV]

Product-site totals

ITMSALES [ITS]

Products - sales

ITMWRH [ITW]

Products-warehouses

PRICSTRUCT [PRS]

Price structure (cust/supp)

SALESREP [REP]

Sales rep

SORDER [SOH]

Sales orders - header

SORDERP [SOP]

Sales orders - price

SORDERQ [SOQ]

Sales orders - quantities

SPRICLINK [SPK]

Sales price list search

SPRICLIST [SPL]

Customer price lists

SQUOTED [SQD]

Quote detail

SVCRFOOT [SVF]

Sales document - footer el.

SVCRVAT [SVV]

Sales document - tax

TABCUR [TCU]

Currency table

TABMODELIV [TMD]

Delivery mode table

TABPRTMOD [TPM]

Print template table

TABSOHTYP [TSO]

Order type table

TABUNIT [TUN]

Table of units of measure

WAREHOUSE [WRH]

Warehouses