| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | TNBNOP | Code - Transaction Nature | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 2 | TNBSOP | Suffix - Transaction Nature | String | Generic Edit | 2 | 0 | Allow NULL? |
| 3 | TNDESC | Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 4 | TNBFII | Code - ICMS Reporting Column (Fiscal B.) | Character | UDC (76 II) | 1 | 0 | Allow NULL? |
| 5 | TNBFIP | Code - IPI Reporting Column (Fiscal B.) | Character | UDC (76 IP) | 1 | 0 | Allow NULL? |
| 6 | TNBFIS | Code - ISS Taxing Type | Character | UDC (76 IS) | 1 | 0 | Allow NULL? |
| 7 | TNBDIP | Code - DIPI Classification | String | Generic Edit | 4 | 0 | Allow NULL? |
| 8 | TNBIST | ICMS Tax Substitution Mark-up | Character | UDC (76 SM) | 1 | 0 | Allow NULL? |
| 9 | TNBST1 | Code - ICMS Tax Situation (Nota Fiscal) | String | UDC (76 ST) | 3 | 0 | Allow NULL? |
| 10 | TNICMS | Special ICMS Tax Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 11 | TNUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 12 | TNPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 13 | TNJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 14 | TNUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 15 | TNTDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
