OUT_SMS

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