Search TipsUnallocated Usage
|
Field No. |
Field Name |
Unique? |
Type |
Length |
Details |
|---|---|---|---|---|---|
|
1 |
Subscription |
|
Numeric |
8,0 |
CMP Subscription Number |
|
2 |
Call Date |
|
Numeric |
7,0 |
Date as recorded in CMP. YYYY-MM-DD format. |
|
3 |
Call Time |
|
Numeric |
6,0 |
Time as recorded in CMP. HHMMSS format. |
|
4 |
Network |
|
Alphanumeric |
6 |
Network |
| 5 |
Network Description |
|
Alphanumeric |
30 |
CMP Network Description |
|
6 |
Call Class |
|
Alphanumeric |
12 |
As stored in CMP |
| 7 |
Call Class Description |
|
Alphanumeric |
30 |
CMP Call Class Description |
|
8 |
Service |
|
Alphanumeric |
6 |
As stored in CMP |
| 9 | Service Description |
Alphanumeric |
30 |
CMP Service Description |
|
|
10 |
Network Serial Number |
|
Alphanumeric |
25 |
Telephone number as stored in CMP |
|
11 |
Dialled Number |
|
Alphanumeric |
18 |
Dialled Number |
|
12 |
Call Duration |
|
Numeric |
7,0 |
In seconds |
|
13 |
Number of Units |
|
Numeric |
9,0 |
Used for SMS/MMS/Data |
|
14 |
Unit of Measure for Data |
|
Alphanumeric |
8 |
CMP Unit of Measure Code, KB, GB etc. |
|
15 |
SP Billed Call Price |
|
Numeric |
11,4 |
Amount in pounds and pence, to 2 decimal places (retail price of call £0.00 if bundled) |
|
16 |
Bundle Allocation Number |
|
Numeric |
9,0 |
Bundle Allocation Number specific to Bundle Period |
|
17 |
Pre-bundle SP Value |
|
Numeric |
11,4 |
Amount in pounds and pence, to 2 decimal places (retail price of bundled call) |
|
18 |
Discount Value |
|
Numeric |
11,4 |
Amount in pounds and pence, to 2 decimal places |
|
19 |
Wholesale Call Value |
|
Numeric |
11,4 |
Amount in pounds and pence, to 2 decimal places |
|
20 |
Original Request |
Y |
Numeric |
15,0 |
CMP Batch Number |
|
21 |
Original Request Sequence |
Y |
Numeric |
7,0 |
Line Number from CDR File |
|
22 |
Date Created |
|
Numeric |
7,0 |
Date record created in CMP. YYYY-MM-DD format. |
|
23 |
Created By |
|
Alphanumeric |
10 |
User ID of user who created the record |
|
24 |
Date Changed |
|
Numeric |
7,0 |
Date record changed in CMP. YYYY-MM-DD format. |
|
25 |
Changed By |
|
Alphanumeric |
10 |
User ID of user who created the record |
|
26 |
Data Extract Date |
|
Numeric |
7,0 |
Date that the data above was extracted from CMP. YYYY-MM-DD format. |