| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | FIWTQAD_TAX | Qatar Tax Details | 16 | EXEMPT | Exemption Area | nvarchar | 1 | 0 | | |
2 | IDSAU_CR_DATA | Vendor Certificates | 9 | EXEMPT | Exemption Area | nvarchar | 1 | 0 | | |
TOPLocalization |
3 | J_1BTXCI1 | Tax calc.: Complement of ICMS rules | 8 | EXEMPT | Tax exemption for Complement of ICMS | nvarchar | 1 | 0 | | |
4 | J_1BTXIC2 | Tax calc.: ICMS rules | 10 | EXEMPT | No ICMS calculation - Other base | nvarchar | 1 | 0 | | |
5 | J_1BTXIC3 | Grouped ICMS | 13 | EXEMPT | No ICMS calculation - Other base | nvarchar | 1 | 0 | | |
6 | J_1BTXIP1 | Tax calc.: IPI rules | 6 | EXEMPT | No IPI calculation - Other base | nvarchar | 1 | 0 | | |
7 | J_1BTXIP2 | Tax calc.: IPI rules (material dependent) | 6 | EXEMPT | No IPI calculation - Other base | nvarchar | 1 | 0 | | |
8 | J_1BTXIP3 | Grouped IPI | 9 | EXEMPT | No IPI calculation - Other base | nvarchar | 1 | 0 | | |
9 | J_1BTXSTG | Tax calc.: Sub.Trib. customer group | 3 | EXEMPT | Customer group is Sub.Trib. exempt | nvarchar | 1 | 0 | | |
10 | J_1IEWT_MAPEXMPT | Table for Vendor type/exemption indicators in Annual Returns | 6 | EXEMPT | Reason for exemption | nvarchar | 2 | 0 | | |
TOPRecords and Case Management |
11 | RMPS_PRO_FOI_E | FOI - Exemption | 5 | EXEMPT | FoI Exemption | nvarchar | 4 | 0 | | |
TOPTariffs, Duties and Permits |
12 | OIH_J_1BTXCI1 | Tax calc.: Complement of ICMS rules | 9 | EXEMPT | Tax exemption for Complement of ICMS | nvarchar | 1 | 0 | | |
13 | OIH_J_1BTXIC2 | Tax calc.: ICMS rules (exceptions) | 11 | EXEMPT | No ICMS calculation - Other base | nvarchar | 1 | 0 | | |
TOPUSA |
14 | BTXTTAX | BSI: Test Taxes | 9 | EXEMPT | Exempt | nvarchar | 1 | 0 | | |