Import/export template >  Module Sales >  Import/export template SOHFL (Full sales orders)  

Display all Hide all

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.

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.

Prerequisites

Mandatory fields in the template

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