Database - Mail House Loan (mail_house_loan)

Description

This table holds core mail house loan data, including IDs of associated entities and modification information. This is for the mail house tool.

Table Fields

Field

Data Type

Column Info

Value Notes

id

bigint(20)

The ID of the mail piece.

loan_id

int(11)

This is the ID of the loan.

loan_type

varchar(100)

The loan type

Default is set to: Entity.Loan

mail_house_tool_id

int(11)

This is the mail house tool ID.

letter_id

varchar(40)

This is the ID of the letter.

customer_id

int(11)

This is the ID of the customer.

template_id

int(11)

This is the ID of the template.

source_service

varchar(40)

The service that prompted the mail.

to_address

text

This is where the mail is being sent to.

status

varchar(50)

The status of the mail.

error_reason

varchar(4000)

The reason for the error.

loan_display_id

char(50)

This is the loan display ID.

template_name

varchar(100)

The name of the template.

author

varchar(200)

This is the author of the mail.

lastUpdated

timestamp

When the mail was last updated.

created

datetime

The date of when the mail was created.

deleted

tinyint(1)

Whether the mail has been deleted.

1 - yes, 0 - no


How did we do?


Powered by HelpDocs (opens in a new tab)