cdr Table in the PBX Database
This topic describes details of cdr table stored in the database of Yeastar P-Series PBX System.
| Field | Descriptions |
|---|---|
| id | System internal flag |
| datetime | Date and time |
| timestamp | System internal flag |
| uid | System internal flag |
| clid | System internal flag |
| src | Caller's number |
| srcname | Caller's name |
| srcaddr | System internal flag |
| dst | Callee's number |
| dstname | Callee's name |
| dcontext | System internal flag |
| channel | System internal flag |
| dstchannel | System internal flag |
| srctrunk | Source trunk |
| dsttrunk | Destination trunk |
| lastapp | System internal flag |
| lastdata | System internal flag |
| duration | Total duration of the call (calculates from the beginning of the call) |
| ringduration | Ringing duration of the call |
| talkduration | Talk duration of the call (calculates after the call is answered) |
| disposition | Call status:
|
| amaflags | System internal flag |
| calltype | Communication Type
|
| accountcode | Pin code |
| uniqueid | System internal flag |
| didnumber | DID number |
| dodnumber | DOD number |
| recordfile | Recording file name |
| recordpath | Recordings path (with file name) |
| srcchanurl | Caller's SIP URI |
| dstchanurl | Callee's SIP URI |
| reasonpartya | System internal flag |
| reasonpartyb | System internal flag |
| reasonpartyc | System internal flag |
| reasonpartyd | System internal flag |
| reasonpartye | System internal flag |
| reasonpartyf | System internal flag |
| displayonweb | System internal flag |
| src_del_cdr | System internal flag |
| dst_del_cdr | System internal flag |
| src_del_recording | System internal flag |
| dst_del_recording | System internal flag |
| srcnameprefix | System internal flag |
| dstnameprefix | System internal flag |
| misscall_isread | System internal flag |
| in2outbound | System internal flag |
| concurrentcalls | System internal flag |
| videocall | System internal flag |
| rascall | System internal flag |
| tryvideocall | System internal flag |