# invoice_list_items

<!-- Generated from apps/irrigation/dbt_redshift/models/client_data/sources.yml. Do not edit by hand — run `make generate-client-data-dictionary`. -->

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 |