- DarkLight
SMS Inbound Session
- DarkLight
Source Table | Column Name | Display Name | Data Type | Description | Platform |
---|---|---|---|---|---|
RPT_ITR_SessionDetail | ID | ID | nvarchar (36) (null) | Auto-generated unique identifier for incoming message. | All |
RPT_ITR_SessionDetail | Text | Text | nvarchar (max) (null) | The text of the message sent via SMS. | All |
RPT_ITR_SessionDetail | IsSent | IsSent | bit (not null) | This indicates whether the message is sent to the contact. | All |
RPT_ITR_SessionDetail | Date | Date | datetime (not null) | The date when the SMS message was sent. | All |
RPT_ITR_SessionDetail | Title | Title | varchar (not null) | The subject of the SMS message | All |
RPT_ITR_SessionDetail | Answer | Answer | nvarchar (max) (null) | The response received from the recipient of the message. | All |
RPT_ITR_SessionDetail | SequenceId | SequenceId | int (null) | The auto generated ID for the message received by the application. | All |
RPT_ITR_SessionDetail | GatewayMsgID | GatewayMsgID | nvarchar (128) (null) | The ID generated by the SMS Gateway for this message | All |
RPT_ITR_SessionDetail | AccountNumber | AccountNumber | nvarchar (256) (null) | The Account number (LCMKey / CAID) of the contact. | All |
RPT_ITR_SessionDetail | CampaignID | CampaignID | nvarchar (128) (null) | The campaign ID to which the Inbound SMS is received. | All |
RPT_ITR_SessionDetail | RefGatewayMsgID | RefGatewayMsgID | nvarchar (100) (null) | The message ID generated by the SMS gateway. | All |
RPT_ITR_SessionDetail | ContactID | ContactID | int (null) | The unique contact ID from which the inbound message is received. | All |
RPT_ITR_SessionDetail | TenantID | TenantID | int (null) | The Tenant ID auto-generated by the application when a new tenant is created. | All |
RPT_ITR_SessionDetail | SubTenantID | SubTenantID | int (null) | The Sub Tenant ID autogenerated by the application when a new tenant is created. | All |