| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPInterface to Terminal Automation System |
| 1 | OIK01 | IS-OIL/TAS: LID Document Data | 70 | SHIPTO | Ship-to party | nvarchar | 10 | 0 | | |
| 2 | OIK01D | IS-OIL/TAS: deactivated LID Document Data | 71 | SHIPTO | Ship-to party | nvarchar | 10 | 0 | | |
| 3 | OIKCF | TAS - Control Field Data | 6 | SHIPTO | Ship-to party | nvarchar | 10 | 0 | | |
| 4 | OIKCFW | TAS - Control Field Data | 6 | SHIPTO | Ship-to party | nvarchar | 10 | 0 | | |
| 5 | OIKLID | TAS active LIDs(NOTE:keep eq to DB OIKLIDW->append includes) | 37 | SHIPTO | Ship-to party | nvarchar | 10 | 0 | | |
| 6 | OIKLIDR | TD - TAS Reference Table | 37 | SHIPTO | Ship-to party | nvarchar | 10 | 0 | | |
| 7 | OIKLIDW | TAS LID Working version (NOTE: keep DB eq to DB OIKLID) | 37 | SHIPTO | Ship-to party | nvarchar | 10 | 0 | | |
| 8 | OIKTT | TPI:Trip planning times-for customer use (Enhancem.OIKSHPSV) | 6 | SHIPTO | Ship-to party | nvarchar | 10 | 0 | | |
| TOPLocalization |
| 9 | J_1BTXCI1 | Tax calc.: Complement of ICMS rules | 3 | SHIPTO | Ship to location (tax region) | nvarchar | 3 | 0 | | |
| 10 | J_1BTXIC1 | Tax calc.: ICMS general rules | 4 | SHIPTO | Ship to location (tax region) | nvarchar | 3 | 0 | | |
| 11 | J_1BTXIC2 | Tax calc.: ICMS rules | 4 | SHIPTO | Ship to location (tax region) | nvarchar | 3 | 0 | | |
| 12 | J_1BTXIC3 | Grouped ICMS | 4 | SHIPTO | Ship to location (tax region) | nvarchar | 3 | 0 | | |
| 13 | J_1BTXIS3 | Grouped ISS | 4 | SHIPTO | Ship to location (tax region) | nvarchar | 3 | 0 | | |
| 14 | J_1BTXST1 | Tax calc.: Sub.Trib. rules | 4 | SHIPTO | Ship to location (tax region) | nvarchar | 3 | 0 | | |
| 15 | J_1BTXST2 | Tax calc.: Sub.Trib. rules (general) | 4 | SHIPTO | Ship to location (tax region) | nvarchar | 3 | 0 | | |
| 16 | J_1BTXST3 | Dynamic Calculation of Substituição Tributária | 4 | SHIPTO | Ship to location (tax region) | nvarchar | 3 | 0 | | |
| TOPMedia Product Sales and Distribution |
| 17 | JKSDCONTRACTCHAR | Additional Fields for Sales Quantity Planning | 4 | SHIPTO | IS-M: Retailer | nvarchar | 10 | 0 | | |
| 18 | JKSDNOSUPPLYINDX | Index Table of Constant Services w/o Supply | 7 | SHIPTO | IS-M: Ship-to Party | nvarchar | 10 | 0 | | |
| 19 | JKSDORDERINDEX | Index Table for IS-M Orders | 5 | SHIPTO | IS-M: Ship-to Party | nvarchar | 10 | 0 | | |
| 20 | JKSECONTRINDEX | Index Table for IS-M Contracts | 13 | SHIPTO | IS-M: Ship-to Party | nvarchar | 10 | 0 | | |
| TOPTariffs, Duties and Permits |
| 21 | OIH_J1B_RAF | Brazil: Refinery taxation table | 3 | SHIPTO | Tax Region | nvarchar | 3 | 0 | | |
| 22 | OIH_J_1BTXCI1 | Tax calc.: Complement of ICMS rules | 3 | SHIPTO | Ship to location (tax region) | nvarchar | 3 | 0 | | |
| 23 | OIH_J_1BTXCI2 | Tax calc.: Complement of ICMS rules INSIDE CALCULATION | 3 | SHIPTO | Ship to location (tax region) | nvarchar | 3 | 0 | | |
| 24 | OIH_J_1BTXIC2 | Tax calc.: ICMS rules (exceptions) | 4 | SHIPTO | Ship to location (tax region) | nvarchar | 3 | 0 | | |
| 25 | OIH_J_1BTXIS1 | Tax calc.: ISS rules for sales exeptions | 4 | SHIPTO | Ship to location (tax region) | nvarchar | 3 | 0 | | |
| 26 | OIH_J_1BTXIX1 | Tax calc.: ISS rules for sales and purchasing exeptions | 4 | SHIPTO | Ship to location (tax region) | nvarchar | 3 | 0 | | |
| 27 | OIH_J_1BTXST1 | Tax calc.: Sub.Trib. rules | 4 | SHIPTO | Ship to location (tax region) | nvarchar | 3 | 0 | | |
