| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | TDCO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 2 | TDMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 3 | TDOBJ | Object Account | String | Generic Edit | 6 | 0 | Allow NULL? |
| 4 | TDSUB | Subsidiary | String | Generic Edit | 8 | 0 | Allow NULL? |
| 5 | TDDCTO | Order Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 6 | TDDOCO | Document (Order No Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 7 | TDSFXO | Order Suffix | String | Generic Edit | 3 | 0 | Allow NULL? |
| 8 | TDLNID | Line Number | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 9 | TDAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 10 | TDECST | Amount - Extended Cost | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 11 | TDAEXP | Amount - Extended Price | 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 | TDNRTA | Non-Recoverable Tax Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 15 | TDSTAM | Amount - Tax | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 16 | TDTXA1 | Tax Rate/Area | String | Generic Edit | 10 | 0 | Allow NULL? |
| 17 | TDEXR1 | Tax Expl Code 1 | String | UDC (00 EX) | 2 | 0 | Allow NULL? |
| 18 | TDEXR2 | Tax Expl Code 2 | String | UDC (00 EX) | 2 | 0 | Allow NULL? |
| 19 | TDTRDJ | Date - Order/Transaction | Date | Generic Edit | 6 | 0 | |
| 20 | TDDGL | Date - For G/L (and Voucher) | Date | Generic Edit | 6 | 0 | |
| 21 | TDDSVJ | Date - Service/Tax | Date | Generic Edit | 6 | 0 | |
| 22 | TDTX | Purchasing Taxable (Y/N) | Character | UDC (H00 TV) | 1 | 0 | Allow NULL? |
| 23 | TDITM | Item Number - Short | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 24 | TDLITM | 2nd Item Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 25 | TDAITM | 3rd Item Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 26 | TDLNTY | Line Type | String | Generic Edit | 2 | 0 | Allow NULL? |
| 27 | TDUORG | Units - Order/Transaction Quantity | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 28 | TDUOM | Unit of Measure as Input | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 29 | TDFVTY | Factor Value - Type | Character | UDC (H00 FV) | 1 | 0 | Allow NULL? |
| 30 | TDTA1 | Tax Authority | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 31 | TDTXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 32 | TDTA2 | Tax Authority 2 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 33 | TDTXR2 | Tax Rate 2 | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 34 | TDTA3 | Tax Authority 3 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 35 | TDTXR3 | Tax Rate 3 | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 36 | TDTA4 | Tax Authority 4 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 37 | TDTXR4 | Tax Rate 4 | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 38 | TDTA5 | Tax Authority 5 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 39 | TDTXR5 | Tax Rate 5 | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 40 | TDSTA1 | Amount - Sales Tax Tax Authority 1 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 41 | TDSTA2 | Amount - Sales Tax Tax Authority 2 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 42 | TDSTA3 | Amount - Sales Tax Tax Authority 3 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 43 | TDSTA4 | Amount - Sales Tax Tax Authority 4 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 44 | TDSTA5 | Amount - Sales Tax Tax Authority 5 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 45 | TDPRT1 | Print (Y/N) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 46 | TDOVTX | Tax Override | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 47 | TDTXVA | Amount - Tax Variance | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 48 | TDTXVR | Tax Variance % | Numeric | Generic Edit | 15 | 3 | Allow NULL? |
| 49 | TDPOST | G/L Posted Code | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 50 | TDICU | Batch Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 51 | TDICUT | Batch Type | String | UDC (98 IT) | 2 | 0 | Allow NULL? |
| 52 | TDGDVL | Amount - Goods Value | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 53 | TDCRCD | Currency Code - From | String | Generic Edit | 3 | 0 | Allow NULL? |
| 54 | TDCRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 55 | TDSQNO | Number - Sequence | Numeric | Generic Edit | 7 | 2 | Allow NULL? |
| 56 | TDAG | Amount - Gross | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 57 | TDUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 58 | TDUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 59 | TDPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 60 | TDUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 61 | TDJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 62 | TDAPD | Amount - Paid | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 63 | TDTAXE | Amount - Sales Tax Exempt | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 64 | TDDOC | Document (Voucher Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 65 | TDKCOO | Order Company (Order Number) | String | Generic Edit | 5 | 0 | Allow NULL? |
| 66 | TDPROCFL | Tax Processed Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 67 | TDADJFL | VAT Adjustment Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 68 | TDTOFL | Transaction Origin Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
