INTERACTION_X_NEWMESSAGE
The INTERACTION_X_NEWMESSAGE database table contains outbound emails and SMS that are awaiting sending, as well as printed letters to be sent to customers.
Once these are picked up by the Outbound Gateway service, these records are removed from here and added instead to INTERACTION_X_MESSAGE (unless there is an error while sending an email/SMS).
| Field | Description |
|---|---|
| LKTL_NEWMESSAGENO | A unique ID for the message. Automatically added when a new record is added to this table. |
| LKTL_CLIENTNO | The interaction associated with the message. References the LKTL_CLIENTNO field in the |
| LKTL_MESSAGE |
The body of the email, SMS message, or printed letter. Either this field or BODY_SNIPPET_NO should be set, but not both. |
| LKTL_TYPE | Defines whether the message is an email (E), SMS (S), or dialog box displayed to an agent (X). |
| LKTL_CONVERSATIONID | Not used. |
| LKTL_SUBJECT |
The subject of an email. Either this field or SUBJECT_SNIPPET_NO should be set, but not both. |
| LKTL_TO | The email address or phone number to which the message should be sent. |
| LKTL_CC | For email, an email address that should be CCed in the email. |
| LKTL_FROM | The message gateway that should be used to send the email/SMS. References the IMMAILBOXNO field of the IMMAILBOX table. |
| LKTL_CONFGROUP | If an email needs to be reviewed before sending, the agent group of users who can review the email. References the AgentGroupNo field of the |
| LKTL_CONFAGENT | The user who reviewed the email. References the AGENTNAME field of the |
| LKTL_CONFDT | The date and time of the review. |
| LKTL_SENDATT | The date and time that the Outbound Gateway service attempted to send the message. |
| LKTL_SENDCONF | The date and time that the email was sent. |
| LKTL_SENDERR | An error message where the Outbound Gateway service could not send the message. |
| LKTL_MERGEDATA | |
| WHITEMAIL_FLG | Set to Y for a printed letter. |
| LKTL_COMPLETED | Marks the message as being ready to be picked up by the Outbound Gateway service (Y) or not (N). |
| LKTL_MANUALLYEDITED |
Not currently used. |
| LKTL_SENDATTEMPT | Where a message has not successfully sent, records the number of times that the Outbound Gateway service has attempted to send it. |
| BODY_SNIPPET_NO |
A snippet to use for the body text. References the SNIPPET_NO field of the SNIPPET table. Either this field or LKTL_MESSAGE should be set, but not both. |
| SUBJECT_SNIPPET_NO |
A snippet to use for the subject (for an email). References the SNIPPET_NO field of the SNIPPET table. Either this field or LKTL_SUBJECT should be set, but not both. |
| LKTL_MSGTYPE | |
| LKTL_MSGTIMEOUT | |
| LKTL_SENDDATE | The date that the message should be sent. Where populated, the Outbound Gateway service won’t pick up the message until this date. |
| LKTL_SENDTIME |
The time that the message should be sent. Where populated, the Outbound Gateway service won’t pick up the message until this time. |