| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPFinancial Accounting |
1 | /OPT/VIM_1HEAD | Document Header | 214 | NFNUM9 | Nine-Digit NF-e Number | nvarchar | 9 | 0 | | |
TOPLocalization |
2 | J_1BCTE_D_DOCREF | Reference to the NF-e being transported | 13 | NFNUM9 | Nine-Digit Document Number | nvarchar | 9 | 0 | | |
3 | J_1BCTE_D_REF | Reference to the NF-e being transported | 13 | NFNUM9 | Nine-Digit Document Number | nvarchar | 9 | 0 | | |
4 | J_1BNFEPARKDOC | Nota fiscal electronica: Invoice create failed | 8 | NFNUM9 | Nine-Digit Document Number | nvarchar | 9 | 0 | | |
5 | J_1BNFEPARKLIN | Nota fiscal electronica: Invoice create failed | 8 | NFNUM9 | Nine-Digit Document Number | nvarchar | 9 | 0 | | |
6 | J_1BNFEPARKTAX | Nota fiscal electronica: Invoice create failed | 8 | NFNUM9 | Nine-Digit Document Number | nvarchar | 9 | 0 | | |
7 | J_1BNFE_ACTIVE | Electronic Nota Fiscal: Actual Status | 14 | NFNUM9 | Nine-Digit Document Number | nvarchar | 9 | 0 | | |
8 | J_1BNFE_HISTORY | Electronic Nota Fiscal - History | 22 | NFNUM9 | Nine-Digit Document Number | nvarchar | 9 | 0 | | |
9 | J_1BNFE_INVALID | Electronic Nota Fiscal: Invalid Status Actions | 17 | NFNUM9 | Nine-Digit Document Number | nvarchar | 9 | 0 | | |