CDR Export
Overview
The CDR Manager allows platform users to schedule the export of CDR files in CSV format.
There are 3 types of exports that the platform supports: Owner, Supplier and Customer. The fields contained in the chosen type you can find in the Templates below.
File Layout Elements
| Field Name |
Example |
DataType |
Length |
Format |
Description |
Contained In |
| SMS_DT |
2020-09-14 00:00:01 Europe/Zurich |
DATETIME |
- |
2020-09-14 00:00:01 |
Date and time when the message entered in our system(input timestamp), the time zone is defined in the CDR task |
Owner Customer Supplier |
| MESSAGE_ID |
4bfc6e62-c7ba-417f-9ddf-8e2b35509456 |
VARCHAR |
40 |
RFC 4122 UUID |
Given Message-ID from the Platform |
Owner Customer Supplier |
| SENDER |
FACEBOOK |
VARCHAR |
30 |
- |
Sender ID/Number |
Owner Customer Supplier |
| DESTINATION |
33753483680 |
VARCHAR |
30 |
381641786201 |
Destination Number |
Owner Customer Supplier |
| DST_COUNTRY |
France |
VARCHAR |
50 |
- |
Destination Country |
Owner Customer Supplier |
| DST_OPERATOR |
LycaMobile France |
VARCHAR |
255 |
- |
Destination Operator Name |
Owner Customer Supplier |
| DST_MCC |
208 |
SMALLINT |
65535 |
- |
Destination MCC |
Owner Customer Supplier |
| DST_MNC |
25 |
SMALLINT |
65535 |
- |
Destination MNC |
Owner Customer Supplier |
| SELL_PRICE |
0.0288 |
DECIMAL(10,4) |
- |
Decimal separator: . |
Selling Price * Digits after comma are now 4. This can change in future to 6 and 8Depending on settings in price list. |
Owner Customer |
| SELL_CURRENCY |
EUR |
CHAR |
3 |
- |
Selling Price Currency |
Owner Customer |
| CONNECTION |
2961_WW |
VARCHAR |
45 |
- |
Connection Name defined on Platform |
Owner Customer |
| CUSTOMER_NAME |
Facebook Corporation |
VARCHAR |
150 |
(text) |
BP Customer Name |
Owner Customer |
| CUSTOMER_ID |
2961 |
INTEGER |
- |
- |
BP ID (internal) |
Owner Customer |
| SENDING_STATUS |
Sent OR Error |
ENUM('Sent','Error') |
- |
'Sent' or 'Error' |
Sending Status |
Owner Customer |
| DLR_STATUS |
Delivered, Undelivered, Unknown |
ENUM('Delivered', 'Undelivered', 'Buffer'. 'Sent', 'Rejected', 'Unknown') |
- |
'Delivered', 'Undelivered', 'Buffer'. 'Sent', 'Rejected', 'Unknown' |
DLR Status |
Owner Customer Supplier |
| CLIENT_IP |
195.43.46.113 |
CHAR |
15 |
xxx.xxx.xxx.xxx |
Client IP Address |
Owner Customer |
| FAILURE_CODE |
0 or ? |
SMALLINT |
65535 |
- |
Outgoing failure code, provided by the supplier. This code is supplier-specific. |
Owner Customer Supplier |
| DLR_DT |
2020-09-14 00:00:08 Europe/Zurich |
DATETIME |
- |
'2020-09-14 00:00:08' |
Date and time when the delivery report arrived, the time zone is defined in the CDR task |
Owner Customer |
| BUY_PRICE |
0.0285 |
DECIMAL(10,4) |
- |
- |
Buy Price from Supplier Price List |
Owner |
| BUY_CURRENCY |
EUR |
CHAR |
3 |
- |
Buy Price Currency from Supplier Price List |
Owner |
| MNP_PRICE |
0.00022 |
DECIMAL(7,4) |
- |
- |
MNP (Buy) Price |
Owner |
| MNP_CURRENCY |
EUR |
CHAR |
3 |
- |
MNP (Buy) Price Currency |
Owner |
| SUPPLIER_GATE_NAME |
Mr Messaging HQ (bulk) |
VARCHAR |
70 |
(text) |
Supplier Gate Name defined on Platform |
Owner Supplier |
| SUPPLIER_GATE_ID |
14127 |
INTEGER |
- |
- |
Supplier Gate ID gave from Platform |
Owner Supplier |
| SUPPLIER_CUSTOMER_ID |
3037 |
INTEGER |
- |
- |
Business partner ID. In the owner and supplier reports. This attribute presents the owner of the gate (throughout the message was sent). |
Owner Supplier |
| CUSTOMER_CHARGE_MODE |
sent OR delivered |
ENUM ('Sent', 'Delivered') |
- |
Sent or Delivered |
Charge Mode defined for Customer |
Owner Customer |
| SUPPLIER_CHARGE_MODE |
sent OR delivered |
ENUM('Sent', 'Delivered') |
- |
'Sent', 'Delivered' |
Charge Mode defined for Supplier |
Owner Supplier |
| BRIEF_MESSAGE |
12345 es tu codigo de Facebook xxxxx |
VARCHAR (text field) |
100 |
(text) |
Short message part, the first 100 bytes |
Customer |
| CUST_BP_REFERENCE_ID |
V0234C2323 |
VARCHAR |
100 |
- |
Customer BP Reference ID |
Customer |
| SUP_BP_REFERENCE_ID |
V0234C2323 |
VARCHAR |
100 |
- |
Supplier BP Reference ID |
Customer |
| FOREIGN_MESSAGE_ID |
693c5d2b-40f9-d175-8095-3139a5a97f9d |
VARCHAR |
60 |
- |
Foreign message ID provided by the supplier |
Owner Supplier |
Templates
Customer
| Field Name |
Example |
| SMS_DT |
2020-09-14 00:00:01 Europe/Zurich |
| MESSAGE_ID |
4bfc6e62-c7ba-417f-9ddf-8e2b35509456 |
| SENDER |
FACEBOOK |
| DESTINATION |
381641786201 |
| DST_COUNTRY |
France |
| DST_OPERATOR |
LyctoperaMobile France |
| DST_MCC |
208 |
| DST_MNC |
208,25,0.0288 |
| SELL_PRICE |
EUR |
| SELL_CURRENCY |
2961_WW |
| CONNECTION |
Facebook Corporation |
| CUSTOMER_NAME |
2961 |
| CUSTOMER_ID |
Sent |
| SENDING_STATUS |
Delivered |
| DLR_STATUS |
195.43.46.113 |
| CLIENT_IP |
0 |
| FAILURE_CODE |
2020-09-14 00:00:08 Europe/Zurich |
| DLR_DT |
Sent |
| CUSTOMER_CHARGE_MODE |
- |
Owner
| Field Name |
Example |
| SMS_DT |
2020-09-14 00:00:01 Europe/Zurich |
| MESSAGE_ID |
4bfc6e62-c7ba-417f-9ddf-8e2b35509456 |
| SENDER |
FACEBOOK |
| DESTINATION |
381641786201 |
| DST_COUNTRY |
France |
| DST_OPERATOR |
LycaMobile France |
| DST_MCC |
208 |
| DST_MNC |
25 |
| SELL_PRICE |
0.0288 |
| SELL_CURRENCY |
EUR |
| CONNECTION |
2961_WW |
| CUSTOMER_NAME |
Facebook Corporation |
| CUSTOMER_ID |
2961 |
| SENDING_STATUS |
Send |
| DLR_STATUS |
Delivered |
| CLIENT_IP |
195.43.46.113 |
| FAILURE_CODE |
0 |
| DLR_DT |
2020-09-14 00:00:08 Europe/Zurich |
| BUY_PRICE |
0.5555 |
| BUY_CURRENCY |
EUR |
| MNP_PRICE |
0.00022 |
| MNP_CURRENCY |
EUR |
| SUPPLIER_GATE_NAME |
Telecom |
| SUPPLIER_GATE_ID |
14127 |
| SUPPLIER_CUSTOMER_ID |
3037 |
| CUSTOMER_CHARGE_MODE |
Sent |
| SUPPLIER_CHARGE_MODE |
Sent |
| BRIEF_MESSAGE |
12345 es tu codigo de Facebook xxxxx |
| CUST_BP_REFERENCE_ID |
V0234C2323 |
| SUP_BP_REFERENCE_ID |
V0234C2323 |
| FOREIGN_MESSAGE_ID |
693c5d2b-40f9-d175-8095-3139a5a97f9d |
Supplier
| Field Name |
Example |
| SMS_DT |
2020-09-14 00:00:01 Europe/Zurich |
| MESSAGE_ID |
4bfc6e62-c7ba-417f-9ddf-8e2b35509456 |
| SENDER |
FACEBOOK |
| DESTINATION |
381641786201 |
| DST_COUNTRY |
France |
| DST_OPERATOR |
LycaMobile France |
| DST_MCC |
208 |
| DST_MNC |
25 |
| SENDING_STATUS |
Sent |
| DLR_STATUS |
Delivered |
| CLIENT_IP |
195.43.46.113 |
| FAILURE_CODE |
0 |
| DLR_DT |
2020-09-14 00:00:01 Europe/Zurich |
| BUY_PRICE |
0.555 |
| BUY_CURRENCY |
EUR |
| SUPPLIER_GATE_NAME |
Telecom |
| SUPPLIER_GATE_ID |
14127 |
| SUPPLIER_CUSTOMER_ID |
3037 |
| SUPPLIER_CHARGE_MODE |
Sent |