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 |
| details | json |
|
|
Additional data returned as part of the payment response. @example ’{“delivery_date”: “2025-07-01”} |
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
| created_at_in_company_tz | timestamp |
|
|
|
| updated_at_in_company_tz | timestamp |
|
|
|
| company_timezone | varchar |
|
|
The company timezone. E.g. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| 6af2a7488a2ddee6ee3544e932f43bd7 | Performance | Asc | invoice_line_id |
| b3f500afcc6426f9c318e724472e306a | Performance | Asc | company_id |
| b5276642416bf0d621903c7f07f4b8b0 | Performance | Asc | membership_id |
| d7b75d10d869d30f29999d7dd5313eed | Performance | Asc | services_australia_id |
| f7c4f1688d1fd677e49f4ef527e4f408 | Performance | Asc | finance_sah_claim_id |