This import template does not include the order line internal number.
If this template is used for data export, this number is not specified.
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.
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.
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] |
|
BPCUSTMVT [MVC] |
Customer transactions |
BPCUSTOMER [BPC] |
|
BPDLVCUST [BPD] |
|
CPTANALIN [CAL] |
Analytical accounting lines |
FACILITY [FCY] |
|
ITMBPC [ITU] |
|
ITMCATEG [ITG] |
|
ITMFACILIT [ITF] |
|
ITMMASTER [ITM] |
|
ITMMVT [ITV] |
Product-site totals |
ITMSALES [ITS] |
|
ITMWRH [ITW] |
|
PRICSTRUCT [PRS] |
|
SALESREP [REP] |
|
SORDER [SOH] |
|
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] |
|
TABMODELIV [TMD] |
|
TABPRTMOD [TPM] |
|
TABSOHTYP [TSO] |
|
TABUNIT [TUN] |
|
WAREHOUSE [WRH] |