Users with appropriate privileges and services can submit a request to download call details that have been billed to all the accounts or groups to which they are provisioned. The call details are downloaded in a zipped file that contains separate comma delimited (CSV) files for each service family selected.
Note: Call detail download file fields are described below.
To request call detail downloads:
On the main menu bar, from the View Bill menu, select Call Detail Download. The Request Call Detail Download page is displayed.
From the Invoice Month dropdown list, select the month.
Note: Archived bills do not appear in the Invoice Month dropdown list. If you want to download archived bill call details, request the archived bill. After the bill becomes available, it appears in the dropdown list.
From the Delivery Profile dropdown list, select the type of delivery profile.
Notes:
If you select No FTP Delivery, the call detail bill download is not transmitted to the user’s company server. If you select an existing delivery profile the bill download is transmitted to the user’s company server.
The Delivery Profile dropdown list includes a list of existing delivery profiles with Active status.
If you want to create a new delivery profile, click Create Delivery Profile. The Create Delivery Profile page is displayed.
On the list, mark the service families for the call details to download.
Notes:
Select all service families by clicking Select All.
Clear all checkboxes by clicking Clear All.
Click Submit. The Request Call Detail Download confirmation page is displayed.
Click OK.
Note: You will need to check the Retrieve Download page and retrieve the processed file within 14 calendar days.
The call details fields in the table below are included in the download files.
Note: Not all fields are included in each download file. The service family determines which fields are included in each download file.
Field Name (as appears in the header) |
Field Content |
CONF_RECGRPID |
Conference record group ID |
ACCCODEONE |
Account code one |
ACCCODETHREE |
Account code three |
ACCCODETWO |
Account code two |
Access_Type |
Access type |
Account_Cd |
Account code |
Account_Cd_Lbl |
Account code label |
Account_ID |
Account formatted value |
ACCSSM |
Access method |
Add_Mins |
Additional minutes |
ADDCRG |
Additional charge |
Aggregator_ID |
Aggregator formatted value (in most cases the value will be '---') |
AIRTIMECHG |
Airtime charge |
ASSPTR1 |
Association pointer 1 |
ASSPTR2 |
Association pointer 2 |
ASSUSRNAME |
Associated user name |
ATBSSERVTYP |
ATBS service type |
AUTH_CD_IND |
Authorization code indicator |
Ban |
Billing account number |
Ban_Label |
Billing account number label |
BILLED_CALLS |
Billed calls |
Billed_On_Behalf_Of |
Billed on behalf of |
BILLIDNF |
Billing identifier |
BRIDGCHG |
Bridge charges |
BRIDGDISC |
Bridge discount |
BRIDGNPANXX |
Bridge NPA /NXX |
Bytes |
Bytes |
CALL_AREA_ID |
Call area identifier |
Call_completed_ind_id |
Identifier of call completed indicator |
Call_date |
Call date in format MM/DD/YYYY HH:MM:SS (HH in 24 hour format) |
Call_DateTime |
Call date and time in format MM/DD/YYYY HH:MM:SS (HH in 24 hour format) |
Call_Duration_sec |
Call duration in format 9999 |
Call_Jurisdiction_Cd |
Call jurisdiction code |
Call_Minutes |
Call duration in minutes |
CALLDIR |
Call Direction |
CALLDT |
Call Date |
CALLTM |
Call Time |
CALTYPSUMDESC |
Call type summary description |
CALTYPSUMFLG |
Call type summary flag |
CCLFOURDIGIT |
Credit card last four digits |
CCTYP |
Credit card type |
Charge_AMT |
Charge amount in format 9999.99 |
Charge_group |
Charge group description |
CHGGFK |
Charge group ID |
CNTNUMBER |
Contract Number |
CONECDATE |
Connection date |
CONECDURE |
Connection duration |
CONECID |
Connection ID |
CONECTIME |
Connection time |
CONF_SDATE |
Conference actual start date |
CONF_STIME |
Conference actual start time |
Connect_ind |
Connection indication code (F, P, U, N, S) |
Credit_amount |
Credit amount |
Credit_reason_code |
Credit reason code |
CUSTCONFID |
Customer conference ID |
Dialed_number |
Dialed number. For Inbound – NULL |
Discount_AMT |
Discount amount in format 9999.99 |
From_city |
From city description |
From_state |
From state code (Examples – New Jersey, France) |
FROMCOUNTRY |
From country |
FTRCD |
Feature code |
Group_ID |
Group formatted value |
HID |
Hierarchy identifier |
HOST |
Host name |
HOSTNUM |
Host number |
INT_TAX |
International tax |
Invoice_date |
Invoice date in format MM/DD/YYYY |
INVOICE_NUM |
Invoice number |
Invoice_number |
Invoice number |
Journal_jur |
Journal jurisdiction code |
LDADDCRG |
Long distance charge |
Legend1 |
Legend text 1 |
Legend2 |
Legend text 2 |
LEGSUCHG |
Leg setup charges |
LEGSUDISC |
Leg setup discount |
Mdn |
MDN (Mobile Directory Number) |
Min1 |
Minutes in first rate period |
Min2 |
Minutes in second rate period |
Mobility_International_Indicator |
Mobility international indicator |
MOBRATECD |
Mobility rate code |
MOBRATEPRDCD |
Mobility rate period code |
NUMCALLED |
Number called |
Orig_NPA |
Originating NPA (Number Plan Area) |
Orig_num |
Originating number |
PARTITION_KEY |
Partition key |
PARTNAME |
Participant name |
PARTNUM |
Participant number |
PFAMFK |
Product family ID |
POSTDSCTCRG |
Post discount charge |
Pre_disc_air_charge |
Prediscount air charge |
Pre_disc_toll_charge |
Prediscount toll charge |
Pre_Discount_Charge_Amt |
Prediscount charge amount in format 9999.99 |
Product_desc |
Transcode description |
PTYPFK |
Product type ID |
QUANTITY |
Quantity |
Rate_Period |
First rate period description |
Rate_Period_2 |
Second rate period description |
REF_SEQNUM |
Reference sequence number |
SERTYP |
Service type |
Service_family |
Service family description |
Service_ID |
Service formatted value |
Service_location |
Service location (NULL in most cases). For inbound – NULL |
Service_type |
Service type description |
Subaccount_ID |
Subaccount formatted value |
SUTYP |
Setup type |
SVCARRID |
Service arrangement ID |
Tax_AMT |
Tax amount in format 9999.99 |
TAX_IND_CITY |
City tax indicator |
TAX_IND_COUNTY |
County tax indicator |
TAX_IND_FED |
Federal tax indicator |
TAX_IND_FRAN |
Franchise tax indicator |
TAX_IND_GROSS |
Gross tax indicator |
TAX_IND_STATE |
State tax indicator |
Term_NPA |
Terminating NPA (Number Plan Area) |
Term_num |
Terminating number |
Term_place |
Terminating place |
TEXTFLD |
Text Field |
To_city |
To city description |
To_state |
To state description (Examples – New Jersey, France) |
TRANFK |
Transcode ID |
TRNPTCHG |
Transport charges |
TRNPTDISC |
Transport discounts |
UNITMSR |
Unit of measure |
UNIT_RATE |
Unit rate |
USOC_CD |
Universal Service Order Code |
The structure of inbound and outbound download files is identical. Fields that are not relevant to inbound files (dialed number and service location) are sent as NULL.
All spaces in field names are underscored (‘_’). (e.g. 'Service type' is 'Service_type'). This enables users to easily import the data into systems which do not support spaces in titles.
Related Topics