Sales Order SOH Import/Export Template
TBD start
This template is provided with the SEED data folder for Enterprise Management. 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.