INTERACTION_X_MESSAGE
The INTERACTION_X_MESSAGE database table contains:
- Inbound emails
- Outbound emails and SMS that have been sent
- Transcripts of chats
- Printed letters to customers
Outbound messages awaiting sending are stored in the INTERACTION_X_NEWMESSAGE table.
| Field | Description |
|---|---|
| LKTL_MESSAGENO | A unique ID for the message. Automatically added when a new record is added to this table. |
| LKTL_IMMAILBOXNO | The message gateway associated with the message. References the IMMAILBOXNO field of the IMMAILBOX table. |
| LKTL_CLIENTNO | The interaction associated with the message. References the LKTL_CLIENTNO field of the INTERACTION_X table. |
| LKTL_MESSAGE | The body of the email or SMS message, the chat transcript, or the text of the printed letter. |
| LKTL_TYPE | Defines whether the message is inbound (I) or outbound (O). |
| LKTL_MESSAGEID | For emails, a unique ID for the email from the email system. |
| LKTL_CONVERSATIONID | For emails, the ID of the conversation from the email server. Not used. |
| LKTL_SUBJECT | The subject of an email. For a chat, the word Chat is populated. |
| LKTL_DATE | The date of the email/chat/SMS. |
| LKTL_TIME | The time of the email/chat/SMS. |
| WHITEMAIL_FLG |
Indicates a printed letter to the customer. Letters, as with emails and SMS, can be added to the INTERACTION_X_NEWMESSAGE table. They are then moved to the INTERACTION_X_MESSAGE table by the Outbound Gateway service. |
| LKTL_CONFGROUP | The confirmation agent group, where an outbound email required confirmation before sending. References the AgentGroupNo field of the |
| LKTL_CONFAGENT | The agent who confirmed the email, where an outbound email required confirmation before sending. References the AGENTNAME field of the AGENT table. |
| LKTL_CONFDT | The date and time that the email was confirmed, where an outbound email required confirmation before sending. |
| LKTL_ORIGMAILBOXNO | For a left message, records the message gateway of the associated web chat topic. References the IMMAILBOXNO field in the IMMAILBOX table. |
| LKTL_EMAIL | The customer’s email address or phone number. |