sbt_message_log - SBT Message Log

Holds a log of SBT messaging

Column

Data Type

Column Info

Value Notes

Other

id

int(11)

The id of the entity

customer_id

int(11)

ID for the customer

customer_phone_id

int(11)

associated customer phone id

loan_id

int(11)

The id of the associated loan account

loan_display_id

char(25)

associated display id

phone

char(20)

Phone number text was sent to

outbound

tinyint(1)

Whether or not was outbound

1 - yes, 0 - no

inbound

tinyint(1)

Whether or not was inbound

1 - yes, 0 - no

status

int(11)

Status code of the entity

status_text

varchar(255)

status text

time

datetime

time of message

type

char(20)

Message type

template

int(11)

report template

message

varchar(1000)

sms message

sbt_tx_ticket

varchar(255)

sbt transaction ticket

deleted

tinyint(1)

Whether or not the entity was deleted

1 - yes, 0 - no

lastUpdated

timestamp

Timestamp of when the entity was last updated


How did we do?


Powered by HelpDocs (opens in a new tab)