CDR File Layout

1. Overview

The CDR Manager allows the platform users to schedule the export of the CDR files in CSV format.
There are three 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.

2. 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: . (a period) Selling Price.
* Decimal places are now 4. This can be changed in future to 6 and 8. Depending on the settings in a price list.		 Owner Customer
SELL_CURRENCY EUR CHAR 3 - Selling Price Currency. Owner Customer
CONNECTION 2961_WW VARCHAR 45 - Connection Name defined on the 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 Supplier
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 Supplier
BUY_PRICE 0.0285 DECIMAL(10,4) - - Buy Price from Supplier Price List. Owner Supplier
BUY_CURRENCY EUR CHAR 3 - Buy Price Currency from Supplier Price List. Owner Supplier
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 the Platform. Owner Supplier
SUPPLIER_GATE_ID 14127 INTEGER - - Supplier Gate ID given from the 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. Owner
CUST_BP_REFERENCE_ID V0234C2323 VARCHAR 100 - Customer BP Reference ID. Owner
SUP_BP_REFERENCE_ID V0234C2323 VARCHAR 100 - Supplier BP Reference ID. Owner
FOREIGN_MESSAGE_ID 693c5d2b-40f9-d175-8095-3139a5a97f9d VARCHAR 60 - Foreign message ID provided by the supplier. Owner Supplier

3. Templates

3.1 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 LycaMobile 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 -

3.2 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

3.3 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