Database – Billing Tool Entity (billing_tool_entity)
Description
The billing tool is used to create billing statements for loans. This entity holds the information for current and past billing tools used to create billing statements as PDFs.
Column | Data Type | Column Info | Value Notes |
id | INT(11) | The id of the entity | |
user_id | INT(11) | ID of the associated agent user | |
custom_billing_theme_id | INT(11) | ID of custom billing theme | |
default_billing_theme_id | INT(11) | ID of default billing theme | |
custom_text | VARCHAR(400) | Custom text to include | |
header_color | VARCHAR(50) | Color code for the header | |
pdf_output | VARCHAR(100) | Encoded options for PDF output | pdf.output.multiple, pdf.output.single |
query | TEXT | Query used to select entities to process | |
processed | TINYINT(1) | Whether or not the billing tool finished processing | 1 - yes, 0 - no |
file_name | VARCHAR(255) | Name of the outputed file | |
url | TEXT | The link to the generated file | |
current_period | TINYINT(1) | Whether or not to use current period or custom dates | 1 - yes, 0 - no |
custom_start_date | DATE | State date of range to pull for | |
custom_end_date | DATE | End date of range to pull for | |
extra_info | varchar(255) | Any extra information related to the record | Default: {} |
active | TINYINT(1) | Whether or not the entity is active | 1 - yes, 0 - no |
deleted | TINYINT(1) | Whether or not the entity was deleted | 1 - yes, 0 - no |
created | TIMESTAMP | Timestamp of when the entity was created | |
lastUpdated | TIMESTAMP | Timestamp of when the entity was last updated |