| 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 | 48 | HVCLS | Heating value class (calorific value class) | nvarchar | 2 | 0 | | |
2 | LIPSO1 | Appendix: Delivery Note - Conversion Parameters | 47 | HVCLS | Heating value class (calorific value class) | nvarchar | 2 | 0 | | |
3 | MSEGO1 | Quantity Conversion Parameters for Material Documents | 52 | HVCLS | Heating value class (calorific value class) | nvarchar | 2 | 0 | | |
4 | OIB09 | Log for missing MSEGO1 and MSEGO2 documents | 88 | HVCLS | Heating value class (calorific value class) | nvarchar | 2 | 0 | | |
5 | TVPODO1 | Proof of delivery - Oil conversion parameters | 47 | HVCLS | Heating value class (calorific value class) | nvarchar | 2 | 0 | | |
TOPProduction and Revenue Accounting |
6 | OIU_PR_MPVD | PRA: Measurement Point Variable Data | 5 | HVCLS | Heating value class (calorific value class) | nvarchar | 2 | 0 | | |
7 | OIU_PR_WCVD | Well Completion Variable Data | 6 | HVCLS | Heating value class (calorific value class) | nvarchar | 2 | 0 | | |
TOPService Station Retailing |
8 | OIRC_DRREJ | SSR Stocks - Dip readings rejected records | 68 | HVCLS | Heating value class (calorific value class) | nvarchar | 2 | 0 | | |
9 | OIRC_FUELS_PR | SSR - Processing profile | 45 | HVCLS | Heating value class (calorific value class) | nvarchar | 2 | 0 | | |
10 | OIRC_FUELS_PRMAT | SSR - Processing profile/Material | 44 | HVCLS | Heating value class (calorific value class) | nvarchar | 2 | 0 | | |
11 | OIRC_SOCDIP | SSR Stocks - Dip readings history | 65 | HVCLS | Heating value class (calorific value class) | nvarchar | 2 | 0 | | |
TOPTraders and Schedulers Workbench |
12 | OIJ_EL_TKT_I_O1 | Appendix: TSW Ticket item - Conversion Parameters | 49 | HVCLS | Heating value class (calorific value class) | nvarchar | 2 | 0 | | |
TOPTransportation and Distribution |
13 | OIGSVMQO1 | TD Quantity Item Calculation Parameters | 48 | HVCLS | Heating value class (calorific value class) | nvarchar | 2 | 0 | | |