| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBulk Distribution Requirements Planning |
1 | OIIGMMM | GMM: Meter/Material assignment | 4 | TTMSTM | To/end timestamp (BDRP) | nvarchar | 14 | 0 | | |
2 | OIISOCTSS | SOC: time dependent assignment SO <-> SO (IS-Oil BDRP) | 4 | TTMSTM | To/end timestamp (BDRP) | nvarchar | 14 | 0 | | |
TOPMarketing Retail Network |
3 | OIFBBP1 | Business partner role assignments (IS-Oil MRN) | 6 | TTMSTM | End of partner function validity period - timestamp | nvarchar | 14 | 0 | | |
TOPService Station Retailing |
4 | OIRBPBLSTAT | Location Status definition (IS-Oil SSR) | 5 | TTMSTM | End of partner function validity period - timestamp | nvarchar | 14 | 0 | | |
5 | OIRC_GMMH | SSR Meters - History | 17 | TTMSTM | End of partner function validity period - timestamp | nvarchar | 14 | 0 | | |
6 | OIRC_GMMH_DEL | SSR Meters - Deleted meter readings history | 18 | TTMSTM | End of partner function validity period - timestamp | nvarchar | 14 | 0 | | |
7 | OIRC_MRREJ | SSR Meters - Meter readings rejected records | 20 | TTMSTM | End of partner function validity period - timestamp | nvarchar | 14 | 0 | | |
TOPTraders and Schedulers Workbench |
8 | OIISOCTSM | SOC: time dependent assignment SO <-> material (IS-Oil BDR | 5 | TTMSTM | To/end timestamp (BDRP) | nvarchar | 14 | 0 | | |
9 | OIJ_LMTIMECON | OILTSW: Time dependent constraints by location & material | 6 | TTMSTM | To/end timestamp (BDRP) | nvarchar | 14 | 0 | | |