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