| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | HRPADNLP_LOGIMME | NL Pens: Immediate Payments - log for Payroll Process | 19 | AEZEIT | Time of Change | nvarchar | 6 | 0 | | |
TOPBulk Distribution Requirements Planning |
2 | OIIGMMH | GMM: Meter history | 17 | AEZEIT | Time record changed | nvarchar | 6 | 0 | | |
3 | OIIGMMK | GMM: General meter header table | 30 | AEZEIT | Time record changed | nvarchar | 6 | 0 | | |
4 | OIIGMMM | GMM: Meter/Material assignment | 11 | AEZEIT | Time record changed | nvarchar | 6 | 0 | | |
5 | OIIOTWSK | BDRP-OTWS: Operations time window set header | 7 | AEZEIT | Time record changed | nvarchar | 6 | 0 | | |
6 | OIISCPWK | SCP: Site control parameters (plant) - IS-Oil BDRP | 41 | AEZEIT | Time record changed | nvarchar | 6 | 0 | | |
7 | OIISLVCH | Silo calibration history index | 11 | AEZEIT | Time record changed | nvarchar | 6 | 0 | | |
8 | OIISLVCKO | Silo: Calibration - LVC (strap) set header | 34 | AEZEIT | Time record changed | nvarchar | 6 | 0 | | |
9 | OIISOCTSS | SOC: time dependent assignment SO <-> SO (IS-Oil BDRP) | 11 | AEZEIT | Time record changed | nvarchar | 6 | 0 | | |
TOPCross-Application Components |
10 | AAUUFK | Order master data | 91 | AEZEIT | Changed at | nvarchar | 6 | 0 | | |
TOPEmpties Management |
11 | /BEV1/EMLGOFS | Empties - Billing Document Without Update | 12 | AEZEIT | Time of Change | nvarchar | 6 | 0 | | |
TOPFunctional Locations |
12 | IHPA | Plant Maintenance: Partners | 12 | AEZEIT | Time of Change | nvarchar | 6 | 0 | | |
TOPInterface to Terminal Automation System |
13 | OIK01 | IS-OIL/TAS: LID Document Data | 22 | AEZEIT | Time of Change | nvarchar | 6 | 0 | | |
14 | OIK01D | IS-OIL/TAS: deactivated LID Document Data | 23 | AEZEIT | Time of Change | nvarchar | 6 | 0 | | |
15 | OIKLIDR | TD - TAS Reference Table | 57 | AEZEIT | Time of Change | nvarchar | 6 | 0 | | |
TOPLogistics - General |
16 | OIFSPBL | Physical Location - Master Data | 17 | AEZEIT | Time when Record Was Changed | nvarchar | 6 | 0 | | |
17 | OIJTS | Transport system (IS-Oil TSW standard/core object ) | 34 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
18 | WBHK | Trading Contract: Header Data | 13 | AEZEIT | Time of Change | nvarchar | 6 | 0 | | |
TOPMaintenance Notifications |
19 | QMEL | Quality Notification | 52 | AEZEIT | Time of Change | nvarchar | 6 | 0 | | |
20 | QMFE | Quality notification - items | 22 | AEZEIT | Time of Change | nvarchar | 6 | 0 | | |
21 | QMMA | Quality notification - activities | 25 | AEZEIT | Time of Change | nvarchar | 6 | 0 | | |
22 | QMSM | Quality notification - tasks | 29 | AEZEIT | Time of Change | nvarchar | 6 | 0 | | |
23 | QMUR | Quality notification - causes | 17 | AEZEIT | Time of Change | nvarchar | 6 | 0 | | |
TOPMarketing Retail Network |
24 | OIFBBP1 | Business partner role assignments (IS-Oil MRN) | 11 | AEZEIT | Time when Record Was Changed | nvarchar | 6 | 0 | | |
25 | OIFCHRS2 | Retail Network Contract service hours type | 7 | AEZEIT | Time when Record Was Changed | nvarchar | 6 | 0 | | |
26 | OIFCOPT1 | Retail Network Contract option type | 7 | AEZEIT | Time when Record Was Changed | nvarchar | 6 | 0 | | |
27 | OIFDD1 | Delivery point info for bulk delivery preplannning | 36 | AEZEIT | Time when Record Was Changed | nvarchar | 6 | 0 | | |
28 | OIFDD2 | Bulk delivery preplanning version | 7 | AEZEIT | Time when Record Was Changed | nvarchar | 6 | 0 | | |
29 | OIFDDM1 | Del. point/material info for bulk delivery planning | 22 | AEZEIT | Time when Record Was Changed | nvarchar | 6 | 0 | | |
30 | OIFDDM2 | Del. point/material/tank (bulk delivery planning) | 11 | AEZEIT | Time when Record Was Changed | nvarchar | 6 | 0 | | |
31 | OIFDDM3 | Del. point/material/meter (bulk delivery planning) | 12 | AEZEIT | Time when Record Was Changed | nvarchar | 6 | 0 | | |
32 | OIFDTT1 | Tank type table - bulk delivery planning | 12 | AEZEIT | Time when Record Was Changed | nvarchar | 6 | 0 | | |
33 | OIFOANLA | Object links - FI-AA asset master (IS-Oil MRN) | 8 | AEZEIT | Time when Record Was Changed | nvarchar | 6 | 0 | | |
34 | OIFOCEPC | Object links - CO-PCA profit center (IS-Oil MRN) | 8 | AEZEIT | Time when Record Was Changed | nvarchar | 6 | 0 | | |
35 | OIFOCOAS | Object links - CO order (IS-Oil MRN) | 8 | AEZEIT | Time when Record Was Changed | nvarchar | 6 | 0 | | |
36 | OIFOCSKS | Object links - CO cost center (IS-Oil MRN) | 8 | AEZEIT | Time when Record Was Changed | nvarchar | 6 | 0 | | |
37 | OIFOIFLO | Object links - PM functional location (IS-Oil MRN) | 8 | AEZEIT | Time when Record Was Changed | nvarchar | 6 | 0 | | |
38 | OIFOPBLT | Location type - permissible object links (IS-Oil MRN) | 7 | AEZEIT | Time when Record Was Changed | nvarchar | 6 | 0 | | |
39 | OIFOPROJ | Object links - PS project or project item (IS-Oil MRN) | 8 | AEZEIT | Time when Record Was Changed | nvarchar | 6 | 0 | | |
40 | OIFORACTIV | Activation of Oil-Retail Integration Components | 13 | AEZEIT | Time when Record Was Changed | nvarchar | 6 | 0 | | |
41 | OIFORCAM | Conversion of article master to material master data (ALE) | 15 | AEZEIT | Time when Record Was Changed | nvarchar | 6 | 0 | | |
42 | OIFORCPR | Transfer customer expected price into sales condition record | 9 | AEZEIT | Time when Record Was Changed | nvarchar | 6 | 0 | | |
43 | OIFOT001L | Object links - CA storage location (IS-Oil MRN) | 8 | AEZEIT | Time when Record Was Changed | nvarchar | 6 | 0 | | |
44 | OIFOT001W | Object links - CA Plant (IS-Oil MRN) | 8 | AEZEIT | Time when Record Was Changed | nvarchar | 6 | 0 | | |
TOPOverhead Cost Orders |
45 | AUFK | Order master data | 91 | AEZEIT | Changed at | nvarchar | 6 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
46 | /BEV1/RSQUSE | Quick Settlement | 22 | AEZEIT | Time of Change | nvarchar | 6 | 0 | | |
TOPRevenues and Earnings |
47 | VPKHEAD | Sales Pricing Header Data | 17 | AEZEIT | System Time | nvarchar | 6 | 0 | | |
TOPSAP Ambulatory Care Management |
48 | N2HM_KPF | ACM: Kopfdaten zum Heilmittelkatalog | 11 | AEZEIT | Änderungsuhrzeit | nvarchar | 6 | 0 | | |
TOPService Station Retailing |
49 | OIRBOANLA | Object links - FI-AA asset master (IS-Oil SSR) | 9 | AEZEIT | Time when Record Was Changed | nvarchar | 6 | 0 | | |
50 | OIRBOCEPC | Object links - CO-PCA profit center (IS-Oil SSR) | 9 | AEZEIT | Time when Record Was Changed | nvarchar | 6 | 0 | | |
51 | OIRBOCOAS | Object links - CO order (IS-Oil SSR) | 9 | AEZEIT | Time when Record Was Changed | nvarchar | 6 | 0 | | |
52 | OIRBOCSKS | Object links - CO cost center (IS-Oil SSR) | 9 | AEZEIT | Time when Record Was Changed | nvarchar | 6 | 0 | | |
53 | OIRBOIFLO | Object links - PM functional location (IS-Oil SSR) | 9 | AEZEIT | Time when Record Was Changed | nvarchar | 6 | 0 | | |
54 | OIRBOMMT001L | Object links - CA storage location (IS-Oil MRN) | 8 | AEZEIT | Time when Record Was Changed | nvarchar | 6 | 0 | | |
55 | OIRBOPROJ | Object links - PS project or project item (IS-Oil SSR) | 9 | AEZEIT | Time when Record Was Changed | nvarchar | 6 | 0 | | |
56 | OIRBOT001L | Object links - CA storage location (IS-Oil SSR) | 9 | AEZEIT | Time when Record Was Changed | nvarchar | 6 | 0 | | |
57 | OIRBOT001W | Object links - CA Plant (IS-Oil SSR) | 9 | AEZEIT | Time when Record Was Changed | nvarchar | 6 | 0 | | |
58 | OIRBPBLB | Business location at business type level (IS-OIL SSR) | 27 | AEZEIT | Time when Record Was Changed | nvarchar | 6 | 0 | | |
59 | OIRC_DRREJ | SSR Stocks - Dip readings rejected records | 75 | AEZEIT | Time record changed | nvarchar | 6 | 0 | | |
60 | OIRC_GMMH | SSR Meters - History | 59 | AEZEIT | Time record changed | nvarchar | 6 | 0 | | |
61 | OIRC_GMMH_DEL | SSR Meters - Deleted meter readings history | 60 | AEZEIT | Time record changed | nvarchar | 6 | 0 | | |
62 | OIRC_MRREJ | SSR Meters - Meter readings rejected records | 62 | AEZEIT | Time record changed | nvarchar | 6 | 0 | | |
63 | OIRC_PRCHK | SSR Pricing - Price check | 26 | AEZEIT | Time record changed | nvarchar | 6 | 0 | | |
64 | OIRC_SOCDIP | SSR Stocks - Dip readings history | 72 | AEZEIT | Time record changed | nvarchar | 6 | 0 | | |
TOPSimulation |
65 | VSAUFK_CN | Version: Order master data | 92 | AEZEIT | Changed at | nvarchar | 6 | 0 | | |
TOPTraders and Schedulers Workbench |
66 | OIB_TANKDIP | Silo management tank strapping history | 23 | AEZEIT | Time record changed | nvarchar | 6 | 0 | | |
67 | OIFSBLCD | Blocking Indicator for Business Locations | 10 | AEZEIT | Time when Record Was Changed | nvarchar | 6 | 0 | | |
68 | OIFSPBLT | Physical Business Location Type | 13 | AEZEIT | Time when Record Was Changed | nvarchar | 6 | 0 | | |
69 | OIISCPBL | SCP: Site control parameters (business loc) - IS-Oil BDRP | 43 | AEZEIT | Time record changed | nvarchar | 6 | 0 | | |
70 | OIISCPKN | SCP: Site control parameters (customer) - IS-Oil BDRP | 41 | AEZEIT | Time record changed | nvarchar | 6 | 0 | | |
71 | OIISLVCK | SOC: Linear/volumetric conversion (strap) set header | 11 | AEZEIT | Time record changed | nvarchar | 6 | 0 | | |
72 | OIISOCAOI | SOC: Storage object characteristic: appl. specific oil & g | 7 | AEZEIT | Time record changed | nvarchar | 6 | 0 | | |
73 | OIISOCB1 | SOC: Storage object characteristic segment: bulk | 20 | AEZEIT | Time record changed | nvarchar | 6 | 0 | | |
74 | OIISOCB2 | SOC: Storage object characteristic segment: packaged | 7 | AEZEIT | Time record changed | nvarchar | 6 | 0 | | |
75 | OIISOCK | SOC: Storage object characteristic segment header | 35 | AEZEIT | Time record changed | nvarchar | 6 | 0 | | |
76 | OIISOCKL | SOC: Storage object characteristic class | 19 | AEZEIT | Time record changed | nvarchar | 6 | 0 | | |
77 | OIISOCO1 | SOC: Storage object characteristic segment: bulk | 25 | AEZEIT | Time record changed | nvarchar | 6 | 0 | | |
78 | OIISOCTSM | SOC: time dependent assignment SO <-> material (IS-Oil BDR | 25 | AEZEIT | Time record changed | nvarchar | 6 | 0 | | |
79 | OIISOCTSP | SOC: Assignment SO <-> Plant/Storage location IS-Oil BDRP | 9 | AEZEIT | Time record changed | nvarchar | 6 | 0 | | |
80 | OIISOCTYP | SOC: Storage object type | 9 | AEZEIT | Time record changed | nvarchar | 6 | 0 | | |
81 | OIJ03_LOV | TSW: Table for Left on Vehicle Entries | 21 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
82 | OIJBER | Berth Table | 17 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
83 | OIJBERLOC | Index table for berths at TSW locations | 9 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
84 | OIJBERMAT | Assignment of material to berths | 10 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
85 | OIJBERSOC | Assignment of berths to tanks | 9 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
86 | OIJBRD | OIL-TSW: Rundown table for Batch | 28 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
87 | OIJBRDH | RD header f.batch:Don't use(obsolete) & don't delete(XPRA) | 32 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
88 | OIJBRDNOM | Stock Projection item / nomination X-ref table | 23 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
89 | OIJCLIPBOARD | Clipboard Table for Railcar | 35 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
90 | OIJHCT01 | OIL-TSW: Ticket Holding Table (Draft version 1) - OBSOLETE | 73 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
91 | OIJLOC | Location table | 11 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
92 | OIJLOCMAT | OIL-TSW: Location Rundown/Planning material table | 89 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
93 | OIJNOMC | OIL-TSW: Nomination copy table | 105 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
94 | OIJNOMH | Nomination Header | 54 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
95 | OIJNOMHATLOAD | Nomination Hatch load sequence plan | 20 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
96 | OIJNOMHATPLAN | Nomination: hatch plan | 11 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
97 | OIJNOMI | Nomination Item | 105 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
98 | OIJNOMSUBITEMS | Nomination Sub-Item | 55 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
99 | OIJPHYINV | Physical inventory | 15 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
100 | OIJPLANLOC | OIL TSW: Multiple planning Locations | 9 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
101 | OIJRD | OIL-TSW: Rundown table | 27 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
102 | OIJRDH | Rundown header: Don't use (obsolete) & don't delete (XPRA) | 31 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
103 | OIJRDHTPSET | OIL-TSW: Rundown Rack issue / throughput settings | 15 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
104 | OIJRDNOM | Stock Projection item / nomination X-ref table | 22 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
105 | OIJRRA | OIL-TSW: Partner roles | 19 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
106 | OIJSDLOC | OIL-TSW: Multiple sources/destinations of location | 17 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
107 | OIJTHPUTFC | Rack issue / Throughput forecast | 17 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
108 | OIJTHPUTFCAVG | OIL-TSW: Rack issue / Throughput forecast daily average | 17 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
109 | OIJTHPUTFCEST | OIL-TSW: Rack issue / Throughput estimate pop-up | 18 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
110 | OIJTSLOC | OIL-TSW: transport system/location assignment table | 14 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
111 | OIJTSMAT | OIL-TSW: TS Rundown/Planning material table | 81 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
112 | OIJTSMATSEQ | Disallowed Material sequence within Transport system | 10 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
113 | OIJWL | OIL-TSW: Worklist | 23 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
114 | OIJX | TSW control record | 8 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
115 | OIJ_EL_CP_LAYT | Charter party and laytime and demurrage agreement | 61 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
116 | OIJ_EL_CP_LOC | Charter party contract: load and discharge locations | 13 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
117 | OIJ_EL_CP_PROD | Charter contracts: products and product groups | 13 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
118 | OIJ_EL_DOC_EV | Rules for nomination events | 19 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
119 | OIJ_EL_DOC_H_REF | Oil TSW: Document header reference to nomination; not used | 10 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
120 | OIJ_EL_DOC_I_REF | Document item reference to nomination | 28 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
121 | OIJ_EL_DOC_MOT | Oil TSW: TSW Relevance of order item | 39 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
122 | OIJ_EL_DOC_M_MOT | OIL TSW: TSW Details / Multiple MoT's | 11 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
123 | OIJ_EL_LAYT_EV | Laytime start and end events | 23 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
124 | OIJ_EL_LAYT_INF | Laytime terms | 19 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
125 | OIJ_EL_PROD_DATA | Production data for locations | 13 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
126 | OIJ_EL_TCKET_UOM | Universal ticket additional units of measure | 17 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
127 | OIJ_EL_TICKET_H | Universal ticket table | 15 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
128 | OIJ_EL_TICKET_I | Universal ticket item table | 41 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
129 | OIJ_LMTIMECON | OILTSW: Time dependent constraints by location & material | 12 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
130 | OIJ_NOMLT | Laytime and demurrage for groups in nominations | 19 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
131 | OIJ_RDHEAD | Stock Projection header | 34 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
132 | OIJ_RELPROF | Oil-TSW: Release profiles for Schedules | 11 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
133 | OIJ_REPORT_QUAN | TSW: Reported Nomination quantities into/out of inventory | 12 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
134 | OIJ_SCHED | Planned Schedule Lines | 152 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
135 | OIJ_SIM_SCHED | obsolete table (will be cleaned up) | 27 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
136 | OIJ_TGTSFTTIME | Time dependent target and safety levels | 11 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |
137 | OIJ_VEH_PERF | Marine Scheduling - Table to Store vehicle Performanace | 27 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | | |