SMS Delivery Status

RPT_ITR_DeliveryStatus

Source

Source

nvarchar

(36) (null)

The device number (contact number) of the SMS source.

RPT_ITR_DeliveryStatus

Destination

Destination

nvarchar

(36) (null)

The device number (contact number) of the SMS destination.

RPT_ITR_DeliveryStatus

Message

Message

nvarchar

(max) (null)

The SMS text message content.

RPT_ITR_DeliveryStatus

DeliveryStatus

DeliveryStatus

nvarchar

(50) (null)

The delivery status for the SMS message. For example, Success, Failure, and so on.

RPT_ITR_DeliveryStatus

GatewayMsgID

Gateway

nvarchar

(100) (null)

This is Gateway message ID.

RPT_ITR_DeliveryStatus

ActualResponse

ActualResponse

nvarchar

(max) (null)

This is the response.

RPT_ITR_DeliveryStatus

EntryDateTime

EntryDateTime

datetime

(not null)

The date and time the record was created in the table.

RPT_ITR_DeliveryStatus

CampaignID

CampaignID

nvarchar

(64) (null)

The campaign ID from which the SMS is sent.

RPT_ITR_DeliveryStatus

ContactID

ContactID

int

(null)

The unique contact ID to which the SMS is sent.

RPT_ITR_DeliveryStatus

ProviderType

ProviderType

nvarchar

(128) (null)

RPT_ITR_DeliveryStatus

DeliveryStatusUpdatedDateTime

DeliveryStatusUpdatedDateTime

datetime

(null)

The date and time when the delivery status is updated for this record.

RPT_ITR_DeliveryStatus

ErrorCode

ErrorCode

nvarchar

(10) (null)

This is the error code for failed messages.

RPT_ITR_DeliveryStatus

TenantID

TenantID

int

(null)

The Tenant ID auto-generated by the application when a new tenant is created.