Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
---|---|---|---|---|---|---|---|---|---|---|
Contract Accounts Receivable and Payable | ||||||||||
1 | TFK059BRIS | Withholding tax rate maintenance for ISS | 12 | TAXLAW | ISS Tax Law | nvarchar | 3 | 0 | ||
Localization | ||||||||||
2 | J_1BATL1 | Tax Law ICMS | 2 | TAXLAW | Tax law: ICMS | nvarchar | 3 | 0 | ||
3 | J_1BATL1T | Tax Law ICMS - Texts | 3 | TAXLAW | Tax law: ICMS | nvarchar | 3 | 0 | ||
4 | J_1BATL2 | Tax Law IPI | 2 | TAXLAW | Tax law: IPI | nvarchar | 3 | 0 | ||
5 | J_1BATL2T | Tax Law IPI - Texts | 3 | TAXLAW | Tax law: IPI | nvarchar | 3 | 0 | ||
6 | J_1BATL3 | Tax Laws ISS | 2 | TAXLAW | ISS Tax Law | nvarchar | 3 | 0 | ||
7 | J_1BATL3T | Tax Laws ISS - Texts | 3 | TAXLAW | ISS Tax Law | nvarchar | 3 | 0 | ||
8 | J_1BATL4A | Tax Laws COFINS | 2 | TAXLAW | COFINS Tax Law | nvarchar | 3 | 0 | ||
9 | J_1BATL4T | Tax Laws COFINS - Texts | 3 | TAXLAW | COFINS Tax Law | nvarchar | 3 | 0 | ||
10 | J_1BATL5 | Tax Laws PIS | 2 | TAXLAW | PIS Tax Law | nvarchar | 3 | 0 | ||
11 | J_1BATL5T | Tax Laws PIS - Texts | 3 | TAXLAW | PIS Tax Law | nvarchar | 3 | 0 | ||
12 | J_1BTXCOF | Tax Calculation: COFINS | 15 | TAXLAW | COFINS Tax Law | nvarchar | 3 | 0 | ||
13 | J_1BTXIC2 | Tax calc.: ICMS rules | 11 | TAXLAW | Tax law: ICMS | nvarchar | 3 | 0 | ||
14 | J_1BTXIC3 | Grouped ICMS | 14 | TAXLAW | Tax law: ICMS | nvarchar | 3 | 0 | ||
15 | J_1BTXIP1 | Tax calc.: IPI rules | 7 | TAXLAW | Tax law: IPI | nvarchar | 3 | 0 | ||
16 | J_1BTXIP2 | Tax calc.: IPI rules (material dependent) | 7 | TAXLAW | Tax law: IPI | nvarchar | 3 | 0 | ||
17 | J_1BTXIP3 | Grouped IPI | 10 | TAXLAW | Tax law: IPI | nvarchar | 3 | 0 | ||
18 | J_1BTXISS | Tax Calculation: ISS | 12 | TAXLAW | ISS Tax Law | nvarchar | 3 | 0 | ||
19 | J_1BTXPIS | Tax Calculation: PIS | 15 | TAXLAW | PIS Tax Law | nvarchar | 3 | 0 | ||
Tariffs, Duties and Permits | ||||||||||
20 | OIH_J_1BATL4 | Tax Law PIS/COFINS | 2 | TAXLAW | Tax law: PIS/COFINS | nvarchar | 3 | 0 | ||
21 | OIH_J_1BATL4T | Tax Law ICMS - Texts | 3 | TAXLAW | Tax law: PIS/COFINS | nvarchar | 3 | 0 | ||
22 | OIH_J_1BTXIC2 | Tax calc.: ICMS rules (exceptions) | 12 | TAXLAW | Tax law: ICMS | nvarchar | 3 | 0 |