| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPTariffs, Duties and Permits |
1 | OIH_J1B_APR | Brazil tax: Acquisition price table | 5 | MTXGR | Material tax group | nvarchar | 4 | 0 | | |
2 | OIH_J1B_COP | Brazil: Controled prices table | 7 | MTXGR | Material tax group | nvarchar | 4 | 0 | | |
3 | OIH_J1B_FAC | Brazil: Factor for calculation of PIS / COFINS ST | 3 | MTXGR | Material tax group | nvarchar | 4 | 0 | | |
4 | OIH_J1B_INC | Brazil: Incoming taxation table | 6 | MTXGR | Material tax group | nvarchar | 4 | 0 | | |
5 | OIH_J1B_PIS | Brazil: PIS/COFINS taxation table (exactly one entry) | 5 | MTXGR | Material tax group | nvarchar | 4 | 0 | | |
6 | OIH_J1B_PPR | Brazil Tax: Pondered average price table for final consume | 6 | MTXGR | Material tax group | nvarchar | 4 | 0 | | |
7 | OIH_J1B_RAF | Brazil: Refinery taxation table | 6 | MTXGR | Material tax group | nvarchar | 4 | 0 | | |
8 | OIH_J1B_SAL_2 | Brazil: ICMS Deferment | 6 | MTXGR | Material tax group | nvarchar | 4 | 0 | | |
9 | OIH_J1B_ZFD | Brazil tax: Sub. Trib. Discount for Zona Franca de Manaus | 4 | MTXGR | Material tax group | nvarchar | 4 | 0 | | |