| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | TWITM | Item Number - Short | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | TWCO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 3 | TWMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 4 | TWDCT | Document Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 5 | TWTRUM | Unit of Measure - Transaction | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 6 | TWTRDJ | Date - Order/Transaction | Date | Generic Edit | 6 | 0 | |
| 7 | TWTRQT | Quantity Available | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 8 | TWUNCS | Amount - Unit Cost | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 9 | TWPAID | Amount - Extended Cost/Price | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 10 | TWSVYR | Fiscal Year | Numeric | Generic Edit | 4 | 0 | Allow NULL? |
| 11 | TWPNC | Period Number - Current | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 12 | TWDOCO | Document (Order No Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 13 | TWDCTO | Order Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 14 | TWKCOO | Order Company (Order Number) | String | Generic Edit | 5 | 0 | Allow NULL? |
| 15 | TWLNID | Line Number | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 16 | TWNLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 17 | TWOITM | Item Number - Short Overrides | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 18 | TWDGJ | Date - For G/L (and Voucher) - Julian | Date | Generic Edit | 6 | 0 | |
| 19 | TWTNTP | Transaction Type | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 20 | TWUKID | Unique Key ID (Internal) | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 21 | TWDTE | Date | Date | Generic Edit | 6 | 0 | |
