Columns
| Column | Type | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|
| invoice_item_id | int8 |
|
|
The unique invoice item ID, e.g. 83571. |
|||
| source_type | varchar |
|
|
The source of the line item. E.g. “Membership” (fees, etc), “PurchaseOrderLine”, “Visit”, null. |
|||
| source_id | int8 |
|
|
The ID of the record specified by the source_type. E.g. 6294. |
|||
| price_cents | int4 |
|
|
||||
| label | text |
|
|
The type of fee associated with the item. E.g. "Care Management Fee”, "Client Transport Fee”, "Client Transport Platform Fee”, "Lookout Fee”, "Membership Fee”, “Package Management Fee”, “Platform Fee”, “Provider Travel Distance Fee”, “Provider Travel Distance Platform Fee”, “Provider Travel Time Fee”, “Provider Travel Time Platform Fee”, “Third Party Invoice”, “Visit Fee”, null. |
|||
| price | numeric |
|
|
The unit price. E.g. 9.99. |
|||
| price_currency | varchar |
|
|
The unit price currency. E.g. “AUD”, “NZD”. |
|||
| quantity | numeric |
|
|
The number of units. E.g. 1. |
|||
| unit_type | varchar |
|
|
Unit type for the invoice line item. E.g. “cost”, “item”, “hours”.’ |
|||
| item_code | varchar |
|
|
A code or reference for the product or service (specified by the user). E.g. “PSI0010531”. |
|||
| account_code | varchar |
|
|
The account code (optional). E.g. “CHA”, “83200”, null. |
|||
| tax_rate | numeric |
|
|
The tax rate. E.g. 0.0, 0.1, 0.15, etc. |
|||
| gross_amount_cents | int4 |
|
|
||||
| gross_amount | numeric |
|
|
The total amount, including tax. E.g. 58.32. |
|||
| gross_amount_currency | varchar |
|
|
The gross amount currency. E.g. “AUD”, “NZD”. |
|||
| tax_amount | numeric |
|
|
The tax amount. E.g. 5.30. |
|||
| tax_amount_currency | varchar |
|
|
The tax amount currency. E.g. “AUD”, “NZD”. |
|||
| net_amount | numeric |
|
|
The net amount (not including tax). E.g. 53.02. |
|||
| invoice_id | int8 |
|
|
The ID of the invoice. E.g. 52987. |
|||
| invoice_state | text |
|
|
See fct_invoices state. |
|||
| invoice_source_type | varchar |
|
|
See fct_invoices source_type. |
|||
| invoice_source_id | int8 |
|
|
See fct_invoices source_id. |
|||
| issuer_profile_id | int8 |
|
|
See fct_invoices issuer_profile_id. |
|||
| recipient_profile_id | int8 |
|
|
See fct_invoices recipient_profile_id. |
|||
| category | text |
|
|
See fct_invoices category. |
|||
| is_adhoc | bool |
|
|
See fct_invoices is_adhoc. |
|||
| billing_run_id | int8 |
|
|
See fct_invoices billing_run_id. |
|||
| transacted_at | timestamp |
|
|
See fct_invoices transacted_at. |
|||
| published_at | timestamp |
|
|
See fct_invoices published_at. |
|||
| issued_at | timestamp |
|
|
See fct_invoices issued_at. |
|||
| issued_at_company_tz | timestamp |
|
|
||||
| company_id | int8 |
|
|
The company ID. E.g. 345. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| fct_invoice_items_pkey | Primary key | Asc | invoice_item_id |
| fct_invoice_items_company_id_idx | Performance | Asc | company_id |
| fct_invoice_items_invoice_id_idx | Performance | Asc | invoice_id |