| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | SFDOCO | Document (Order No Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | SFDCTO | Order Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 3 | SFKCOO | Order Company (Order Number) | String | Generic Edit | 5 | 0 | Allow NULL? |
| 4 | SFLNID | Line Number | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 5 | SFAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 6 | SFITM | Item Number - Short | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 7 | SFMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 8 | SFEMCU | Business Unit - Header | String | Generic Edit | 12 | 0 | Allow NULL? |
| 9 | SFCO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 10 | SFSHAN | Address Number - Ship To | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 11 | SFAEXP | Amount - Extended Price | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 12 | SFCAEXP | Amount - Calculated Extended | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 13 | SFCBACK | Amount - Calculated Backorder | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 14 | SFCADTC | Amount - Calculated Additional Charge | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 15 | SFSOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 16 | SFSOBK | Units - Qty Backordered/Held | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 17 | SFUOM | Unit of Measure as Input | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 18 | SFUOM1 | Unit of Measure - Primary | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 19 | SFTRDJ | Date - Order/Transaction | Date | Generic Edit | 6 | 0 | |
| 20 | SFDRQJ | Date - Requested | Date | Generic Edit | 6 | 0 | |
| 21 | SFPDDJ | Date - Scheduled Pick | Date | Generic Edit | 6 | 0 | |
| 22 | SFRSDJ | Date - Promised Delivery | Date | Generic Edit | 6 | 0 | |
| 23 | SFIVD | Date - Invoice | Date | Generic Edit | 6 | 0 | |
| 24 | SFPPDJ | Date - Promised Shipment | Date | Generic Edit | 6 | 0 | |
| 25 | SFADDJ | Date - Actual Ship Date | Date | Generic Edit | 6 | 0 | |
| 26 | SFCNDJ | Date - Cancel | Date | Generic Edit | 6 | 0 | |
| 27 | SFDGL | Date - For G/L (and Voucher) | Date | Generic Edit | 6 | 0 | |
| 28 | SFLTTR | Status Code - Last | String | UDC (40 AT) | 3 | 0 | Allow NULL? |
| 29 | SFNXTR | Status Code - Next | String | UDC (40 AT) | 3 | 0 | Allow NULL? |
| 30 | SFCRCD | Currency Code - From | String | Generic Edit | 3 | 0 | Allow NULL? |
| 31 | SFUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 32 | SFPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 33 | SFMKEY | Machine Key | String | Generic Edit | 15 | 0 | Allow NULL? |
| 34 | SFUTIME | Update Date and Time | JDE UTime | Generic Edit | 11 | 0 | |
| 35 | SFURCD | User Reserved Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 36 | SFURDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 37 | SFURAT | User Reserved Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 38 | SFURAB | User Reserved Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 39 | SFURRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
