| 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 | | |