| Database Field |
type |
Descriptions
|
|---|
| account_user
|
varchar |
Account charged by this entry
|
| account_domain |
varchar |
Domain charged by this entry
|
cdr_type
|
varchar
|
CDR Type :
call - Real Time Rating
post - Post Rating
|
callid
|
varchar |
Call-ID of the termination call leg
|
| orignumber
|
varchar |
phone number of the origination party |
| origdomain |
varchar |
domain of the origination party |
| termnumber |
varchar |
phone number of the termination party |
| termdomain |
varchar |
domain of URI of the termination party |
lergclass
|
varchar
|
LERG Class
0 - not classified
1 - Inter-State, Inter-LATA
2 - Inter-State, Intra-LATA
3 - Intra-State, Inter-LATA
4 - Intra-State, Intra-LATA
5 - Local
|
time_start
|
date time
|
Start time of the call(yyyy-mm-dd hh:mm:ss) |
time_ring
|
date time
|
Ringing start time(yyyy-mm-dd hh:mm:ss) |
time_answer
|
date time
|
Answer time of the call(yyyy-mm-dd hh:mm:ss) |
time_release
|
date time
|
Release time of the call(yyyy-mm-dd hh:mm:ss) |
| release_cause |
varchar
|
Cause of release |
| duration |
double
|
Duration of call (second) |
| duration_charged |
double
|
Duration charged (second) |
| rate |
double
|
Charge per minute (dollar) |
| extra_charge |
double
|
Extra charge applied (dollars) |
| longcall_extra |
double |
Long Call Extra Charge applied (dollars) |
| disconnect_fee |
double |
Disconnect Fee applied (dollars) |
| tax |
double
|
Total Tax applied (dollars) |
total_charge
|
double
|
Total Charges (dollars) |
rate_entry
|
varchar |
Rate entry applied |
bucket_id
|
varchar
|
ID of the Minute Bucket applied
|
| bucketed_date |
date
|
Date that the Minute Bucket is applied
|
bucketed_credit
|
double
|
Credit applied from the Minute Bucket
|
tax_id
|
varchar
|
Tax ID
|
| origprefix |
varhcar |
Matched prefix of the origination number |
termrefix
|
varchar |
Matched prefix of the termination number |
account_debited
|
no or yes
|
Whether the "total_charge" has been debited from the associated
account
|
orig_conn
|
varchar |
Match Pattern of the Origination Connection
|
term_conn
|
varchar |
Match Pattern of the Termination Connection |
orig_callid
| varchar | Call-ID of the origination call leg
|
pac
| varchar | Account code
|
