| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | TRDOCO | Document (Order No Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | TRKCOO | Order Company (Order Number) | String | Generic Edit | 5 | 0 | Allow NULL? |
| 3 | TRLNID | Line Number | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 4 | TRI75TTN | TCS Tax Name | String | Generic Edit | 30 | 0 | Allow NULL? |
| 5 | TRDCTO | Order Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 6 | TRAEXP | Amount - Extended Price | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 7 | TRI75TTR | TCS Tax Rate | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 8 | TRI75TOT | Total TCS Tax | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 9 | TRCUSTSUP | Customer Supplier Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 10 | TRAVCO | Amount - Average Cost Difference | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 11 | TRCO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 12 | TRDCT | Document Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 13 | TRDGL | Date - For G/L (and Voucher) | Date | Generic Edit | 6 | 0 | |
| 14 | TRLITM | 2nd Item Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 15 | TRDOC | Document (Voucher Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 16 | TRIVD | Date - Invoice | Date | Generic Edit | 6 | 0 | |
| 17 | TRJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 18 | TRKCO | Document Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 19 | TRMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 20 | TRPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 21 | TRSOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 22 | TRUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 23 | TRUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 24 | TRUPRC | Amount - Price per Unit | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 25 | TRUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 26 | TRI75CHNO | Challan No | String | Generic Edit | 60 | 0 | Allow NULL? |
| 27 | TRI75PYD | Payment Date | Date | Generic Edit | 6 | 0 | |
| 28 | TRI75VNBR | Voucher Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 29 | TRFLAG | Journaling Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 30 | TRAID2 | Account ID | String | Generic Edit | 8 | 0 | Allow NULL? |
| 31 | TRVINV | Supplier Invoice Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 32 | TREV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 33 | TRAN8V | Address Number - Supplier | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
