SMS Tabular only MT Report

The SMS tabular MT report shows all the relevant details of the messages sent by the organization to customers. If you are requesting the tabular report before the implementation of MO and MT reports, then you can find the details of your report in the file SMS Tabular only MT Report.

ColumnDescriptionExample
COUNTRY_NAMEThe country name(region) to which the recipient's mobile number is associated.India
NETWORK_NAMEThe name of the mobile network used to deliver the message to the mobile number.Vodafone Essar Ltd.
SENDERThis is the sender ID. A Sender ID is a unique name or standard mobile number that shows in the “from” field of your text messages on your phone. It could be a phone number, an alpha-numeric, an alphabetic, or a numeric alias.Kalyra
MOBILEThe mobile number to which the SMS is sent.9198333xxxx
SOURCEThe source of the request to send the SMS.
For example, API or campaign.
API
STATUSThe delivery status of the SMS.Delivered
STATUS_TRACEThis is the sub-status of the SMS that further helps understand more about the delivery status.Delivrd
REFUNDEDIndicates if the SMS service amount is refunded or not.
The value ‘1’ in the field means that either some part or the whole amount is refunded.
The value ‘0’ in the field means that no refund is done.
0
CREATEDThe date and the time at which the request to send a message has been received.2023-03-01T19:07:20:000Z
SMS_LENGTHThe length of the SMS in characters.54
BILLING_UNITThe billing unit applied to the SMS service. The value '1' means that the whole text has been sent as one single SMS and a value more than '1' means that the whole text has been sent in several concatenated SMS.1
SMS_ROUTEThe SMS route type, for example, OTP, Transactional, and Promotional.OTP
MESSAGE_TYPEIndicates whether the message is sent as Unicode(U) or Non Unicode(N) characters.N
SALE_PRICEThe amount charged for the SMS delivery.0.002
AMOUNT_REFUNDEDAmount of money refunded.0
CAMPAIGN_NAMEThe name of the campaign through which the SMS is sent.
Note: If the SMS is sent outside of any campaign, this field is empty.
BBD_SALE
CAMPAIGN_KIDThis is a unique identifier value for the request.81b8b035-2cb5-4ca0-8656-b55589cc3359
DELIV_TIMEThe date and time at which the SMS has been delivered to the end customer.2023-03-01T19:07:22:000Z
REFThe REF parameter is optional. You can pass the required information for this parameter displayed in the report.
REF1The REF1 parameter is optional. You can pass the required information for this parameter displayed in the report.
REF2The REF2 parameter is optional. You can pass the required information for this parameter displayed in the report.