Description of xDR record fields

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