| 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 | 16 | MTTMP | Oil/Gas Material Temperature: Observed Quantity | float | 15 | 16 | | |
2 | LIPSO1 | Appendix: Delivery Note - Conversion Parameters | 15 | MTTMP | Oil/Gas Material Temperature: Observed Quantity | float | 15 | 16 | | |
3 | MSEGO1 | Quantity Conversion Parameters for Material Documents | 20 | MTTMP | Oil/Gas Material Temperature: Observed Quantity | float | 15 | 16 | | |
4 | OIB09 | Log for missing MSEGO1 and MSEGO2 documents | 29 | MTTMP | Oil/Gas Material Temperature: Observed Quantity | float | 15 | 16 | | |
5 | TVPODO1 | Proof of delivery - Oil conversion parameters | 15 | MTTMP | Oil/Gas Material Temperature: Observed Quantity | float | 15 | 16 | | |
TOPIndustry Solution Oil |
6 | OIB03 | Default value qty.conversion (OBSOLETE,do no use any more) | 10 | MTTMP | Oil/Gas Material Temperature: Observed Quantity | float | 15 | 16 | | |
TOPService Station Retailing |
7 | OIRC_DRREJ | SSR Stocks - Dip readings rejected records | 36 | MTTMP | Oil/Gas Material Temperature: Observed Quantity | float | 15 | 16 | | |
8 | OIRC_FUELS_PR | SSR - Processing profile | 13 | MTTMP | Oil/Gas Material Temperature: Observed Quantity | float | 15 | 16 | | |
9 | OIRC_FUELS_PRMAT | SSR - Processing profile/Material | 12 | MTTMP | Oil/Gas Material Temperature: Observed Quantity | float | 15 | 16 | | |
10 | OIRC_SOCDIP | SSR Stocks - Dip readings history | 33 | MTTMP | Oil/Gas Material Temperature: Observed Quantity | float | 15 | 16 | | |
TOPTraders and Schedulers Workbench |
11 | OIJHCT01 | OIL-TSW: Ticket Holding Table (Draft version 1) - OBSOLETE | 57 | MTTMP | Oil/Gas Material Temperature: Observed Quantity | float | 15 | 16 | | |
12 | OIJ_EL_TICKET_I | Universal ticket item table | 30 | MTTMP | Oil/Gas Material Temperature: Observed Quantity | float | 15 | 16 | | |
13 | OIJ_EL_TKT_I_O1 | Appendix: TSW Ticket item - Conversion Parameters | 17 | MTTMP | Oil/Gas Material Temperature: Observed Quantity | float | 15 | 16 | | |
TOPTransportation and Distribution |
14 | OIGSVMQO1 | TD Quantity Item Calculation Parameters | 16 | MTTMP | Oil/Gas Material Temperature: Observed Quantity | float | 15 | 16 | | |