invoice_list_items
Invoice master records with line items, allocations, and recipient details.
| Column | Description |
|---|---|
id |
Unique identifier for the invoice item |
workspace_uuid |
A UUID for the workspace this invoice belongs to |
invoice_uuid |
UUID of the invoice |
status |
‘issued’: invoice has been issued. ‘draft’: is a draft invoice. ‘credited’: the invoice has been credited |
invoice_type |
Human-readable invoice type |
invoice_number |
The integer value number for this invoice, relates to display_invoice_number |
payment_status |
Empty, not used yet |
recipient_name |
The name of the person the invoice is for |
currency |
The currency for this invoice |
issue_date |
Date of issue |
due_date |
When this invoice is due for payment |
payment_date |
Date payment was taken |
created_at |
The UTC date, including time, when this was created |
updated_at |
The UTC date, including time, when this row was updated |
billing_period_from |
The start date for the billing period |
billing_period_to |
The end date for the billing period |
recipient_email |
The email address for the person the invoice is for |
indexed_line_items |
A comma-separated list of the titles for the line items in the invoice |
total_value_cents |
Full number of the invoice item (no decimals, so $100.00 = 10000) |
booking_channel |
The channel for the booking |
building |
Name of the building |
unit |
The name of the unit |
unit_type |
The name of the unit type |
display_invoice_number |
Empty if no invoice number, if set this is the invoice number |
booking_id |
The ID of the booking |
guest_name |
The name of the guest |
requires_action |
If true the invoice requires action |
offer_unique_reference |
For downpayments, comes from the booking context table and the offer table |
invoice_kind |
Software-readable invoice type: regular_corrective_invoice, damages_invoice, downpayment_credit_note, regular_credit_note, refund_note, receipt, downpayment_invoice, downpayment_receipt, regular_invoice, deposit_receipt |
billing_period_id |
The ID of the billing period |
line_items |
A JSON array representing the line items for this invoice |
allocations |
A JSON object with linked transaction allocations; empty if no allocations |
invoice_list_items |
Always 0 |
balance_cents |
The balance in cents after allocations |
recipient_contact_reference |
The contact reference for the person the invoice is for |
analysis_report |
A JSON object with the analysis report for this invoice |
referenced_invoices |
A JSON object with referenced invoice details; empty if no references |
timestamp |
Date when the table was last synchronized |