| 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 | TDDOCO | Document (Order No Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 3 | TDDCTO | Order Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 4 | TDSFXO | Order Suffix | String | Generic Edit | 3 | 0 | Allow NULL? |
| 5 | TDLNID | Line Number | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 6 | TDNLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 7 | TDMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 8 | TDCO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 9 | TDAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 10 | TDKCO | Document Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 11 | TDDOC | Document (Voucher Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 12 | TDDCT | Document Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 13 | TDIVD | Date - Invoice | Date | Generic Edit | 6 | 0 | |
| 14 | TDDGL | Date - For G/L (and Voucher) | Date | Generic Edit | 6 | 0 | |
| 15 | TDLNTY | Line Type | String | Generic Edit | 2 | 0 | Allow NULL? |
| 16 | TDORIG | Country of Origin | String | UDC (00 CN) | 3 | 0 | Allow NULL? |
| 17 | TDORGO | Original Country of Origin | String | UDC (00 CN) | 3 | 0 | Allow NULL? |
| 18 | TDROO | Region of Origin or Destination | String | UDC (00 S) | 3 | 0 | Allow NULL? |
| 19 | TDPOE | Port of Entry or Exit | String | UDC (40 PE) | 6 | 0 | Allow NULL? |
| 20 | TDCDCD | Commodity Code | String | Generic Edit | 15 | 0 | Allow NULL? |
| 21 | TDMOT | Mode of Transport | String | UDC (00 TM) | 3 | 0 | Allow NULL? |
| 22 | TDCOT | Conditions of Transport | String | UDC (00 TC) | 3 | 0 | Allow NULL? |
| 23 | TDCOTX | Conditions of Transport Extension | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 24 | TDNTR | Nature of Transaction | String | UDC (00 NT) | 2 | 0 | Allow NULL? |
| 25 | TDNVAT | Nature of VAT Regime | String | UDC (00 NV) | 5 | 0 | Allow NULL? |
| 26 | TDNCD | Nature Code | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 27 | TDPIND | Process Indicator | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 28 | TDMSAM | Units - Net Mass in KG | Numeric | Generic Edit | 11 | 4 | Allow NULL? |
| 29 | TDSUAM | Units - Supplementary Unit of Measure | Numeric | Generic Edit | 11 | 2 | Allow NULL? |
| 30 | TDATXA | Amount - Taxable | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 31 | TDSAM | Amount - Statistical Value | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 32 | TDURCD | User Reserved Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 33 | TDURDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 34 | TDURAT | User Reserved Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 35 | TDURAB | User Reserved Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 36 | TDURRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 37 | TDUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 38 | TDPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 39 | TDADDJ | Date - Actual Ship Date | Date | Generic Edit | 6 | 0 | |
| 40 | TDRCDJ | Date - Received | Date | Generic Edit | 6 | 0 | |
| 41 | TDCRCD | Currency Code - From | String | Generic Edit | 3 | 0 | Allow NULL? |
| 42 | TDCRDC | Currency Code - To | String | Generic Edit | 3 | 0 | Allow NULL? |
| 43 | TDFSAM | Foreign Statistical Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 44 | TDCTXA | Amount - Foreign Taxable | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 45 | TDFFU1 | IncludeLanguageFlag | Character | UDC (H96 IL) | 1 | 0 | Allow NULL? |
| 46 | TDSHAN | Address Number - Ship To | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
