Table: SBT Message Log

Table: SBT Message Log

Holds a log of SBT messaging

Column Data Type Column Info Value Notes Other
idint(11)The id of the entity
customer_idint(11)ID for the customer
customer_phone_idint(11)associated customer phone id
loan_idint(11)The id of the associated loan account
loan_display_idchar(25)associated display id
phonechar(20)Phone number text was sent to
outboundtinyint(1)Whether or not was outbound1 - yes, 0 - no
inboundtinyint(1)Whether or not was inbound1 - yes, 0 - no
statusint(11)Status code of the entity
status_textvarchar(255)status text
timedatetimetime of message
typechar(20)Message type
templateint(11)report template
messagevarchar(1000)sms message
sbt_tx_ticketvarchar(255)sbt transaction ticket
deletedtinyint(1)Whether or not the entity was deleted1 - yes, 0 - no
lastUpdatedtimestampTimestamp of when the entity was last updated

< Back to List