| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPPlant Master |
1 | T001W | Plants/Branches | 59 | OIHVTYPE | Vendor type (refinery/mill/other) (Brazil) | nvarchar | 1 | 0 | | |
TOPTariffs, Duties and Permits |
2 | OIH2V_J1B | Check table for vendor tax group | 4 | OIHVTYPE | Vendor type (refinery/mill/other) (Brazil) | nvarchar | 1 | 0 | | |
3 | OIH_J1B_COP | Brazil: Controled prices table | 5 | OIHVTYPE | Vendor type (refinery/mill/other) (Brazil) | nvarchar | 1 | 0 | | |
4 | OIH_J1B_CPR | Brazil: Posting exceptions for ICMS complement | 4 | OIHVTYPE | Vendor type (refinery/mill/other) (Brazil) | nvarchar | 1 | 0 | | |
5 | OIH_J1B_INC | Brazil: Incoming taxation table | 4 | OIHVTYPE | Vendor type (refinery/mill/other) (Brazil) | nvarchar | 1 | 0 | | |
6 | OIH_J1B_PCK | Brazil: Check table for tax codes in Purchasing | 3 | OIHVTYPE | Vendor type (refinery/mill/other) (Brazil) | nvarchar | 1 | 0 | | |
7 | OIH_J1B_PIC | Brazil: Printing exceptions for ICMS | 4 | OIHVTYPE | Vendor type (refinery/mill/other) (Brazil) | nvarchar | 1 | 0 | | |
8 | OIH_J1B_PPR | Brazil Tax: Pondered average price table for final consume | 4 | OIHVTYPE | Vendor type (refinery/mill/other) (Brazil) | nvarchar | 1 | 0 | | |
9 | OIH_J1B_RAF | Brazil: Refinery taxation table | 4 | OIHVTYPE | Vendor type (refinery/mill/other) (Brazil) | nvarchar | 1 | 0 | | |
10 | OIH_J1B_SAL | Brazil: Check table for tax codes in sales process | 3 | OIHVTYPE | Vendor type (refinery/mill/other) (Brazil) | nvarchar | 1 | 0 | | |
11 | OIH_J1B_SAL_2 | Brazil: ICMS Deferment | 4 | OIHVTYPE | Vendor type (refinery/mill/other) (Brazil) | nvarchar | 1 | 0 | | |
12 | OIH_J1B_TOU | Brazil: Check table for tax codes in Transfer Outgoing | 3 | OIHVTYPE | Vendor type (refinery/mill/other) (Brazil) | nvarchar | 1 | 0 | | |
13 | OIH_J_1BTXCI1 | Tax calc.: Complement of ICMS rules | 4 | OIHVTYPE | Vendor type (refinery/mill/other) (Brazil) | nvarchar | 1 | 0 | | |
14 | OIH_J_1BTXCI2 | Tax calc.: Complement of ICMS rules INSIDE CALCULATION | 4 | OIHVTYPE | Vendor type (refinery/mill/other) (Brazil) | nvarchar | 1 | 0 | | |
15 | OIH_J_1BTXIC2 | Tax calc.: ICMS rules (exceptions) | 5 | OIHVTYPE | Vendor type (refinery/mill/other) (Brazil) | nvarchar | 1 | 0 | | |
16 | OIH_J_1BTXST1 | Tax calc.: Sub.Trib. rules | 5 | OIHVTYPE | Vendor type (refinery/mill/other) (Brazil) | nvarchar | 1 | 0 | | |