| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBulk Distribution Requirements Planning |
1 | OIIOTWSIBL | BDRP-OTWS: Operations time window set index - business loc. | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
2 | OIISCPLBL | Site control: lead time applicabilities - business locatio | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
TOPDownstream |
3 | S414BIW1 | S414BIW1 * SSR DTF statistics | 9 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
4 | S414BIW2 | S414BIW2 * SSR DTF statistics | 9 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
TOPLogistics - General |
5 | OIFSPBL | Physical Location - Master Data | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
TOPMarketing Retail Network |
6 | OIFBBP1 | Business partner role assignments (IS-Oil MRN) | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
7 | OIFOANLA | Object links - FI-AA asset master (IS-Oil MRN) | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
8 | OIFOCEPC | Object links - CO-PCA profit center (IS-Oil MRN) | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
9 | OIFOCOAS | Object links - CO order (IS-Oil MRN) | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
10 | OIFOCSKS | Object links - CO cost center (IS-Oil MRN) | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
11 | OIFOIFLO | Object links - PM functional location (IS-Oil MRN) | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
12 | OIFOPROJ | Object links - PS project or project item (IS-Oil MRN) | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
13 | OIFOT001L | Object links - CA storage location (IS-Oil MRN) | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
14 | OIFOT001W | Object links - CA Plant (IS-Oil MRN) | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
15 | OIFPBL | Index to point at Business Location | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
16 | OIFSMCADDR | Link Table Between OIFSPBL and ADRC for Matchcode | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
TOPService Station Retailing |
17 | B414 | LocationID/PrnGp | 4 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
18 | OIRADBT | Document base table | 5 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
19 | OIRA_PRNDOC_HEAD | Print document header data | 7 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
20 | OIRBBP1PF | Location partner role SD partner functions (IS-Oil SSR) | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
21 | OIRBCSTORE | C-Store/Retail specific data (IS-Oil SSR) | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
22 | OIRBMATMET | Business Location material/meter assignment (IS-Oil, SSR) | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
23 | OIRBOANLA | Object links - FI-AA asset master (IS-Oil SSR) | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
24 | OIRBOCEPC | Object links - CO-PCA profit center (IS-Oil SSR) | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
25 | OIRBOCOAS | Object links - CO order (IS-Oil SSR) | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
26 | OIRBOCSKS | Object links - CO cost center (IS-Oil SSR) | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
27 | OIRBOIFLO | Object links - PM functional location (IS-Oil SSR) | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
28 | OIRBOMMT001L | Object links - CA storage location (IS-Oil MRN) | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
29 | OIRBOPROJ | Object links - PS project or project item (IS-Oil SSR) | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
30 | OIRBOT001L | Object links - CA storage location (IS-Oil SSR) | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
31 | OIRBOT001W | Object links - CA Plant (IS-Oil SSR) | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
32 | OIRBPBLB | Business location at business type level (IS-OIL SSR) | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
33 | OIRBPBLPBL | Link Table Location-Loc(Competitor assgnmnt)(IS-OIL,SSR) | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
34 | OIRBPBLSTAT | Location Status definition (IS-Oil SSR) | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
35 | OIRCCOMPD | SSR Pricing - Competitor price differences | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
36 | OIRCCOMPDM | SSR Pricing - Competitor price differences/Material | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
37 | OIRCLPCD | SSR Pricing - Location price cluster differences | 4 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
38 | OIRCLPCDM | SSR Pricing - Location price cluster differences/Material | 4 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
39 | OIRC_DRREJ | SSR Stocks - Dip readings rejected records | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
40 | OIRC_DRREJ_ERR | SSR Stocks - Dip readings rejected records - Error list | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
41 | OIRC_GMMH | SSR Meters - History | 63 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
42 | OIRC_GMMH_AGG01 | SSR Meters - Aggregated history (Monthly) | 3 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
43 | OIRC_GMMH_AGG011 | SSR Meters - Aggregated history (Monthly) | 3 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
44 | OIRC_GMMH_DEL | SSR Meters - Deleted meter readings history | 64 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
45 | OIRC_MRREJ | SSR Meters - Meter readings rejected records | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
46 | OIRC_MRREJ_ERR | SSR Meters - MR rejected records - Error list (OBSOLETE) | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
47 | OIRC_MRREJ_ERRL | SSR Meters - Meter readings rejected records - Error list | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
48 | OIRC_PRCHK | SSR Pricing - Price check | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
49 | OIRC_PRLOG_OBJ | SSR Pricing - Price update location list | 3 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
50 | OIRC_PRLOG_PRL | SSR Pricing - Old and new prices | 3 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
51 | OIRC_SOCDIP | SSR Stocks - Dip readings history | 132 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
52 | OIREPBL | SSR PC: Types per business location | 3 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
53 | OIRESPCR | SSR PC: Splitting criteria | 8 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
54 | OIREUPLKXXXX | SSR PC: Template for generated DTF tables (header) | 6 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
55 | OIRE_RECON_AGG | Aggregated reconciliation data | 4 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
56 | OIRE_RECON_DET | Detailed reconciliation data | 4 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
57 | S414 | SSR DTF statistics | 9 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
58 | S414E | S414 - Structural information | 4 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
TOPTraders and Schedulers Workbench |
59 | OIISCPBL | SCP: Site control parameters (business loc) - IS-Oil BDRP | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
60 | OIISOCIBL | SOC: Index for business location/sequence no. access mode | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
61 | OIJBERLOC | Index table for berths at TSW locations | 2 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |
62 | OIJLOC | Location table | 31 | PBLNR | Business location identifier (IS-Oil MRN) | nvarchar | 10 | 0 | | |