| 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 | 50 | DEFAULT_GUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
2 | LIPSO1 | Appendix: Delivery Note - Conversion Parameters | 49 | DEFAULT_GUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
3 | MSEGO1 | Quantity Conversion Parameters for Material Documents | 54 | DEFAULT_GUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
4 | OIB09 | Log for missing MSEGO1 and MSEGO2 documents | 90 | DEFAULT_GUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
5 | TVPODO1 | Proof of delivery - Oil conversion parameters | 49 | DEFAULT_GUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
TOPIndustry Solution Oil |
6 | OIB_DEFAULTS | Table for Oil Defaults | 2 | DEFAULT_GUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
7 | OIB_DEF_INDEX_GM | Default index for Goods Movement | 10 | DEFAULT_GUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
TOPService Station Retailing |
8 | OIRC_DRREJ | SSR Stocks - Dip readings rejected records | 70 | DEFAULT_GUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
9 | OIRC_FUELS_PR | SSR - Processing profile | 47 | DEFAULT_GUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
10 | OIRC_FUELS_PRMAT | SSR - Processing profile/Material | 46 | DEFAULT_GUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
11 | OIRC_SOCDIP | SSR Stocks - Dip readings history | 67 | DEFAULT_GUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
TOPTraders and Schedulers Workbench |
12 | OIJ_EL_TKT_I_O1 | Appendix: TSW Ticket item - Conversion Parameters | 51 | DEFAULT_GUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
TOPTransportation and Distribution |
13 | OIGSVMQO1 | TD Quantity Item Calculation Parameters | 50 | DEFAULT_GUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |