OUT_SMS
The table OUT_SMS is the main table for the SMS (Text Messaging) out service. Records inserted into this table will be sent to specified mobile phone number. The table contains the specifics of the outgoing text messages like from, to and text message.
Column | Required (not Null) | Type | Values | Comments |
gKey | Yes | Uniqueidentifier | Unique Boomerang event key. gKey needs to exist in EVENT_MASTER | |
jKey | Yes | Uniqueidentifier | Unique Boomerang job key | |
ID | Varchar(50) | Service provider remote ID. Id is supplied by SMS service provider (Twilio) once SMS message has been sent. Do not insert anything into column. | ||
From | Varchar(50) | SMS from mobile (cell) phone number. Default value can be entered in the Boomerang admin console. From number needs to be supplied here or in admin console for a successful transmission. | ||
To | Yes | Varchar(50) | SMS to mobile (cell) phone number. | |
Text | Yes | Varchar(160) | SMS text message | |
Processed_On | Datetime | Field will be updated by Boomerang on a successful transmission. Do not insert anything into column. | ||
Price | Float | SMS message cost price. Field will be updated by Boomerang on a successful transmission. Do not insert anything into column. |
See also
IN_SMS
sp_After_SMS_Job
sp_On_SMS_In
sp_On_Sms_Status
sp_Resubmit_Sms
Configuring SMS Services – Twilio