Database - Mail House Loan (mail_house_loan)
Updated 2 weeks ago
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 |