Search TipsPrepaid Usage
Data is only considered up to midnight of the previous day. This is to ensure a common cut-off date across all Data Warehouse output.
|
Column Heading |
Unique? |
Type |
Length |
Details |
|---|---|---|---|---|
| Prepaid Usage Identifier | Y | Numeric | The ID number of the prepaid usage | |
|
Usage Date Time |
|
Numeric |
25,0 |
The date and time of the prepaid usage. YYYY-MM-DD HH:MM:SS format |
|
Usage Processed Date Time |
|
Numeric |
25,0 |
The date and time that the prepaid usage was processed. YYYY-MM-DD HH:MM:SS format |
|
Usage External Identifier |
|
Alphanumeric |
|
The reference used by an external third party to identify the prepaid usage, for example, MEF:1594969511695:87 |
|
Network Code |
|
Alphanumeric | 6,0 |
The CMP code for the network associated with the usage, e.g. OCS |
|
Usage Class |
|
Alphanumeric |
12,0 |
CMP code for the usage class, for example, DOMDATA |
|
Usage Class Description |
|
Alphanumeric |
30,0 |
Text description of the Usage Class code, for example, Domestic Data |
|
Company Number |
|
Alphanumeric | 3 |
The numerical ID of the company |
|
Service Code |
|
Alphanumeric |
6,0 |
CMP Code for the pricing service associated with the usage, for example, EUDATA |
|
Service Code Description |
|
Alphanumeric |
30,0 |
Text description of the pricing service associated with the usage, for example, Euro Roaming Data |
|
Service Group Code |
|
Alphanumeric |
6 |
The CMP Code for the group to which the service belongs, for example, USAGE |
|
Service Group Code Description |
|
Alphanumeric |
30 |
Text description of the service group to which the service belongs, for example, Usage |
| Network Serial Number | Alphanumeric | 25 | As stored in CMP. Typically a mobile number or landline CLI as stored in Managed Serial Number 1.0 | |
| Subscription Number | Numeric | 8 |
CMP Subscription number |
|
| Destination | ||||
|
Usage Type |
|
Alphanumeric |
CMP code for the usage type |
|
|
Usage Type Description |
|
Alphanumeric |
Text description of the usage type |
|
| Wholesale Charge | Numeric | 11, 4 | Wholesale price of the usage | |
| Retail Charge | Numeric | 11, 4 | Retail price | |
| Access Charge | Numeric | 11, 4 | Monetary value of access charge | |
| Service Charge | Numeric | 11, 4 | Monetary value of service charge | |
| Actual Usage Units | Numeric | 7,0 | Actual units of usage consumed | |
| Billable Usage Units | Numeric | 7,0 | Billable units of usage | |
| Generic String 1 - Generic String 10 (10 columns) | Alphanumeric | Generic String values | ||
| Generic Integer 1 - Generic Integer 4 (4 columns) | Integer | Generic Integer values | ||
|
Audit Timestamp |
|
Numeric |
25,0 |
YYYY-MM-DD HH:MM:SS format |
|
Audit User |
|
Alphanumric |
50 |
ID of user who changed the record |
|
Data Extract Date |
|
Numeric |
7,0 |
Date that the data above was extracted from CMP. YYYY-MM-DD format |