This article reviews the columns in the Portal CDR downloads and the file sent to partners subscribed to the monthly CDR receiving list.

Portal CDR - Call History Export

To access call detail records through the portal, navigate to the call history page. 

Fliter the Call Detail Records:   Select the "Columns" button to check fields  in the dropdown that you want to show in the view.   Filter the results by selecting the "Filter" button. The view can be sorted by selecting the options from the Call History Filters modal.     Click the "Export" button to download the records that you have filtered.
To schedule a new export select the "Scheduled Export" button which opens up the "Schedule New Export" modal. This modal has two tabs: Basic and Options.
You can export CDRs using the Portal, and there are three formats available: basic (the most recently used exported fields), advanced (the most commonly used fields), and standard (all available fields). The advanced format is the most common format used. The columns for each format are listed below.

Offnet Only Advanced Format CDR

Only eligible subscribers will receive this type of CDR. A request to receive this report must be made to your representative.

For rating purposes, IB/Inbound means calls made, while OB/Outbound means calls received.

1. Local Time - According to MST/DST time.
2. UTC Time - This is the time used in all rating systems. 
3. ANI - Automatic Number Identification- is the phone number registered in the system as the Caller ID.
4. Inpulsed Digits    
5. Outpulsed Digits - Translated digits (if any) that will be sent to SBC (Session Border Controller) or carrier.   
6. Raw Seconds - Duration of the call.    
7. IB Billed Seconds - Rounded duration of the inbound call (vary according the type of the partner, Reseller or Service Provider, and has different rounding, 60/60, 60/30, 30/6, first number indicates how much time will be charged in the call by default and the second meaning after the first, how much time will be considered to charge.
8. IB Currency    
9. Inbound RevenueThis is, in most cases, the total charge for the call, including toll-free calls.   
10. OB Billed Seconds - Rounded duration for the outbound call (also varies according to partner's type).   
11. OB Currency    
12. Outbound Cost  - Normally, this is the charge from the carrier that made the call.   
13. Originating TG - The territory/domain that originated the call.   
14. Terminating TG - The territory/domain/IP/SBC that terminated the call.   
15. Originating Switch-specific Extra Field - Can be ignored for now.   
16. Terminating Switch-specific Extra Field - Can be ignored for now.    
17. IB-Rated Digits - This is the number used to rate the inbound call. This is where the rating recognizes the prefix, strips all special characters and translations, and returns an E. 164-format number.   
18. OB Rated Digits - The number used to rate the inbound call. This is where the rating recognizes the prefix, strips all special characters and translations, and returns an E. 164-format number.   
19. IB Region Name - The name of the "rate plan" used to rate the inbound call. It is helpful to identify toll-free calls and off-net calls.   
20. OB Region Name - The name of the "rate plan" used to rate the inbound call. It is helpful to identify toll-free calls and off-net calls.   
21. Originating Carrier ID - This is the ID of the "carrier" that originated the call, which will likely be the territory. This ID is an internal identification used by WebCDR and can be ignored.    
22. Originating Carrier Name - This is the name of the "carrier" that originates the call, which will likely be the territory. (STD) indicates standard rate, and (TFN) indicates toll-free rates.    
23. Terminating Carrier ID - This is the ID of the "carrier "that terminated the call, which will likely be the session border controller (SBC). This ID is an internal identification used and can be ignored.   
24. Terminating Carrier Name - This is the name of the "carrier" that terminated the call, which will likely be the SBC.
25. Treatment Code - Indicates how the call was treated (ended, transferred, denied, failed, etc).
26. Completion Code - This field is usually empty.    
27. Originating Span - Indicates the domain that originated the call.   
28. Terminating Span - Indicates the domain that terminated the call, which will usually be empty.  
29. Originating Channel - Indicates the user from the originating domain that originated the call.   
30. Terminating Channel - Indicates the user from the terminating domain that terminated the call, which will usually be empty.   

For users receiving this file, they generally focus on the following fields:

1. UTC Time - The date and time of the call.
2. Raw Seconds - The duration of the call.
3. IB Billed Seconds - Number of seconds charged for the call.
4. Inbound Revenue -  The charge for the call.
   1. Originating TG - The territory the call belongs to.
5. IB Rated Digits - The number called.
6. IB Region Name - The region of the number called.
7. Originating Span - The domain of the call.
8. Originating Channel - The user who made or received (in the case of toll-free) the call.