Sales Order SOH Import/Export Template

TBD start

This template is provided with the SEED data folder for X3. It includes several record types to demonstrate the possibilities when importing or exporting customer data.

The data file is expected to have multiple records of data for a customer, with the records separated by CR + LF (carriage return and line feed). Fields within the record are delimited by a semicolon ( ; ). The data should be composed of ASCII characters.

When importing, keep in mind that the import follows the same pattern of entry as the user interface, so many field values are provided by the logic within the customer object. The import log will list values that are missing or invalid to help you correct your template.

TBD end

Description	Table	Field	Type	Length	Notes	Required for Import
Header record type	SORDER	/	string	1	Hard-coded as “E”
Sales site	SORDER	SALFCY	string	5	Uses key format	Required
Order type	SORDER	SOHTYP	string	5	Uses key format	Required
Order no.	SORDER	SOHNUM	string	20	Uses key format
Sold-to	SORDER	BPCORD	string	15	Uses key format	Required
Order date	SORDER	ORDDAT	date	8	YYYYMMDD format	Required
Customer order ref	SORDER	CUSORDREF	string	20
Shipment site	SORDER	STOFCY	string	5	Uses key format	Required
Currency	SORDER	CUR	string	3	Uses key format
Project	SORDER	PJT	string	40
Header text	SORDER	*71	string	100
Header text, cont.	SORDER	*72	string	100	continuation of previous text field
Footer text	SORDER	*81	string	100
Footer text, cont.	SORDER	*82	string	100	continuation of previous text field
Line record type	SORDERQ	/	string	1	Hard-coded as “L”
Product	SORDERQ	ITMREF	string	20	Uses key format	Required
Description	SORDERP	ITMDES	string	30
Sales unit	SORDERP	SAU	string	3
Ordered quantity	SORDERQ	QTY	decimal	15		Required
Gross price	SORDERP	GROPRI	decimal	10.4
Discount/Charge 1	SORDERP	DISCRGVAL1	decimal	10.4
Discount/Charge 2	SORDERP	DISCRGVAL2	decimal	10.4
Discount/Charge 3	SORDERP	DISCRGVAL3	decimal	10.4
Line text	SORDERQ	*91	string	100
Line text, cont.	SORDERQ	*92	string	100	continuation of previous text field

Notes

• Uses Key format indicates that characters allowed for a value are restricted to uppercase letters, numbers, hyphen -, slash mark /, and underscore _.

• If you wish to modify this template, we recommend making a copy of it and using the copy, as upgrades to the application sometimes include updates to the demonstration data and will overwrite the SOH template.