Database – Billing Tool Entity (billing_tool_entity)
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 | Other |
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 | ||
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 |