| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBulk Distribution Requirements Planning |
| 1 | OIIGMMT | GMM: General meter type | 3 | NUMRI | Internal number range ID | nvarchar | 2 | 0 | | |
| TOPService Station Retailing |
| 2 | OIRA_PRINTGP | Print type group definition | 6 | NUMRI | Number range | nvarchar | 2 | 0 | | |
| 3 | OIRECCTYP | SSR PC: Company code / credit card types | 12 | NUMRI | ID for Internal Number Range | nvarchar | 2 | 0 | | |
| 4 | OIRECH | SSR PC: Clearing House table (IS-Oil SSR) | 21 | NUMRI | SSR PC: Settlement document run number (internal) | nvarchar | 2 | 0 | | |
| TOPTraders and Schedulers Workbench |
| 5 | OIFSPBLT | Physical Business Location Type | 3 | NUMRI | ID for Internal Number Range | nvarchar | 2 | 0 | | |
| 6 | TOIJNOMTYP | Nomination Type | 5 | NUMRI | Internal number range | nvarchar | 2 | 0 | | |
| 7 | TOIJ_PEGTYPE | TSW: Pegging type definition | 10 | NUMRI | Internal number range | nvarchar | 2 | 0 | | |
