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


How did we do?


Powered by HelpDocs (opens in a new tab)