Skip to content
Developer home
X3

Sales Order SOH Import/Export Template

  Less than to read

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.