Search TipsBilled Usage Analytics
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 |
|---|---|---|---|---|
| Rated Usage Identifier | Y | Numeric | ID for the rated usage | |
| Usage Date Time | Numeric | 25,0 | The date and time the usage took place. YYYY-MM-DD HH:MM:SS format | |
| Usage Processed Date Time | Numeric | 25,0 | The date and time the usage records were processed. YYYY-MM-DD HH:MM:SS format | |
|
Usage External Identifier |
|
Numeric |
|
ID used by external third party for usage |
|
Network Code |
|
Alphanumeric |
6,0 |
CMP code for the network |
|
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 |
|
Numeric |
3 |
CMP ID number for the company |
|
Service Code |
|
Alphanumeric |
6,0 |
CMP Code for the pricing service associated with the usage, for example, EUDATA |
|
Service Description |
|
Alphanumeric |
30,0 |
Text description of the pricing service associated with the usage, for example, Euro Roaming Data |
|
Service Group |
|
Alphanumeric |
6,0 |
The CMP Code for the group to which the service belongs, for example, USAGE |
|
Service Group Description |
|
Alphanumeric |
30,0 |
Text description of the service group to which the service belongs, for example, Usage |
|
Network Serial Number |
|
Numeric |
10,0 |
Serial number of the network associated with the usage |
|
Subscription |
|
Numeric |
7,0 |
CMP subscription number |
|
Destination |
|
Alphanumeric |
The dialled number, or for data, a text description | |
|
Usage Type |
|
Numeric |
CMP code for the usage type |
|
|
Usage Type Description |
|
Alphanumeric |
Text description of the usage type |
|
|
Invoice Number |
|
Numeric |
|
The number of the invoice that bills for this usage |
|
Wholesale charge |
|
Numeric |
11,4 |
The wholesale charge of the usage, to 4 decimal places |
|
Retail Charge |
|
Numeric |
11,4 |
The retail price of the usage, to 4 decimal places |
|
Access Charge |
|
Numeric |
11,4 |
If there is an access charge for the usage, the amount to 4 decimal places |
|
Service Charge |
Numeric |
11,4 |
If there is a charge for the service, the amount to 4 decimal places |
|
|
Actual usage units |
Numeric |
|
The actual amount of usage consumed, in units |
|
|
Billable Usage Units |
|
Numeric |
|
The amount of usage consumed, in units, that was invoiced for |
|
Pre-paid Units |
|
Numeric |
|
The amount of prepaid usage that was consumed, in units |
|
Pre-paid Duration |
|
Numeric |
|
The duration of the pre-paid usage |
|
Pre-paid Retail Price |
|
Numeric |
11,4 |
The retail price of the pre-paid usage, to 4 decimal places |
| Generic String1 | Alphanumeric | Generic string content | ||
| Generic String2 | Alphanumeric | Generic string content | ||
| Generic String3 | Alphanumeric | Generic string content | ||
| Generic String4 | Alphanumeric | Generic string content | ||
| Generic String5 | Alphanumeric | Generic string content | ||
| Generic String6 | Alphanumeric | Generic string content | ||
| Generic String7 | Alphanumeric | Generic string content | ||
| Generic String8 | Alphanumeric | Generic string content | ||
| Generic String9 | Alphanumeric | Generic string content | ||
| Generic String10 | Alphanumeric | Generic string content | ||
| Generic Integer1 | Numeric | Generic integer content | ||
| Generic Integer2 | Numeric | Generic integer content | ||
| Generic Integer3 | Numeric | Generic integer content | ||
| Generic Integer4 | Numeric | Generic integer content | ||
| Audit Timestamp | Numeric | 25,0 | The date and time of audit. YYYY-MM-DD HH:MM:SS format | |
| Audit User | Alphanumeric | User name of user who last changed data | ||
| Usage Direction | Alphanumeric | 2,0 | The code for the usage direction, either MO or MT | |
| Mobile Country Code | Numeric | 3,0 | 3-digit mobile telephone code for the country associated with the usage, for example 234 for United Kingdom | |
| Country Name | Alphanumeric | 30,0 | The name of the country associated with the mobile code, e.g. Ireland for code 272 | |
| Mobile Network Operator | Numeric | 3,0 | The mobile telephone number code for the network operator associated with the usage e.g. 15 for Vodaphone | |
| Mobile Network Operator Name | Alphanumeric | 30,0 | The name of the network operator associated with the mobile network operator code | |
| Discount Value |
Numeric |
11,4 |
The value of any discount applied to the billed usage | |
| Data Extract Date | Numeric | 7,0 | Date and time this extract was created. YYYY-MM-DD format |