| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBulk Distribution Requirements Planning |
1 | OIIGMMK | GMM: General meter header table | 23 | SERVTYP | Service type | nvarchar | 4 | 0 | | |
TOPService Station Retailing |
2 | OIRBMATMET | Business Location material/meter assignment (IS-Oil, SSR) | 6 | SERVTYP | Service type | nvarchar | 4 | 0 | | |
3 | OIRC_GMMH | SSR Meters - History | 24 | SERVTYP | Service type | nvarchar | 4 | 0 | | |
4 | OIRC_GMMH_AGG01 | SSR Meters - Aggregated history (Monthly) | 8 | SERVTYP | Service type | nvarchar | 4 | 0 | | |
5 | OIRC_GMMH_AGG011 | SSR Meters - Aggregated history (Monthly) | 7 | SERVTYP | Service type | nvarchar | 4 | 0 | | |
6 | OIRC_GMMH_DEL | SSR Meters - Deleted meter readings history | 25 | SERVTYP | Service type | nvarchar | 4 | 0 | | |
7 | OIRC_MRREJ | SSR Meters - Meter readings rejected records | 27 | SERVTYP | Service type | nvarchar | 4 | 0 | | |
8 | OIRC_PRCHK | SSR Pricing - Price check | 5 | SERVTYP | Service type | nvarchar | 4 | 0 | | |