Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
|
| company_id | int8 |
|
|
The foreign key to the company record. @example 1 |
| finance_sah_claim_id | int8 |
|
|
The foreign key to the SAH claim. @example 1 |
| membership_id | int8 |
|
|
The foreign key to the membership record. @example 1 |
| invoice_line_id | int8 |
|
|
The foreign key of the invoice line record. @example 1 |
| invoice_amount_cents | int4 |
|
|
The total invoice amount. @example 1500 |
| invoice_amount_currency | varchar |
|
|
The total invoice amount currency code. @example ‘AUD’ |
| payment_amount_cents | int4 |
|
|
The payment amount from the government. @example 1500 |
| payment_amount_currency | varchar |
|
|
The payment amount currency code. @example ‘AUD’ |
| client_contribution_amount_cents | int4 |
|
|
The client contribution amount. @example 1500 |
| client_contribution_amount_currency | varchar |
|
|
The client contribution amount currency code. @example ‘AUD’ |
| services_australia_id | varchar |
|
|
The Services Australia identifier of the payment item. @example 12345 |
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
| reviewed_at | timestamp |
|
|
The timestamp of when the payment statement item was reviewed and marked as ready to finalise. @example 2025-01-01T00:00:00Z |
| original_invoice_amount_cents | int4 |
|
|
The actual reported invoice amount as reported by Services Australia. @example 9999 |
| original_invoice_amount_currency | varchar |
|
|
The actual reported invoice amount currency as reported by Services Australia. @example AUD |
| original_client_contribution_amount_cents | int4 |
|
|
The actual reported client contribution amount as reported by Services Australia. @example 9999 |
| original_client_contribution_amount_currency | varchar |
|
|
The actual reported client contribution amount currency as reported by Services Australia. @example AUD |
| original_payment_amount_cents | int4 |
|
|
The actual reported payment amount as reported by Services Australia. @example 9999 |
| original_payment_amount_currency | varchar |
|
|
The actual reported payment amount currency as reported by Services Australia. @example AUD |
| adjustment_invoice_line_id | int8 |
|
|
The ID of adjustment invoice line that was created @example 1 |
| quantity | numeric |
|
|
The quantity specified on the claimed invoice item. @example 3 |
| unit_type | varchar |
|
|
The unit type specified on the claimed invoice item. @example Hours |
| delivery_date | date |
|
|
The delivery date specified on the claimed invoice item. @example 2025-12-01 |
| service_group_id | varchar |
|
|
The service group ID specified on the claimed invoice item. @example SERG-0002 |
| service_group_text | varchar |
|
|
The service group text specified on the claimed invoice item. @example Assistive Technology |
| service_type_id | varchar |
|
|
The service type ID specified on the claimed invoice item. @example SERT-0017 |
| service_type_text | varchar |
|
|
The service type text specified on the claimed invoice item. @example Equipment and Products |
| service_id | varchar |
|
|
The service ID specified on the claimed invoice item. @example SERV-0063 |
| service_text | varchar |
|
|
The service text specified on the claimed invoice item. @example Mobility products |
| created_at_in_company_tz | timestamp |
|
|
|
| updated_at_in_company_tz | timestamp |
|
|
|
| reviewed_at_in_company_tz | timestamp |
|
|
|
| company_timezone | varchar |
|
|
The company timezone. E.g. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| edge_finance_sah_payment_statement_items_pkey | Primary key | Asc | id |
| idx_71ec653da5544b0349b6f46a980690c0 | Performance | Asc | invoice_line_id |
| idx_91f5a8faa518bc7e95a4cdfb1fd2c291 | Performance | Asc | adjustment_invoice_line_id |
| idx_94b8d9dc3e567c11b84a4b095cd708d3 | Performance | Asc | services_australia_id |
| idx_b658a6ef4cdad1a9e552a446acb0c476 | Performance | Asc | finance_sah_claim_id |
| idx_edge_finance_sah_payment_statement_items_company_id | Performance | Asc | company_id |
| idx_edge_finance_sah_payment_statement_items_membership_id | Performance | Asc | membership_id |
| idx_edge_finance_sah_payment_statement_items_service_id | Performance | Asc | service_id |
| idx_f388f99dd9ce56ae711f2b4b42967a1a | Performance | Asc | service_group_id |
| idx_feb1b75c4fc1f956fe538fda2d25b18b | Performance | Asc | service_type_id |