Billing Detail Record (BDR) Field Descriptions

Follow

Molly Katolas

Updated

Check out our video demonstration on How to Download Billing Detail Records (BDRs) on the Bandwidth Learning Lab!

The table below describes the fields available in the BDR export file:

Field Example Values Type Length Description
AccountNumber 1234567 varchar 15 Customer account number
CallStartDateTime 2015-09-12 10:3:05 AM
2015-10-19 9:12:46 PM
nvarchar 4000 Date/time the call started - UTC
CallEndDateTime 2015-09-12 10:3:05 AM
2015-10-19 9:12:46 PM
datetime 8 Date/time the call ended - UTC
CallType TOLL-FREE ORIGINATION
INTERSTATE
varchar 21 Usage type categorizing the call
CallSource 1NPANXXXXXX varchar 50 "From" telephone number
CallDestination NPANXXXXXX varchar 50 "To" or dialed telephone number
Duration 198 varchar 20 Length of call in rounded seconds
PerMinRate 0.0115 numeric 5 Per minute rate in customer contract
Amount 0.05175 numeric 5 Total billed amount of call (before taxes)
TierType 0, 1 , 3, etc. varchar 5 Tier associated with inbound calls 
SourceCountry US varchar 10 Country of "from" number
SourceState MT varchar 10  State of "from" number
SourceLATA 650 varchar 10 LATA of "from" number
SourceRateCenter BILLINGS varchar 20 Rate Center of "from" number 
DestinationCountry US varchar 10 Country of dialed number
DestinationState CO varchar 20 State of dialed number
DestinationLATA 656 varchar 10 LATA of dialed number
DesinationRateCenter DENVER varchar 50 Rate Center of dialed number
CallID 58337677151 varchar 15 Call record identifier
BdrID 58337677151 varchar 15 Call record identifier
SourceIP 11.11.11.11 varchar 15 IP tied to "from" number
DestinationIP 11.11.11.11 varchar 255 IP tied to dialed number
RateAttempts 1, 2, 3, etc tinyint 1 Number of times the record has been rated
LRN 1NPANXXXXXX varchar 50 LRN tied to dialed number (if available) 
LocationID 123456 varchar 20 Customer location in Bandwidth Dashboard
SubAccountID 1234 varchar 50 Customer subaccount in Bandwidth Dashboard
LocationName "Production Peer" varchar 100 Name of the location associated with the phone number
SubAccountName "Production Subaccount" varchar 100 Name of the subaccount associated with the phone number

 

Article is closed for comments.