| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPHydrocarbon Product Management |
1 | ISEGO1 | Appendix for Physical Inventory Conversion Parameters | 17 | MTTEH | Oil/Gas Material Temperature Unit: Observed Quantity | nvarchar | 3 | 0 | | |
2 | LIPSO1 | Appendix: Delivery Note - Conversion Parameters | 16 | MTTEH | Oil/Gas Material Temperature Unit: Observed Quantity | nvarchar | 3 | 0 | | |
3 | MSEGO1 | Quantity Conversion Parameters for Material Documents | 21 | MTTEH | Oil/Gas Material Temperature Unit: Observed Quantity | nvarchar | 3 | 0 | | |
4 | OIB09 | Log for missing MSEGO1 and MSEGO2 documents | 30 | MTTEH | Oil/Gas Material Temperature Unit: Observed Quantity | nvarchar | 3 | 0 | | |
5 | TVPODO1 | Proof of delivery - Oil conversion parameters | 16 | MTTEH | Oil/Gas Material Temperature Unit: Observed Quantity | nvarchar | 3 | 0 | | |
TOPIndustry Solution Oil |
6 | OIB03 | Default value qty.conversion (OBSOLETE,do no use any more) | 11 | MTTEH | Oil/Gas Material Temperature Unit: Observed Quantity | nvarchar | 3 | 0 | | |
TOPService Station Retailing |
7 | OIRC_DRREJ | SSR Stocks - Dip readings rejected records | 37 | MTTEH | Oil/Gas Material Temperature Unit: Observed Quantity | nvarchar | 3 | 0 | | |
8 | OIRC_FUELS_PR | SSR - Processing profile | 14 | MTTEH | Oil/Gas Material Temperature Unit: Observed Quantity | nvarchar | 3 | 0 | | |
9 | OIRC_FUELS_PRMAT | SSR - Processing profile/Material | 13 | MTTEH | Oil/Gas Material Temperature Unit: Observed Quantity | nvarchar | 3 | 0 | | |
10 | OIRC_SOCDIP | SSR Stocks - Dip readings history | 34 | MTTEH | Oil/Gas Material Temperature Unit: Observed Quantity | nvarchar | 3 | 0 | | |
TOPTraders and Schedulers Workbench |
11 | OIJHCT01 | OIL-TSW: Ticket Holding Table (Draft version 1) - OBSOLETE | 59 | MTTEH | Oil/Gas Material Temperature Unit: Observed Quantity | nvarchar | 3 | 0 | | |
12 | OIJ_EL_TICKET_I | Universal ticket item table | 31 | MTTEH | Oil/Gas Material Temperature Unit: Observed Quantity | nvarchar | 3 | 0 | | |
13 | OIJ_EL_TKT_I_O1 | Appendix: TSW Ticket item - Conversion Parameters | 18 | MTTEH | Oil/Gas Material Temperature Unit: Observed Quantity | nvarchar | 3 | 0 | | |
TOPTransportation and Distribution |
14 | OIGSVMQO1 | TD Quantity Item Calculation Parameters | 17 | MTTEH | Oil/Gas Material Temperature Unit: Observed Quantity | nvarchar | 3 | 0 | | |