| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPLocalization |
1 | J_1BAA | Nota Fiscal type | 13 | SHIPFROM | Sending Tax Jurisdiction | nvarchar | 1 | 0 | | |
2 | J_1BTXIC1 | Tax calc.: ICMS general rules | 3 | SHIPFROM | Ship from location (tax region) | nvarchar | 3 | 0 | | |
3 | J_1BTXIC2 | Tax calc.: ICMS rules | 3 | SHIPFROM | Ship from location (tax region) | nvarchar | 3 | 0 | | |
4 | J_1BTXIC3 | Grouped ICMS | 3 | SHIPFROM | Ship from location (tax region) | nvarchar | 3 | 0 | | |
5 | J_1BTXIS3 | Grouped ISS | 3 | SHIPFROM | Ship from location (tax region) | nvarchar | 3 | 0 | | |
6 | J_1BTXST1 | Tax calc.: Sub.Trib. rules | 3 | SHIPFROM | Ship from location (tax region) | nvarchar | 3 | 0 | | |
7 | J_1BTXST2 | Tax calc.: Sub.Trib. rules (general) | 3 | SHIPFROM | Ship from location (tax region) | nvarchar | 3 | 0 | | |
8 | J_1BTXST3 | Dynamic Calculation of Substituição Tributária | 3 | SHIPFROM | Ship from location (tax region) | nvarchar | 3 | 0 | | |
9 | J_1IEXCDTL | Excise invoice line item details | 12 | SHIPFROM | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | |
10 | J_1IEXCHDR | Excise invoice header detail | 15 | SHIPFROM | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | |
11 | J_1IRG23D | RG23D register for the depot | 22 | SHIPFROM | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | |
TOPTariffs, Duties and Permits |
12 | OIH_J_1BTXIC2 | Tax calc.: ICMS rules (exceptions) | 3 | SHIPFROM | Ship from location (tax region) | nvarchar | 3 | 0 | | |
13 | OIH_J_1BTXIX1 | Tax calc.: ISS rules for sales and purchasing exeptions | 3 | SHIPFROM | Ship from location (tax region) | nvarchar | 3 | 0 | | |
14 | OIH_J_1BTXST1 | Tax calc.: Sub.Trib. rules | 3 | SHIPFROM | Ship from location (tax region) | nvarchar | 3 | 0 | | |