- DarkLight
SMS Delivery Status
- DarkLight
Source Table | Column Name | Display Name | Data Type | Description | Platform |
---|---|---|---|---|---|
RPT_ITR_DeliveryStatus | Source | Source | nvarchar (36) (null) | The device number (contact number) of the SMS source. | All |
RPT_ITR_DeliveryStatus | Destination | Destination | nvarchar (36) (null) | The device number (contact number) of the SMS destination. | All |
RPT_ITR_DeliveryStatus | Message | Message | nvarchar (max) (null) | The SMS text message content. | All |
RPT_ITR_DeliveryStatus | DeliveryStatus | DeliveryStatus | nvarchar (50) (null) | The delivery status for the SMS message. For example, Success, Failure, and so on. | All |
RPT_ITR_DeliveryStatus | GatewayMsgID | GatewayMsgID | nvarchar (100) (null) | This is Gateway message ID. | All |
RPT_ITR_DeliveryStatus | ActualResponse | ActualResponse | nvarchar (max) (null) | This is the response. | All |
RPT_ITR_DeliveryStatus | EntryDateTime | EntryDateTime | datetime (not null) | The date and time the record was created in the table. | All |
RPT_ITR_DeliveryStatus | CampaignID | CampaignID | nvarchar (64) (null) | The campaign ID from which the SMS is sent. | All |
RPT_ITR_DeliveryStatus | ContactID | ContactID | int (null) | The unique contact ID to which the SMS is sent. | All |
RPT_ITR_DeliveryStatus | ProviderType | ProviderType | nvarchar (128) (null) | The SMS provide type such as SMPP. | All |
RPT_ITR_DeliveryStatus | DeliveryStatusUpdatedDateTime | DeliveryStatusUpdatedDateTime | datetime (null) | The date and time when the delivery status is updated for this record. | All |
RPT_ITR_DeliveryStatus | ErrorCode | ErrorCode | nvarchar (10) (null) | This is the error code. | All |
RPT_ITR_DeliveryStatus | TenantID | TenantID | int (null) | The Tenant ID auto-generated by the application when a new tenant is created. | All |
RPT_ITR_DeliveryStatus | SubTenantID | SubTenantID | int (null) | The Sub Tenant ID autogenerated by the application when a new tenant is created. | All |