Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
|
| invoice_id | int8 |
|
|
|
| source_type | varchar |
|
|
|
| source_id | int8 |
|
|
|
| price_cents | int4 |
|
|
The price per unit in cents. @example: 6250 |
| price_currency | varchar |
|
|
The currency of the price. @example: ‘AUD’ |
| quantity | numeric |
|
|
The number of units the invoice is for. @example: 2 |
| description | varchar |
|
|
|
| item_code | varchar |
|
|
|
| account_code | varchar |
|
|
|
| tax_rate | numeric |
|
|
The tax rate. @example: 0.1 |
| gross_amount_cents | int4 |
|
|
The amount in cents, gross. @example: 12500 |
| gross_amount_currency | varchar |
|
|
The currency of the gross amount. @example: ‘AUD’ |
| tax_amount_cents | int4 |
|
|
The tax portion of the amount in cents gross. @example: 6250 |
| tax_amount_currency | varchar |
|
|
The currency of the tax amount. @example: ‘AUD’ |
| extended_description | text |
|
|
|
| tax_id | int8 |
|
|
The foreign key for the associated tax. @example: 1 |
| label | varchar |
|
|
|
| unit_type | varchar |
|
|
|
| company_id | int8 |
|
|
The owning tenant’s ID. @example 1. |
| rate_id | int8 |
|
|
The foreign key for the associated rate. @example 123 |
| client_contribution_amount_cents | int4 |
|
|
The client contribution amount for the line in cents for applicable service lines only. @example 1500 |
| client_contribution_amount_currency | varchar |
|
|
The client contribution amount currency code. @example ‘AUD’ |
| external_id | varchar |
|
|
The optional external ID associated with this invoice line, which may refer to a government service code. @example ‘SERV-0001’ |
| sah_claim_id | int8 |
|
|
The related SaH claim’s ID. @example 1. |
| transacted_at | timestamp |
|
|
The time at which the invoice line was transacted. @example: 2025-01-01 00:00:00.000000 |
| paid_externally | bool |
|
|
A flag to specify whether the invoice line was paid before being imported to Lookout. @example true |
| sah_funding_source | varchar |
|
|
The code for the funding source to be used for S @example ‘ON’ |
| skip_claims | bool |
|
|
Whether the invoice line should be excluded from all claims. @example ‘false’ |
| transacted_at_in_company_tz | timestamp |
|
|
|
| company_timezone | varchar |
|
|
The company timezone. E.g. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| edge_invoice_lines_pkey | Primary key | Asc | id |
| idx_edge_invoice_lines_company_id | Performance | Asc | company_id |
| idx_edge_invoice_lines_external_id | Performance | Asc | external_id |
| idx_edge_invoice_lines_invoice_id | Performance | Asc | invoice_id |
| idx_edge_invoice_lines_rate_id | Performance | Asc | rate_id |
| idx_edge_invoice_lines_sah_claim_id | Performance | Asc | sah_claim_id |
| idx_edge_invoice_lines_source_id | Performance | Asc | source_id |
| idx_edge_invoice_lines_tax_id | Performance | Asc | tax_id |