| 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 | 349 | UOMGR | Unit of Mearsure Group (Oil, Natural Gas,...) | nvarchar | 3 | 0 | | |
2 | OIB_CPE_UOMS | Additional UOMs for Commodity Pricing Engine for Dynamic QCI | 2 | UOMGR | Unit of Mearsure Group (Oil, Natural Gas,...) | nvarchar | 3 | 0 | | |
TOPCross-Application Components |
3 | MMARC | Plant Data for Material | 153 | UOMGR | Unit of Mearsure Group (Oil, Natural Gas,...) | nvarchar | 3 | 0 | | |
TOPHydrocarbon Product Management |
4 | OIB05 | Oil unit of measure groups | 2 | UOMGR | Unit of Mearsure Group (Oil, Natural Gas,...) | nvarchar | 3 | 0 | | |
5 | OIB06T | Unit of Measure group description | 3 | UOMGR | Unit of Mearsure Group (Oil, Natural Gas,...) | nvarchar | 3 | 0 | | |
6 | OIB08 | Log for HIM Quantities out of sync with SKU | 13 | UOMGR | Unit of Mearsure Group (Oil, Natural Gas,...) | nvarchar | 3 | 0 | | |
7 | OIB09 | Log for missing MSEGO1 and MSEGO2 documents | 10 | UOMGR | Unit of Mearsure Group (Oil, Natural Gas,...) | nvarchar | 3 | 0 | | |
8 | OIB_MIGO_HQCI | Store the QCI-GOITEM for MIGOs hold/restore feature | 9 | UOMGR | Unit of Mearsure Group (Oil, Natural Gas,...) | nvarchar | 3 | 0 | | |
TOPLogistics - General |
9 | OIB06 | HPM Unit of Measurement Group: Definition | 2 | UOMGR | Unit of Mearsure Group (Oil, Natural Gas,...) | nvarchar | 3 | 0 | | |
TOPMaterial Master |
10 | MARC | Plant Data for Material | 153 | UOMGR | Unit of Mearsure Group (Oil, Natural Gas,...) | nvarchar | 3 | 0 | | |
11 | MARC_TMP | File for Incorrect Data in Direct Input | 156 | UOMGR | Unit of Mearsure Group (Oil, Natural Gas,...) | nvarchar | 3 | 0 | | |
12 | MVRC | Cross-version fields for MARC | 153 | UOMGR | Unit of Mearsure Group (Oil, Natural Gas,...) | nvarchar | 3 | 0 | | |
TOPProduction and Revenue Accounting |
13 | OIUP_ME_MEDOC | Measurement document header (PDM Shadow) | 12 | UOMGR | unit of measure group | nvarchar | 3 | 0 | | |
14 | OIU_ME_MEDOC | Measurement document header | 11 | UOMGR | unit of measure group | nvarchar | 3 | 0 | | |
15 | OIU_ME_RTYPE_CH | Reading Type Characteristics | 3 | UOMGR | unit of measure group | nvarchar | 3 | 0 | | |
16 | OIU_ME_UOM_GR | PRA Measurement: Unit of Measurement Groups | 2 | UOMGR | unit of measure group | nvarchar | 3 | 0 | | |
17 | OIU_ME_UOM_GR_AS | PRA Measurement: Unit of Measurement Group Assignment | 2 | UOMGR | unit of measure group | nvarchar | 3 | 0 | | |
18 | OIU_ME_UOM_GR_TX | PRA Measurement: Unit of Measurement Group Texts | 3 | UOMGR | unit of measure group | nvarchar | 3 | 0 | | |
TOPTraders and Schedulers Workbench |
19 | OIISOCTSM | SOC: time dependent assignment SO <-> material (IS-Oil BDR | 16 | UOMGR | Unit of Mearsure Group (Oil, Natural Gas,...) | nvarchar | 3 | 0 | | |