| SMS_DT | 2020-09-14 00:00:01 Europe/Zurich | DATETIME | - | 2020-09-14 00:00:01 | Date and time when the message entered 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 currently 4. This may 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, shown in owner and supplier reports. This attribute identifies the owner of the gate throughout which 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 |