| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | TFCO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 2 | TFMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 3 | TFITPL | Item Pool | String | UDC (41 05) | 10 | 0 | Allow NULL? |
| 4 | TFITM | Item Number - Short | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 5 | TFCRCD | Currency Code - From | String | Generic Edit | 3 | 0 | Allow NULL? |
| 6 | TFDCT | Document Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 7 | TFEV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 8 | TFTRUM | Unit of Measure - Transaction | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 9 | TFTRQT | Quantity Available | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 10 | TFUNCS | Amount - Unit Cost | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 11 | TFPAID | Amount - Extended Cost/Price | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 12 | TFTNTP | Transaction Type | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 13 | TFTRDJ | Date - Order/Transaction | Date | Generic Edit | 6 | 0 | |
| 14 | TFSVYR | Fiscal Year | Numeric | Generic Edit | 4 | 0 | Allow NULL? |
| 15 | TFPNC | Period Number - Current | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 16 | TFDOCO | Document (Order No Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 17 | TFDCTO | Order Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 18 | TFLNID | Line Number | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 19 | TFNLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 20 | TFOITM | Item Number - Short Overrides | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 21 | TFFYR | Fiscal Year | Numeric | Generic Edit | 4 | 0 | Allow NULL? |
| 22 | TFPN | Period Number - General Ledger | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 23 | TFDGL | Date - For G/L (and Voucher) | Date | Generic Edit | 6 | 0 | |
| 24 | TFCALD | Number of Periods - Normal | String | UDC (H00 CA) | 2 | 0 | Allow NULL? |
| 25 | TFCDEC | Display Decimals | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 26 | TFUKID | Unique Key ID (Internal) | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
