| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | ITMF_D_NFACCTTAX | Nota fiscal writer configurable accounts for taxes | 4 | TAXGRP | Tax group | nvarchar | 4 | 0 | | |
TOPLocalization |
2 | J_1BAJ | Tax types | 3 | TAXGRP | Tax group | nvarchar | 4 | 0 | | |
3 | J_1BCONDMAP | Internal Codes for Tax Conditions | 3 | TAXGRP | Tax group assigned to internal code of tax conditions | nvarchar | 4 | 0 | | |
4 | J_1BIMPCONDAS | Assign Tax Types to Tax Groups for Import Data Upload | 3 | TAXGRP | Tax group | nvarchar | 4 | 0 | | |
5 | J_1BIMPXLSMAP | Map MS Excel Columns to Data Structure Fields | 4 | TAXGRP | Tax group | nvarchar | 4 | 0 | | |
6 | J_1BKON1 | Brazilian Tax Groups Included in Price Conditions | 5 | TAXGRP | Tax group | nvarchar | 4 | 0 | | |
7 | J_1BNFEPARKTAX | Nota fiscal electronica: Invoice create failed | 16 | TAXGRP | Tax group | nvarchar | 4 | 0 | | |
8 | J_1BNFLWCOND | Tax Law Conditions Interface for Notas Fiscais | 5 | TAXGRP | Tax group | nvarchar | 4 | 0 | | |
9 | J_1BNFSTX | Nota Fiscal tax per item | 28 | TAXGRP | Tax group | nvarchar | 4 | 0 | | |
10 | J_1BTAXGRPCD | Assign Tax Group to SD Internal Codes | 1 | TAXGRP | Tax group | nvarchar | 4 | 0 | | |
TOPTariffs, Duties and Permits |
11 | OIH01 | Excise Duty Rates Table | 4 | TAXGRP | Excise Duty Group | nvarchar | 2 | 0 | | |
12 | OIH01A | Excise Duty Rates Table | 7 | TAXGRP | Excise Duty Group | nvarchar | 2 | 0 | | |
13 | OIH03 | Excise duty posting control | 3 | TAXGRP | Excise Duty Group | nvarchar | 2 | 0 | | |
14 | OIH07 | TDP allowed combinations of ED Group and Handling Type | 4 | TAXGRP | Excise Duty Group | nvarchar | 2 | 0 | | |
15 | OIH07A | TDP allowed combinations of ED Group and Handling Type | 7 | TAXGRP | Excise Duty Group | nvarchar | 2 | 0 | | |
16 | OIH14 | Tax rate revaluation - obsolete | 23 | TAXGRP | Excise Duty Group | nvarchar | 2 | 0 | | |
17 | OIH2 | Excise duty tax group (IS-Oil TDP standard/core object) | 2 | TAXGRP | Excise Duty Group | nvarchar | 2 | 0 | | |
18 | OIH2T | Duty code/tax group description | 3 | TAXGRP | Excise Duty Group | nvarchar | 2 | 0 | | |
19 | OIHLTG | Licence allowed Excise duty tax group for material | 4 | TAXGRP | Excise Duty Group | nvarchar | 2 | 0 | | |
TOPTransportation and Distribution |
20 | TOIGS3 | TD Intransit Batch/Handling Type Determination | 4 | TAXGRP | Excise Duty Group | nvarchar | 2 | 0 | | |