Prepaid Usage

Field No.

Field Name

Unique?

Type

Length

Details
1 Prepaid Usage Identifier Y Numeric   The ID of the prepaid usage

2

Usage Date Time

 

Numeric

 

The date and time of the prepaid usage. YYYY-MM-DD HH:MM:SS format.

3

Processed Date Time

 

Numeric

 

The date and time that the prepaid usage was processed. YYYY-MM-DD HH:MM:SS format.

4

Usage External Identifier

 

Alphanumeric

 

The reference used by an external third party to identify the prepaid usage.

5

Network Code

 

 Alphanumeric 6, 30

The code and description for the network.

6

Usage Class

 

    

The code and description of the usage class

7

Company Number

 

 Alphanumeric 3

The numerical ID of the company

8

 Service Code   Alphanumeric 6, 30 The code and description of the service
9 Service Group Code   Alphanumeric 6, 30 The code and description of the service group
10 Network Serial Number   Alphanumeric 25 As stored in CMP. Typically a mobile number or landline CLI as stored in Managed Serial Number 1.0
11 Subscription Number   Numeric 8

CMP Subscription number
12 Destination        
13 Usage Type   Alphanumeric   Usage type code and description: Voice , Text or Data
14 Wholesale Charge   Numeric 11, 4 Wholesale price of the usage
15 Retail Charge   Numeric 11, 4 Retail price
16 Access Charge   Numeric 11, 4 Monetary value of access charge
17 Service Charge   Numeric 11, 4 Monetary value of service charge
18 Actual Usage Units   Numeric 7,0 Actual units of usage consumed
19 Billable Usage Units   Numeric 7,0 Billable units of usage
20 - 29 String   Alphanumeric   Generic String values
30 -33 Integer   Integer   Generic Integer values
34

Audit Timestamp

 

Timestamp

 

Date/time the record changed in CMP.
35

Audit User

 

varchar

50

ID of user who changed the record
36

Data Extract Date

 

Numeric

7,0

Date that the data above was extracted from CMP. YYYY-MM-DD format.