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