| 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 | | |
