BillMax CDR Input Format

The BillMax CDR file input format is a Comma Separated Value (CSV) file. There should be no header line. Processing of original CDRs should result in this format.

Column Description
Source The original source/inbound of the call.
Destination The original destination/outbound of the call.
Source Channel The source/inbound channel or path of the call.
Destination Channel The destination/outbound channel or path of the call.
Start of Call The time stamp of the start of the call - UTC
End of Call The time stamp of the end of the call - UTC
Billable Seconds  
Source Key 1 The first source/inbound value to try to match to the Package/Service d01 value.
Source Key 2 The second source/inbound value to try to match to the Package/Service d01 value.
Destination Key 1 The first destination/outbound value to try to match to the Package/Service d01 value.
Destination Key 2 The second destination/outbound value to try to match to the Package/Service d01 value.
Destination Rate Deck Key The destination/outbound value to match to a value in a Rate Deck.
Flags A bit mask denoting what type of call the CDR represents:
2
Operator assisted
4
International
8
N11 call
16
Toll Free
32
Local Call
Unique ID A unique id for the record. Combined with Start of Call in the BillMax database to create a unique key across sources.
Status Status of call.
0
Call is in progress.
1
Call is complete.
Time Call Answered The time stamp of when the call was answered - UTC
Record Number Record number of CDR in current file/dataset.
Direction of Call
0
Not specified in CDR. BillMax will derive it.
1
Call is outbound from Customer.
2
Call is inbound to Customer.