| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBulk Distribution Requirements Planning |
1 | OIIGMMS | GMM: Meter/Storage object assignment | 3 | SOCNR | SOC: Storage object characteristic segment number | nvarchar | 20 | 0 | | |
2 | OIISOCTSS | SOC: time dependent assignment SO <-> SO (IS-Oil BDRP) | 2 | SOCNR | SOC: Storage object characteristic segment number | nvarchar | 20 | 0 | | |
3 | OII_DIP_MVMT | Related stock derived from SOC material assignment | 2 | SOCNR | SOC: Storage object characteristic segment number | nvarchar | 20 | 0 | | |
4 | OII_DIP_MVMTO1 | Related stock derived from SOC material assignment | 2 | SOCNR | SOC: Storage object characteristic segment number | nvarchar | 20 | 0 | | |
TOPHydrocarbon Product Management |
5 | OIB_DIP_WORKLIST | Worklist for Silo Management Tank Dips | 3 | SOCNR | SOC: Storage object characteristic segment number | nvarchar | 20 | 0 | | |
TOPInterface to Terminal Automation System |
6 | OIK37 | IS OIL: Shadow table for SD document processing | 7 | SOCNR | SOC: Storage object characteristic segment number | nvarchar | 20 | 0 | | |
TOPService Station Retailing |
7 | OIRADBT | Document base table | 39 | SOCNR | SOC: Storage object characteristic segment number | nvarchar | 20 | 0 | | |
8 | OIRC_DRREJ | SSR Stocks - Dip readings rejected records | 5 | SOCNR | SOC: Storage object characteristic segment number | nvarchar | 20 | 0 | | |
9 | OIRC_SOCDIP | SSR Stocks - Dip readings history | 2 | SOCNR | SOC: Storage object characteristic segment number | nvarchar | 20 | 0 | | |
TOPTraders and Schedulers Workbench |
10 | OIB_TANKDIP | Silo management tank strapping history | 2 | SOCNR | SOC: Storage object characteristic segment number | nvarchar | 20 | 0 | | |
11 | OIISOCAOI | SOC: Storage object characteristic: appl. specific oil & g | 2 | SOCNR | SOC: Storage object characteristic segment number | nvarchar | 20 | 0 | | |
12 | OIISOCB1 | SOC: Storage object characteristic segment: bulk | 2 | SOCNR | SOC: Storage object characteristic segment number | nvarchar | 20 | 0 | | |
13 | OIISOCB2 | SOC: Storage object characteristic segment: packaged | 2 | SOCNR | SOC: Storage object characteristic segment number | nvarchar | 20 | 0 | | |
14 | OIISOCIBL | SOC: Index for business location/sequence no. access mode | 5 | SOCNR | SOC: Storage object characteristic segment number | nvarchar | 20 | 0 | | |
15 | OIISOCIKN | SOC: Index for customer/sequence no. access mode | 4 | SOCNR | SOC: Storage object characteristic segment number | nvarchar | 20 | 0 | | |
16 | OIISOCIMP | SOC: Index for measurement point/sequence no. access mode | 3 | SOCNR | SOC: Storage object characteristic segment number | nvarchar | 20 | 0 | | |
17 | OIISOCISL | SOC: Index for storage location/sequence no. access mode | 5 | SOCNR | SOC: Storage object characteristic segment number | nvarchar | 20 | 0 | | |
18 | OIISOCK | SOC: Storage object characteristic segment header | 2 | SOCNR | SOC: Storage object characteristic segment number | nvarchar | 20 | 0 | | |
19 | OIISOCO1 | SOC: Storage object characteristic segment: bulk | 2 | SOCNR | SOC: Storage object characteristic segment number | nvarchar | 20 | 0 | | |
20 | OIISOCTSM | SOC: time dependent assignment SO <-> material (IS-Oil BDR | 2 | SOCNR | SOC: Storage object characteristic segment number | nvarchar | 20 | 0 | | |
21 | OIISOCTSP | SOC: Assignment SO <-> Plant/Storage location IS-Oil BDRP | 2 | SOCNR | SOC: Storage object characteristic segment number | nvarchar | 20 | 0 | | |
22 | OIISOCTYP | SOC: Storage object type | 4 | SOCNR | SOC: Storage object characteristic segment number | nvarchar | 20 | 0 | | |
23 | OIJBERSOC | Assignment of berths to tanks | 2 | SOCNR | SOC: Storage object characteristic segment number | nvarchar | 20 | 0 | | |
24 | OIJPHYINV | Physical inventory | 3 | SOCNR | SOC: Storage object characteristic segment number | nvarchar | 20 | 0 | | |
25 | OIJRDHTPSET | OIL-TSW: Rundown Rack issue / throughput settings | 4 | SOCNR | SOC: Storage object characteristic segment number | nvarchar | 20 | 0 | | |
26 | OIJTHPUTFC | Rack issue / Throughput forecast | 3 | SOCNR | SOC: Storage object characteristic segment number | nvarchar | 20 | 0 | | |
27 | OIJTHPUTFCAVG | OIL-TSW: Rack issue / Throughput forecast daily average | 3 | SOCNR | SOC: Storage object characteristic segment number | nvarchar | 20 | 0 | | |
28 | OIJTHPUTFCEST | OIL-TSW: Rack issue / Throughput estimate pop-up | 3 | SOCNR | SOC: Storage object characteristic segment number | nvarchar | 20 | 0 | | |
29 | OIJ_EL_TICKET_I | Universal ticket item table | 57 | SOCNR | SOC: Storage object characteristic segment number | nvarchar | 20 | 0 | | |
30 | OIJ_RDHEAD | Stock Projection header | 6 | SOCNR | SOC: Storage object characteristic segment number | nvarchar | 20 | 0 | | |