| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /SMERP/STG_MM001 | Data staging - Material master plant view complex table | 350 | UMRSL | Conversion Group (Oil, Natural Gas,..) | nvarchar | 4 | 0 | | |
| 2 | OIB_CPE_UOMS | Additional UOMs for Commodity Pricing Engine for Dynamic QCI | 3 | UMRSL | Conversion Group (Oil, Natural Gas,..) | nvarchar | 4 | 0 | | |
| TOPCross-Application Components |
| 3 | MMARC | Plant Data for Material | 154 | UMRSL | Conversion Group (Oil, Natural Gas,..) | nvarchar | 4 | 0 | | |
| TOPHydrocarbon Product Management |
| 4 | ISEGO1 | Appendix for Physical Inventory Conversion Parameters | 5 | UMRSL | Conversion Group (Oil, Natural Gas,..) | nvarchar | 4 | 0 | | |
| 5 | LIPSO1 | Appendix: Delivery Note - Conversion Parameters | 4 | UMRSL | Conversion Group (Oil, Natural Gas,..) | nvarchar | 4 | 0 | | |
| 6 | MSEGO1 | Quantity Conversion Parameters for Material Documents | 9 | UMRSL | Conversion Group (Oil, Natural Gas,..) | nvarchar | 4 | 0 | | |
| 7 | OIB08 | Log for HIM Quantities out of sync with SKU | 15 | UMRSL | Conversion Group (Oil, Natural Gas,..) | nvarchar | 4 | 0 | | |
| 8 | OIB09 | Log for missing MSEGO1 and MSEGO2 documents | 18 | UMRSL | Conversion Group (Oil, Natural Gas,..) | nvarchar | 4 | 0 | | |
| 9 | OIB_MIGO_HQCI | Store the QCI-GOITEM for MIGOs hold/restore feature | 8 | UMRSL | Conversion Group (Oil, Natural Gas,..) | nvarchar | 4 | 0 | | |
| 10 | TVPODO1 | Proof of delivery - Oil conversion parameters | 4 | UMRSL | Conversion Group (Oil, Natural Gas,..) | nvarchar | 4 | 0 | | |
| TOPIndustry Solution Oil |
| 11 | OIB01T | Conversion Group Text | 3 | UMRSL | Conversion Group (Oil, Natural Gas,..) | nvarchar | 4 | 0 | | |
| 12 | OIB04 | Function module definition (API/AGA/Customer functions) | 2 | UMRSL | Conversion Group (Oil, Natural Gas,..) | nvarchar | 4 | 0 | | |
| 13 | OIB_AROM_HEADER | header data table: Industrial aromatic hydrocarbon vcf | 3 | UMRSL | Conversion Group (Oil, Natural Gas,..) | nvarchar | 4 | 0 | | |
| 14 | OIB_AROM_HEADERT | Text table for OIB_AROM_HEADER | 4 | UMRSL | Conversion Group (Oil, Natural Gas,..) | nvarchar | 4 | 0 | | |
| 15 | OIB_AROM_VCF | Customizing table for Aromatics Volume Correction factors | 3 | UMRSL | Conversion Group (Oil, Natural Gas,..) | nvarchar | 4 | 0 | | |
| 16 | OIB_CONV_RDGRP | Table for classification Conversiongrp - Readinggrp | 2 | UMRSL | Conversion Group (Oil, Natural Gas,..) | nvarchar | 4 | 0 | | |
| 17 | OIB_CONV_UOM | Assignment of Units between Conv. Group and T006 | 2 | UMRSL | Conversion Group (Oil, Natural Gas,..) | nvarchar | 4 | 0 | | |
| 18 | OIB_CONV_UOM_TX | Assignment of Units between Conv. Group and T006 | 2 | UMRSL | Conversion Group (Oil, Natural Gas,..) | nvarchar | 4 | 0 | | |
| TOPLogistics - General |
| 19 | OIB01 | Definition of Conversion Groups | 2 | UMRSL | Conversion Group (Oil, Natural Gas,..) | nvarchar | 4 | 0 | | |
| TOPMaterial Master |
| 20 | MARC | Plant Data for Material | 154 | UMRSL | Conversion Group (Oil, Natural Gas,..) | nvarchar | 4 | 0 | | |
| 21 | MARC_TMP | File for Incorrect Data in Direct Input | 157 | UMRSL | Conversion Group (Oil, Natural Gas,..) | nvarchar | 4 | 0 | | |
| 22 | MVRC | Cross-version fields for MARC | 154 | UMRSL | Conversion Group (Oil, Natural Gas,..) | nvarchar | 4 | 0 | | |
| TOPProduction and Revenue Accounting |
| 23 | OIUP_ME_MEDOC | Measurement document header (PDM Shadow) | 13 | UMRSL | Conversion Group (Oil, Natural Gas,..) | nvarchar | 4 | 0 | | |
| 24 | OIU_ME_MEDOC | Measurement document header | 12 | UMRSL | Conversion Group (Oil, Natural Gas,..) | nvarchar | 4 | 0 | | |
| 25 | OIU_PAR | Obsolete | 4 | UMRSL | Conversion Group (Oil, Natural Gas,..) | nvarchar | 4 | 0 | | |
| TOPService Station Retailing |
| 26 | OIRC_DRREJ | SSR Stocks - Dip readings rejected records | 25 | UMRSL | Conversion Group (Oil, Natural Gas,..) | nvarchar | 4 | 0 | | |
| 27 | OIRC_SOCDIP | SSR Stocks - Dip readings history | 22 | UMRSL | Conversion Group (Oil, Natural Gas,..) | nvarchar | 4 | 0 | | |
| TOPTraders and Schedulers Workbench |
| 28 | OIISOCTSM | SOC: time dependent assignment SO <-> material (IS-Oil BDR | 17 | UMRSL | Conversion Group (Oil, Natural Gas,..) | nvarchar | 4 | 0 | | |
| 29 | OIJ_EL_TKT_I_O1 | Appendix: TSW Ticket item - Conversion Parameters | 6 | UMRSL | Conversion Group (Oil, Natural Gas,..) | nvarchar | 4 | 0 | | |
| TOPTransportation and Distribution |
| 30 | OIGSVMQO1 | TD Quantity Item Calculation Parameters | 5 | UMRSL | Conversion Group (Oil, Natural Gas,..) | nvarchar | 4 | 0 | | |
