IN_SMS

The table IN_SMS contains all text messages (SMS) sent to Boomerang.

You should not directly manipulate this table as it automatically receives rows from Boomerang Services each time a new incoming message is received.

Column	Type	Values	Comments
rKey	Uniqueidentifier		Unique Boomerang key
Created_On	Datetime		Date and time when the record was created.
ID	Datetime		Service provider remote ID. Id is supplied by SMS service provider (Twilio) once SMS message is being received.
From	Varchar (50)		From mobile (cell) phone number.
To	Varchar (50)		To mobile (cell) phone number.
Text	Nvarchar (160)		Message text
Processed_On	Datetime		Service provider acceptance timestamp
Price	Float		SMS message cost price from service provider

See also