| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBulk Distribution Requirements Planning |
| 1 | OIISCPLBL | Site control: lead time applicabilities - business locatio | 3 | RNBT | Business type | nvarchar | 4 | 0 | | |
| TOPMarketing Retail Network |
| 2 | OIFSCTCAPT | SSR BASE: screen configuration tool - caption settings | 4 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 3 | OIFSCTCAPTT | SSR BASE: screen configuration tool - caption texts | 5 | RNBT | Business type | nvarchar | 4 | 0 | | |
| TOPService Station Retailing |
| 4 | OIRADBT | Document base table | 8 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 5 | OIRAMATHANDGRP | Material handling group material assignment (IS-Oil SSR) | 3 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 6 | OIRAMATHANDGRPD | Material handling group definition (IS-Oil SSR) | 3 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 7 | OIRAMATHANDGRPDT | Material handling group definition text (IS-Oil SSR) | 4 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 8 | OIRAPROCRNBT | Link Business type to Process ID | 3 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 9 | OIRARNBTMATKL | Link Business type - Materialgroup (IS-OIL SSR) | 2 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 10 | OIRARNBTST | Link Business type - Service type (IS-OIL SSR) | 2 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 11 | OIRBAMCS | Subscreen assignments (IS-Oil SSR APPEND maint. concept) | 4 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 12 | OIRBCSTORE | C-Store/Retail specific data (IS-Oil SSR) | 3 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 13 | OIRBLAA | Location area assignment (IS-OIL SSR) | 2 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 14 | OIRBLAAT | Location area assignment description (IS-OIL SSR) | 3 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 15 | OIRBMATMET | Business Location material/meter assignment (IS-Oil, SSR) | 3 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 16 | OIRBOANLA | Object links - FI-AA asset master (IS-Oil SSR) | 3 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 17 | OIRBOCEPC | Object links - CO-PCA profit center (IS-Oil SSR) | 3 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 18 | OIRBOCOAS | Object links - CO order (IS-Oil SSR) | 3 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 19 | OIRBOCSKS | Object links - CO cost center (IS-Oil SSR) | 3 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 20 | OIRBOIFLO | Object links - PM functional location (IS-Oil SSR) | 3 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 21 | OIRBOPROJ | Object links - PS project or project item (IS-Oil SSR) | 3 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 22 | OIRBOT001L | Object links - CA storage location (IS-Oil SSR) | 3 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 23 | OIRBOT001W | Object links - CA Plant (IS-Oil SSR) | 3 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 24 | OIRBPBLB | Business location at business type level (IS-OIL SSR) | 3 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 25 | OIRBPBLPBL | Link Table Location-Loc(Competitor assgnmnt)(IS-OIL,SSR) | 3 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 26 | OIRBPBLSTAT | Location Status definition (IS-Oil SSR) | 3 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 27 | OIRBPBLTRNBT | Dummy table for run-time field RNBT per location type | 3 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 28 | OIRBTTXID | SSR Service Station Base: Text ID Activation | 3 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 29 | OIRBTTXIT | SSR Service Station Base: Text ID Titles | 4 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 30 | OIRCCOMPD | SSR Pricing - Competitor price differences | 3 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 31 | OIRCCOMPDM | SSR Pricing - Competitor price differences/Material | 3 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 32 | OIRCLPCD | SSR Pricing - Location price cluster differences | 3 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 33 | OIRCLPCDM | SSR Pricing - Location price cluster differences/Material | 3 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 34 | OIRC_DRREJ | SSR Stocks - Dip readings rejected records | 3 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 35 | OIRC_DRREJ_ERR | SSR Stocks - Dip readings rejected records - Error list | 3 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 36 | OIRC_GMMH | SSR Meters - History | 64 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 37 | OIRC_GMMH_AGG01 | SSR Meters - Aggregated history (Monthly) | 4 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 38 | OIRC_GMMH_AGG011 | SSR Meters - Aggregated history (Monthly) | 4 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 39 | OIRC_GMMH_DEL | SSR Meters - Deleted meter readings history | 65 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 40 | OIRC_MRREJ | SSR Meters - Meter readings rejected records | 3 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 41 | OIRC_MRREJ_ERR | SSR Meters - MR rejected records - Error list (OBSOLETE) | 3 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 42 | OIRC_MRREJ_ERRL | SSR Meters - Meter readings rejected records - Error list | 3 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 43 | OIRC_PRCHK | SSR Pricing - Price check | 3 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 44 | OIRC_PRLOG_PRM | SSR Pricing - Price update parameter log | 3 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 45 | OIRC_SOCDIP | SSR Stocks - Dip readings history | 133 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 46 | OIRHPRCONFC | BAPI Business type Process linking | 3 | RNBT | Business type | nvarchar | 4 | 0 | | |
| TOPTraders and Schedulers Workbench |
| 47 | OIISCPBL | SCP: Site control parameters (business loc) - IS-Oil BDRP | 3 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 48 | OIRAPBLTRNBT | Link Location type - Business type (IS-OIL SSR) | 3 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 49 | OIRARNBT | Retail Network Business Types | 2 | RNBT | Business type | nvarchar | 4 | 0 | | |
| 50 | OIRARNBTT | Retail Network Business Types | 3 | RNBT | Business type | nvarchar | 4 | 0 | | |
