| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | SWKCOO | Order Company (Order Number) | String | Generic Edit | 5 | 0 | Allow NULL? |
| 2 | SWDOCO | Document (Order No Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 3 | SWDCTO | Order Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 4 | SWLNID | Line Number | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 5 | SWCO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 6 | SWMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 7 | SWAN8 | Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 8 | SWSHAN | Address Number - Ship To | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 9 | SWPA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 10 | SWDRQJ | Date - Requested | Date | Generic Edit | 6 | 0 | |
| 11 | SWTRDJ | Date - Order/Transaction | Date | Generic Edit | 6 | 0 | |
| 12 | SWIVD | Date - Invoice | Date | Generic Edit | 6 | 0 | |
| 13 | SWDGL | Date - For G/L (and Voucher) | Date | Generic Edit | 6 | 0 | |
| 14 | SWITM | Item Number - Short | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 15 | SWLITM | 2nd Item Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 16 | SWAITM | 3rd Item Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 17 | SWLNTY | Line Type | String | Generic Edit | 2 | 0 | Allow NULL? |
| 18 | SWDSC1 | Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 19 | SWDSC2 | Description - Line 2 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 20 | SWLTTR | Status Code - Last | String | UDC (40 AT) | 3 | 0 | Allow NULL? |
| 21 | SWNXTR | Status Code - Next | String | UDC (40 AT) | 3 | 0 | Allow NULL? |
| 22 | SWUORG | Units - Order/Transaction Quantity | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 23 | SWUOM | Unit of Measure as Input | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 24 | SWUPRC | Amount - Price per Unit | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 25 | SWAEXP | Amount - Extended Price | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 26 | SWKCO | Document Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 27 | SWDOC | Document (Voucher Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 28 | SWDCT | Document Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 29 | SWTAX1 | Sales Taxable (Y/N) | Character | UDC (H00 TV) | 1 | 0 | Allow NULL? |
| 30 | SWTXA1 | Tax Rate/Area | String | Generic Edit | 10 | 0 | Allow NULL? |
| 31 | SWEXR1 | Tax Expl Code 1 | String | UDC (00 EX) | 2 | 0 | Allow NULL? |
| 32 | SWGLC | G/L Offset | String | Generic Edit | 4 | 0 | Allow NULL? |
| 33 | SWURRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 34 | SWUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 35 | SWSOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 36 | SWUOM4 | Unit of Measure - Pricing | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 37 | SWCRCD | Currency Code - From | String | Generic Edit | 3 | 0 | Allow NULL? |
| 38 | SWCRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 39 | SWFUP | Amount - Foreign Price per Unit | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 40 | SWFEA | Amount - Foreign Extended Price | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 41 | SWPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 42 | SWUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 43 | SWTDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 44 | SWJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 45 | SWUSR0 | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
