| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | TDKCOO | Order Company (Order Number) | String | Generic Edit | 5 | 0 | Allow NULL? |
| 2 | TDDCTO | Order Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 3 | TDDOCO | Document (Order No Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 4 | TDLNID | Line Number | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 5 | TDKCO | Document Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 6 | TDDCT | Document Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 7 | TDDOC | Document (Voucher Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 8 | TDTXA1 | Tax Rate/Area | String | Generic Edit | 10 | 0 | Allow NULL? |
| 9 | TDEXR1 | Tax Expl Code 1 | String | UDC (00 EX) | 2 | 0 | Allow NULL? |
| 10 | TDCO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 11 | TDAG | Amount - Gross | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 12 | TDATXN | Amount - Non-Taxable | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 13 | TDATXA | Amount - Taxable | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 14 | TDSTAM | Amount - Tax | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 15 | TDTXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 16 | TDTXR2 | Tax Rate 2 | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 17 | TDTXR3 | Tax Rate 3 | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 18 | TDTXR4 | Tax Rate 4 | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 19 | TDTXR5 | Tax Rate 5 | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 20 | TDSTA1 | Amount - Sales Tax Tax Authority 1 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 21 | TDSTA2 | Amount - Sales Tax Tax Authority 2 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 22 | TDSTA3 | Amount - Sales Tax Tax Authority 3 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 23 | TDSTA4 | Amount - Sales Tax Tax Authority 4 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 24 | TDSTA5 | Amount - Sales Tax Tax Authority 5 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 25 | TDCRCD | Currency Code - From | String | Generic Edit | 3 | 0 | Allow NULL? |
| 26 | TDCRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 27 | TDCRCM | Currency Conversion Y/Z | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 28 | TDUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 29 | TDPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 30 | TDJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 31 | TDUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 32 | TDUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
