| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | SOKCOO | Order Company (Order Number) | String | Generic Edit | 5 | 0 | Allow NULL? |
| 2 | SODOCO | Document (Order No Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 3 | SODCTO | Order Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 4 | SOLNID | Line Number | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 5 | SOAST | Price Adjustment Name | String | UDC (40 TY) | 8 | 0 | Allow NULL? |
| 6 | SOI75TXRG | Tax Regime | String | UDC (75I GR) | 5 | 0 | Allow NULL? |
| 7 | SOI75TXTY | Tax Type | String | UDC (75I GT) | 5 | 0 | Allow NULL? |
| 8 | SODOC | Document (Voucher Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 9 | SOCO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 10 | SOMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 11 | SOLITM | 2nd Item Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 12 | SOYEXU | Excise Unit | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 13 | SOITM | Item Number - Short | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 14 | SOUORG | Units - Order/Transaction Quantity | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 15 | SOUOM | Unit of Measure as Input | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 16 | SOI75RETY | Registration Type | String | Generic Edit | 3 | 0 | Allow NULL? |
| 17 | SOFVTR | Factor Value | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 18 | SOI75TAXA | Tax Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 19 | SOI75TXR | Rounding Value | Numeric | Generic Edit | 7 | 2 | Allow NULL? |
| 20 | SOSTCD | State Code | String | Generic Edit | 3 | 0 | Allow NULL? |
| 21 | SOI75RTSU | Registration Type - Supplier | String | UDC (75I RT) | 3 | 0 | Allow NULL? |
| 22 | SOI75CHNB | Chapter Number | String | Generic Edit | 20 | 0 | Allow NULL? |
| 23 | SOAEXP | Amount - Extended Price | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 24 | SOAA1 | Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 25 | SOAA2 | Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 26 | SOAA3 | Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 27 | SODL01 | Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 28 | SODS01 | Description | String | Generic Edit | 80 | 0 | Allow NULL? |
| 29 | SODTE | Date | Date | Generic Edit | 6 | 0 | |
| 30 | SOFFU2 | Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 31 | SOINT01 | Integer01 - EnterpriseOne | Integer | Generic Edit | 4 | 0 | Allow NULL? |
| 32 | SOUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 33 | SOJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 34 | SOUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 35 | SOUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 36 | SOPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
