| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | THBNNF | Nota Fiscal Number | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 2 | THBSER | Nota Fiscal Series | String | Generic Edit | 2 | 0 | Allow NULL? |
| 3 | THN001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 4 | THDCT | Document Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 5 | THBRTX | Tax Type - Brazil | String | UDC (76B TR) | 2 | 0 | Allow NULL? |
| 6 | THBRTXB | Tax Basis - Brazil | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 7 | THBRTXA | Tax Amount - Brazil | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 8 | THC1FU | Future Use - Character 1 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 9 | THC2FU | Future Use - Character 1 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 10 | THD1FU | Future Use - Date 1 | Date | Generic Edit | 6 | 0 | |
| 11 | THD2FU | Future Use - Date 2 | Date | Generic Edit | 6 | 0 | |
| 12 | THN1FU | Future Use - Math Numeric 1 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 13 | THN8FU | Future Use - Math Numeric 8 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 14 | THN9FU | Future Use - Math Numeric 9 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 15 | THN10FU | Future Use - Math Numeric 10 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 16 | THN4FU | Future Use Math Numeric 4 | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 17 | THS1FU | Future Use String 1 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 18 | THS3FU | Future Use String 3 | String | Generic Edit | 3 | 0 | Allow NULL? |
| 19 | THGENLNG | Generid Long ID - EnterpriseOne | Identifier (ID) | Generic Edit | 11 | 0 | |
| 20 | THTORG | Transaction Originator | String | Generic Edit | 10 | 0 | Allow NULL? |
| 21 | THUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 22 | THPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 23 | THJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 24 | THUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 25 | THUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |