| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPLogistics - General |
| 1 | OIFSPBL | Physical Location - Master Data | 11 | PBLTYP | Business Location Type (IS-Oil MRN) | nvarchar | 4 | 0 | | |
| TOPMarketing Retail Network |
| 2 | OIFBPBLT | Location type - permissible partner roles (IS-Oil MRN) | 2 | PBLTYP | Business Location Type (IS-Oil MRN) | nvarchar | 4 | 0 | | |
| 3 | OIFOPBLT | Location type - permissible object links (IS-Oil MRN) | 2 | PBLTYP | Business Location Type (IS-Oil MRN) | nvarchar | 4 | 0 | | |
| 4 | OIFSCTDSDEFC | Data Section Customizing - Screen Configuration Tool | 3 | PBLTYP | Business Location Type (IS-Oil MRN) | nvarchar | 4 | 0 | | |
| 5 | OIFSCTFDCONFC | Field Selection Customizing - Screen Configuration Tool | 3 | PBLTYP | Business Location Type (IS-Oil MRN) | nvarchar | 4 | 0 | | |
| 6 | OIFSCTSNCONFC | Screen Configuration Customizing - Screen Configuration Tool | 5 | PBLTYP | Business Location Type (IS-Oil MRN) | nvarchar | 4 | 0 | | |
| 7 | OIFSCTSNDEFC | Screen Definition Customizing - Screen Configuration Tool | 2 | PBLTYP | Business Location Type (IS-Oil MRN) | nvarchar | 4 | 0 | | |
| TOPService Station Retailing |
| 8 | OIRBPBLTRNBT | Dummy table for run-time field RNBT per location type | 2 | PBLTYP | Business Location Type (IS-Oil MRN) | nvarchar | 4 | 0 | | |
| 9 | OIRCPRUPD | SSR Pricing - Update type definition | 4 | PBLTYP | Business Location Type (IS-Oil MRN) | nvarchar | 4 | 0 | | |
| 10 | OIRC_DR_COMPST | SSR Stocks - Completion strategy for the DBT | 3 | PBLTYP | Business Location Type (IS-Oil MRN) | nvarchar | 4 | 0 | | |
| 11 | OIRC_MR_COMPST | SSR Meters - Completion strategy for the DBT | 3 | PBLTYP | Business Location Type (IS-Oil MRN) | nvarchar | 4 | 0 | | |
| 12 | OIRC_MR_FDEF_CF | SSR Meters - Field Selection Customizing - SCT | 3 | PBLTYP | Business Location Type (IS-Oil MRN) | nvarchar | 4 | 0 | | |
| 13 | OIRC_MR_FDEF_KEY | SSR Meters - Field Selection Customizing - Key definition | 3 | PBLTYP | Business Location Type (IS-Oil MRN) | nvarchar | 4 | 0 | | |
| 14 | OIRC_VCDEF_COLDF | SSR Pricing - Column definition | 5 | PBLTYP | Business Location Type (IS-Oil MRN) | nvarchar | 4 | 0 | | |
| TOPTraders and Schedulers Workbench |
| 15 | OIFSPBLT | Physical Business Location Type | 2 | PBLTYP | Business Location Type (IS-Oil MRN) | nvarchar | 4 | 0 | | |
| 16 | OIFSPBLTAPPL | Physical business location type / application assignments | 2 | PBLTYP | Business Location Type (IS-Oil MRN) | nvarchar | 4 | 0 | | |
| 17 | OIFSPBLTS | Physical business location type description | 3 | PBLTYP | Business Location Type (IS-Oil MRN) | nvarchar | 4 | 0 | | |
| 18 | OIRAPBLTRNBT | Link Location type - Business type (IS-OIL SSR) | 2 | PBLTYP | Business Location Type (IS-Oil MRN) | nvarchar | 4 | 0 | | |
