| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | DSCTID | Computer ID | String | Generic Edit | 15 | 0 | Allow NULL? |
| 2 | DSJOBS | Job Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 3 | DSDEID | Demand Unique Key ID | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 4 | DSCRTSOCL | Option - SO Cancel Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 5 | DSSOACTION | Option - Sales Order Action | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 6 | DSHOLDORD | Option - Hold Order | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 7 | DSSOLSTS | Option - Sales Order Line Status | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 8 | DSRRCD | Error/Reason Code | String | UDC | 2 | 0 | Allow NULL? |
| 9 | DSSOSTSNTF | Option - Notify of Sale Order Status | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 10 | DSDOCO | Document (Order No Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 11 | DSDCTO | Order Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 12 | DSKCOO | Order Company (Order Number) | String | Generic Edit | 5 | 0 | Allow NULL? |
| 13 | DSLNID | Line Number | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 14 | DSMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 15 | DSAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 16 | DSSHAN | Address Number - Ship To | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 17 | DSITM | Item Number - Short | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 18 | DSRQSHPQTY | Requested Ship Quantity | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 19 | DSUOM | Unit of Measure as Input | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 20 | DSRSDJ | Date - Promised Delivery | Date | Generic Edit | 6 | 0 | |
| 21 | DSRSDT | Promised Delivery Time | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 22 | DSSOBCKORD | Option - Sales Order Backordered | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 23 | DSBQNC | Backorder Quantity Net Change | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 24 | DSINVADV | Option - Inventory Advisement | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 25 | DSBATN | Batch Number | String | Generic Edit | 30 | 0 | Allow NULL? |
| 26 | DSHOLD | Hold Orders Code | String | UDC (42 HC) | 2 | 0 | Allow NULL? |
| 27 | DSDTAI | Data Item | String | Generic Edit | 10 | 0 | Allow NULL? |
