|
Field |
Type |
Description |
|---|---|---|
|
id |
int |
The unique ID of the xDR |
|
i_env |
int |
The unique ID of the virtual billing environment |
|
h323_conf_id (session_id) |
string |
The unique session ID |
|
call_id (service_session_id) |
string |
The session ID specific for the xDR’s service type |
|
CLI (cli) |
string |
The caller number (also called CLI or ANI) |
|
CLD (cld) |
string |
The destination number (also called CLD, Called-Station-Id or DNIS) |
|
setup_time |
int |
Also known as PDD. The time (in ms) between the moment the first INVITE is sent in the originate leg and the moment a provisional response/final response comes from the SIP device. It is calculated by the Billing Engine as the time difference between h323-setup-time and alert-timepoint (h323-connect-time is used instead of alert-timepoint, if the latter is not present in the accounting request) |
|
connect_time |
dateTime |
The time when the session started (e.g., the call got connected) |
|
disconnect_time |
dateTime |
The time when the session was disconnected or was last updated (for incremental xDR charge) |
|
bill_time |
dateTime |
Call bill time |
|
disconnect_cause |
int |
Specifies the reason the call was disconnected. This is a hexadecimal code |
|
voice_quality |
int |
Shows call quality provided during the session as/if reported by NAS (provided for voice calls by Cisco equipment) |
|
used_quantity |
int |
The quantity that was charged in original measurement units (e.g., duration of the voice call in seconds) |
|
account_id |
string |
ID of the account being charged |
|
i_account |
int |
The unique ID of the account’s record in the database |
|
i_dest |
int |
The unique ID of the destination record |
|
i_dest_group |
int |
The unique ID of the destination group |
|
i_tariff |
int |
The unique ID of the tariff record |
|
i_rate |
int |
The unique ID of the rate record |
|
charged_quantity |
int |
The number of charged units (the service is measured based on used_quantity after applying rounding intervals) |
|
charged_amount |
float |
The amount charged in the respective currency |
|
history |
string |
The formula that shows charge application steps or a textual description of the charge applied |
|
peak_level |
int |
The ID of the peak level: 0 (peak period), 1 (off-peak period), 2 (2nd off-peak period) |
|
i_vendor |
int |
Applicable for vendor xDRs. The unique ID of the Vendor record who was billed |
|
i_service |
int |
The unique ID of the service record |
|
i_accessibility |
int |
The unique ID of the rating entry record in the database |
|
i_customer |
int |
The unique ID of the customer or the reseller (where applicable) associated with the call. This ID should be equal to the corresponding account’s owner in CDR_Accounts, to the xDR owner in CDR_Customers and to the direct customer in CDR_Vendors |
|
h323_incoming_conf_id (parent_session_id) |
string |
The unique ID of the incoming session (if exists) used for interrelating xDRs, when the charged session is established as a result of a previous session (possibly having its own xDR) |
|
rating_pattern |
string |
The rate pattern that was used to match a destination in the tariff rates |
|
subscriber_ip |
string |
The internet address of the end-user (if applicable) which was assigned to him in the moment of charge application |
|
split_order |
int |
The xDR order number in case it is a part of the group of xDRs created for the same session |
|
billing_model |
int |
Specifies the account type; one of the following: -1 – Debit account 1 – Credit account |
|
i_invoice |
int |
The unique ID of the invoice record. Designates the invoice where the xDR was settled |
|
revenue |
float |
Applicable for vendor xDRs. Shows total revenue collected for the related session |
