| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBulk Distribution Requirements Planning |
1 | OIIGMMH | GMM: Meter history | 19 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
2 | OIIGMMK | GMM: General meter header table | 32 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
3 | OIIGMMM | GMM: Meter/Material assignment | 13 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
4 | OIIOTWSK | BDRP-OTWS: Operations time window set header | 9 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
5 | OIISCPWK | SCP: Site control parameters (plant) - IS-Oil BDRP | 43 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
6 | OIISLVCH | Silo calibration history index | 13 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
7 | OIISLVCKO | Silo: Calibration - LVC (strap) set header | 36 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
8 | OIISOCTSS | SOC: time dependent assignment SO <-> SO (IS-Oil BDRP) | 13 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
TOPLogistics - General |
9 | OIFSPBL | Physical Location - Master Data | 19 | BLOIND | Block Indicator | nvarchar | 1 | 0 | | |
10 | OIJTS | Transport system (IS-Oil TSW standard/core object ) | 36 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
TOPMarketing Retail Network |
11 | OIFBBP1 | Business partner role assignments (IS-Oil MRN) | 13 | BLOIND | Block Indicator | nvarchar | 1 | 0 | | |
12 | OIFDD1 | Delivery point info for bulk delivery preplannning | 38 | BLOIND | Block Indicator | nvarchar | 1 | 0 | | |
13 | OIFDDM1 | Del. point/material info for bulk delivery planning | 24 | BLOIND | Block Indicator | nvarchar | 1 | 0 | | |
14 | OIFDDM2 | Del. point/material/tank (bulk delivery planning) | 13 | BLOIND | Block Indicator | nvarchar | 1 | 0 | | |
15 | OIFDDM3 | Del. point/material/meter (bulk delivery planning) | 14 | BLOIND | Block Indicator | nvarchar | 1 | 0 | | |
16 | OIFDTT1 | Tank type table - bulk delivery planning | 14 | BLOIND | Block Indicator | nvarchar | 1 | 0 | | |
17 | OIFOANLA | Object links - FI-AA asset master (IS-Oil MRN) | 10 | BLOIND | Block Indicator | nvarchar | 1 | 0 | | |
18 | OIFOCEPC | Object links - CO-PCA profit center (IS-Oil MRN) | 10 | BLOIND | Block Indicator | nvarchar | 1 | 0 | | |
19 | OIFOCOAS | Object links - CO order (IS-Oil MRN) | 10 | BLOIND | Block Indicator | nvarchar | 1 | 0 | | |
20 | OIFOCSKS | Object links - CO cost center (IS-Oil MRN) | 10 | BLOIND | Block Indicator | nvarchar | 1 | 0 | | |
21 | OIFOIFLO | Object links - PM functional location (IS-Oil MRN) | 10 | BLOIND | Block Indicator | nvarchar | 1 | 0 | | |
22 | OIFOPROJ | Object links - PS project or project item (IS-Oil MRN) | 10 | BLOIND | Block Indicator | nvarchar | 1 | 0 | | |
23 | OIFOT001L | Object links - CA storage location (IS-Oil MRN) | 10 | BLOIND | Block Indicator | nvarchar | 1 | 0 | | |
24 | OIFOT001W | Object links - CA Plant (IS-Oil MRN) | 10 | BLOIND | Block Indicator | nvarchar | 1 | 0 | | |
TOPService Station Retailing |
25 | OIRBOANLA | Object links - FI-AA asset master (IS-Oil SSR) | 11 | BLOIND | Block Indicator | nvarchar | 1 | 0 | | |
26 | OIRBOCEPC | Object links - CO-PCA profit center (IS-Oil SSR) | 11 | BLOIND | Block Indicator | nvarchar | 1 | 0 | | |
27 | OIRBOCOAS | Object links - CO order (IS-Oil SSR) | 11 | BLOIND | Block Indicator | nvarchar | 1 | 0 | | |
28 | OIRBOCSKS | Object links - CO cost center (IS-Oil SSR) | 11 | BLOIND | Block Indicator | nvarchar | 1 | 0 | | |
29 | OIRBOIFLO | Object links - PM functional location (IS-Oil SSR) | 11 | BLOIND | Block Indicator | nvarchar | 1 | 0 | | |
30 | OIRBOMMT001L | Object links - CA storage location (IS-Oil MRN) | 10 | BLOIND | Block Indicator | nvarchar | 1 | 0 | | |
31 | OIRBOPROJ | Object links - PS project or project item (IS-Oil SSR) | 11 | BLOIND | Block Indicator | nvarchar | 1 | 0 | | |
32 | OIRBOT001L | Object links - CA storage location (IS-Oil SSR) | 11 | BLOIND | Block Indicator | nvarchar | 1 | 0 | | |
33 | OIRBOT001W | Object links - CA Plant (IS-Oil SSR) | 11 | BLOIND | Block Indicator | nvarchar | 1 | 0 | | |
34 | OIRBPBLB | Business location at business type level (IS-OIL SSR) | 29 | BLOIND | Block Indicator | nvarchar | 1 | 0 | | |
35 | OIRC_DRREJ | SSR Stocks - Dip readings rejected records | 77 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
36 | OIRC_GMMH | SSR Meters - History | 61 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
37 | OIRC_GMMH_DEL | SSR Meters - Deleted meter readings history | 62 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
38 | OIRC_MRREJ | SSR Meters - Meter readings rejected records | 64 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
39 | OIRC_PRCHK | SSR Pricing - Price check | 28 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
40 | OIRC_SOCDIP | SSR Stocks - Dip readings history | 74 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
TOPTraders and Schedulers Workbench |
41 | OIB_TANKDIP | Silo management tank strapping history | 25 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
42 | OIFBRF1 | Business partner roles (IS-Oil MRN) | 4 | BLOIND | Block Indicator | nvarchar | 1 | 0 | | |
43 | OIISCPBL | SCP: Site control parameters (business loc) - IS-Oil BDRP | 45 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
44 | OIISCPKN | SCP: Site control parameters (customer) - IS-Oil BDRP | 43 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
45 | OIISLVCK | SOC: Linear/volumetric conversion (strap) set header | 13 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
46 | OIISOCAOI | SOC: Storage object characteristic: appl. specific oil & g | 9 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
47 | OIISOCB1 | SOC: Storage object characteristic segment: bulk | 22 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
48 | OIISOCB2 | SOC: Storage object characteristic segment: packaged | 9 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
49 | OIISOCK | SOC: Storage object characteristic segment header | 37 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
50 | OIISOCKL | SOC: Storage object characteristic class | 21 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
51 | OIISOCO1 | SOC: Storage object characteristic segment: bulk | 27 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
52 | OIISOCTSM | SOC: time dependent assignment SO <-> material (IS-Oil BDR | 27 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
53 | OIISOCTSP | SOC: Assignment SO <-> Plant/Storage location IS-Oil BDRP | 11 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
54 | OIISOCTYP | SOC: Storage object type | 11 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
55 | OIJ03_LOV | TSW: Table for Left on Vehicle Entries | 23 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
56 | OIJBER | Berth Table | 19 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
57 | OIJBERLOC | Index table for berths at TSW locations | 11 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
58 | OIJBERMAT | Assignment of material to berths | 12 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
59 | OIJBERSOC | Assignment of berths to tanks | 11 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
60 | OIJBRD | OIL-TSW: Rundown table for Batch | 30 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
61 | OIJBRDH | RD header f.batch:Don't use(obsolete) & don't delete(XPRA) | 34 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
62 | OIJBRDNOM | Stock Projection item / nomination X-ref table | 25 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
63 | OIJHCT01 | OIL-TSW: Ticket Holding Table (Draft version 1) - OBSOLETE | 75 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
64 | OIJLOC | Location table | 13 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
65 | OIJLOCMAT | OIL-TSW: Location Rundown/Planning material table | 91 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
66 | OIJNOMC | OIL-TSW: Nomination copy table | 52 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
67 | OIJNOMH | Nomination Header | 47 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
68 | OIJNOMI | Nomination Item | 52 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
69 | OIJNOMIVERS | Nomination Item Version Table | 54 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
70 | OIJPHYINV | Physical inventory | 17 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
71 | OIJPLANLOC | OIL TSW: Multiple planning Locations | 11 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
72 | OIJRD | OIL-TSW: Rundown table | 29 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
73 | OIJRDH | Rundown header: Don't use (obsolete) & don't delete (XPRA) | 33 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
74 | OIJRDHTPSET | OIL-TSW: Rundown Rack issue / throughput settings | 17 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
75 | OIJRDNOM | Stock Projection item / nomination X-ref table | 24 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
76 | OIJRRA | OIL-TSW: Partner roles | 21 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
77 | OIJSDLOC | OIL-TSW: Multiple sources/destinations of location | 19 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
78 | OIJTHPUTFC | Rack issue / Throughput forecast | 19 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
79 | OIJTHPUTFCAVG | OIL-TSW: Rack issue / Throughput forecast daily average | 19 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
80 | OIJTHPUTFCEST | OIL-TSW: Rack issue / Throughput estimate pop-up | 20 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
81 | OIJTSLOC | OIL-TSW: transport system/location assignment table | 16 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
82 | OIJTSMAT | OIL-TSW: TS Rundown/Planning material table | 83 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
83 | OIJTSMATSEQ | Disallowed Material sequence within Transport system | 12 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
84 | OIJWL | OIL-TSW: Worklist | 25 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
85 | OIJX | TSW control record | 10 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
86 | OIJ_EL_CP_LAYT | Charter party and laytime and demurrage agreement | 63 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
87 | OIJ_EL_CP_LOC | Charter party contract: load and discharge locations | 15 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
88 | OIJ_EL_CP_PROD | Charter contracts: products and product groups | 15 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
89 | OIJ_EL_DOC_EV | Rules for nomination events | 21 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
90 | OIJ_EL_DOC_H_REF | Oil TSW: Document header reference to nomination; not used | 12 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
91 | OIJ_EL_DOC_I_REF | Document item reference to nomination | 30 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
92 | OIJ_EL_DOC_MOT | Oil TSW: TSW Relevance of order item | 41 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
93 | OIJ_EL_DOC_M_MOT | OIL TSW: TSW Details / Multiple MoT's | 13 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
94 | OIJ_EL_LAYT_EV | Laytime start and end events | 25 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
95 | OIJ_EL_LAYT_INF | Laytime terms | 21 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
96 | OIJ_EL_PROD_DATA | Production data for locations | 15 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
97 | OIJ_EL_TCKET_UOM | Universal ticket additional units of measure | 19 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
98 | OIJ_EL_TICKET_H | Universal ticket table | 17 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
99 | OIJ_EL_TICKET_I | Universal ticket item table | 43 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
100 | OIJ_LMTIMECON | OILTSW: Time dependent constraints by location & material | 14 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
101 | OIJ_NOMLT | Laytime and demurrage for groups in nominations | 21 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
102 | OIJ_RDHEAD | Stock Projection header | 36 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
103 | OIJ_RELPROF | Oil-TSW: Release profiles for Schedules | 13 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
104 | OIJ_REPORT_QUAN | TSW: Reported Nomination quantities into/out of inventory | 14 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
105 | OIJ_SCHED | Planned Schedule Lines | 103 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
106 | OIJ_SIM_SCHED | obsolete table (will be cleaned up) | 29 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |
107 | OIJ_TGTSFTTIME | Time dependent target and safety levels | 13 | BLOIND | Blocking indicator | nvarchar | 1 | 0 | | |