Bandwidth Dashboard
911 Access Dashboard
Billing Detail Record (BDR) Field Descriptions
Follow
Molly Katolas
The table below describes the fields available in the Billing Detail Record (BDR) export file. Looking for information on how to download BDRs? You can find it here!
| 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 |
Was this article helpful?
6 out of 12 found this helpful
Article is closed for comments.