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 |
|
|
|
| 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) |
|---|---|---|---|
| 664868b3c44abe835adb7de8c200bd8e | Performance | Asc | invoice_line_id |
| 8eaed02297dc7fe647f95b1c7be85903 | Performance | Asc | company_id |
| daef5b73305cd1a19d2082996ad34641 | Performance | Asc | membership_id |
| db1f8be22b66d21d82ff57c083ae287b | Performance | Asc | finance_sah_claim_id |
| fbaf4f04baa1df0d1cf8122af6281516 | Performance | Asc | services_australia_id |