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.

Column	Description	Example
COUNTRY_NAME	The country name(region) to which the recipient's mobile number is associated.	India
NETWORK_NAME	The name of the mobile network used to deliver the message to the mobile number.	Vodafone Essar Ltd.
SENDER	This 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
MOBILE	The mobile number to which the SMS is sent.	9198333xxxx
SOURCE	The source of the request to send the SMS. For example, API or campaign.	API
STATUS	The delivery status of the SMS.	Delivered
STATUS_TRACE	This is the sub-status of the SMS that further helps understand more about the delivery status.	Delivrd
REFUNDED	Indicates 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
CREATED	The date and the time at which the request to send a message has been received.	2023-03-01T19:07:20:000Z
SMS_LENGTH	The length of the SMS in characters.	54
BILLING_UNIT	The 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_ROUTE	The SMS route type, for example, OTP, Transactional, and Promotional.	OTP
MESSAGE_TYPE	Indicates whether the message is sent as Unicode(U) or Non Unicode(N) characters.	N
SALE_PRICE	The amount charged for the SMS delivery.	0.002
AMOUNT_REFUNDED	Amount of money refunded.	0
CAMPAIGN_NAME	The 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_KID	This is a unique identifier value for the request.	81b8b035-2cb5-4ca0-8656-b55589cc3359
DELIV_TIME	The date and time at which the SMS has been delivered to the end customer.	2023-03-01T19:07:22:000Z
REF	The REF parameter is optional. You can pass the required information for this parameter displayed in the report.
REF1	The REF1 parameter is optional. You can pass the required information for this parameter displayed in the report.
REF2	The REF2 parameter is optional. You can pass the required information for this parameter displayed in the report.