v_invoice_line_item: One-to-Many (1:N)
One invoice can have many line items
Referenced through invoice_id
v_invoice_payment: One-to-Many (1:N)
One invoice can have many payments
Referenced through invoice_id
v_occupancy: Many-to-One (N:1)
Many invoices link to one location
Referenced through address_id
Column | Type | Description |
id | integer | Primary key |
address_id | integer | Address reference |
address | text | Billing address |
client_code | varchar(28) | Organization ID |
invoice_category_name | varchar(255) | Category name |
category_type_name | varchar(255) | Type name |
invoice_number | varchar(30) | Invoice number |
emailed_at | timestamp | Email time |
mailed_at | timestamp | Mail time |
status_name | text | Status name |
money_status_code | varchar(14) | Payment status |
other_status_code | varchar(14) | Other status |
created_at | timestamp | Creation time |
due_date | date | Due date |
total | numeric | Invoice total |
total_discount | numeric | Discount amount |
total_payment | numeric | Payment total |
balance | numeric | Balance due |
preplan_business_name | varchar(128) | Business name |
vendor_phone | varchar(50) | Vendor phone |
write_off_reason | varchar(255) | Write-off reason |
write_off_approved_by | varchar(255) | Write-off approver |
write_off | numeric | Write-off amount |