| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBulk Distribution Requirements Planning |
1 | OIIGMMH | GMM: Meter history | 2 | GMMNR | GMM: Number of general meter | nvarchar | 20 | 0 | | |
2 | OIIGMMIKN | GMM: Index for customer/sequence no. access mode | 4 | GMMNR | GMM: Number of general meter | nvarchar | 20 | 0 | | |
3 | OIIGMMK | GMM: General meter header table | 2 | GMMNR | GMM: Number of general meter | nvarchar | 20 | 0 | | |
4 | OIIGMMKS | GMM: Meter description | 3 | GMMNR | GMM: Number of general meter | nvarchar | 20 | 0 | | |
5 | OIIGMMM | GMM: Meter/Material assignment | 2 | GMMNR | GMM: Number of general meter | nvarchar | 20 | 0 | | |
6 | OIIGMMS | GMM: Meter/Storage object assignment | 2 | GMMNR | GMM: Number of general meter | nvarchar | 20 | 0 | | |
TOPService Station Retailing |
7 | OIRADBT | Document base table | 35 | GMMNR | GMM: Number of general meter | nvarchar | 20 | 0 | | |
8 | OIRBMATMET | Business Location material/meter assignment (IS-Oil, SSR) | 13 | GMMNR | GMM: Number of general meter | nvarchar | 20 | 0 | | |
9 | OIRC_GMMH | SSR Meters - History | 2 | GMMNR | GMM: Number of general meter | nvarchar | 20 | 0 | | |
10 | OIRC_GMMH_DEL | SSR Meters - Deleted meter readings history | 2 | GMMNR | GMM: Number of general meter | nvarchar | 20 | 0 | | |
11 | OIRC_GMMH_PRNR | SSR Meters - History / Maximum process number | 2 | GMMNR | GMM: Number of general meter | nvarchar | 20 | 0 | | |
12 | OIRC_MRREJ | SSR Meters - Meter readings rejected records | 5 | GMMNR | GMM: Number of general meter | nvarchar | 20 | 0 | | |
TOPTraders and Schedulers Workbench |
13 | OIJ_EL_TICKET_I | Universal ticket item table | 49 | GMMNR | GMM: Number of general meter | nvarchar | 20 | 0 | | |