| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | TDBNNF | Nota Fiscal Number | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 2 | TDBSER | Nota Fiscal Series | String | Generic Edit | 2 | 0 | Allow NULL? |
| 3 | TDN001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 4 | TDDCT | Document Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 5 | TDUKID | Unique Key ID (Internal) | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 6 | TDBRTX | Tax Type - Brazil | String | UDC (76B TR) | 2 | 0 | Allow NULL? |
| 7 | TDBRTX2 | Tax Information - Brazil | String | Generic Edit | 8 | 0 | Allow NULL? |
| 8 | TDBRTXB | Tax Basis - Brazil | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 9 | TDBRTXA | Tax Amount - Brazil | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 10 | TDBRTXR | Tax Rate - Brazil | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 11 | TDBRPF | Processed Flag - Brazil | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 12 | TDC1FU | Future Use - Character 1 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 13 | TDC2FU | Future Use - Character 1 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 14 | TDD1FU | Future Use - Date 1 | Date | Generic Edit | 6 | 0 | |
| 15 | TDD2FU | Future Use - Date 2 | Date | Generic Edit | 6 | 0 | |
| 16 | TDR1FU | Future Use - Math Numeric Rate 1 | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 17 | TDN1FU | Future Use - Math Numeric 1 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 18 | TDN8FU | Future Use - Math Numeric 8 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 19 | TDN9FU | Future Use - Math Numeric 9 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 20 | TDN10FU | Future Use - Math Numeric 10 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 21 | TDN4FU | Future Use Math Numeric 4 | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 22 | TDS1FU | Future Use String 1 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 23 | TDS3FU | Future Use String 3 | String | Generic Edit | 3 | 0 | Allow NULL? |
| 24 | TDGENLNG | Generid Long ID - EnterpriseOne | Identifier (ID) | Generic Edit | 11 | 0 | |
| 25 | TDTORG | Transaction Originator | String | Generic Edit | 10 | 0 | Allow NULL? |
| 26 | TDUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 27 | TDPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 28 | TDJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 29 | TDUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 30 | TDUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 31 | TDBN01 | Batch Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 32 | TDICUT | Batch Type | String | UDC (98 IT) | 2 | 0 | Allow NULL? |