Columns
| Column | Type | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|
| transaction_id | int8 |
|
|
The unique transaction ID. E.g. 123. |
|||
| membership_id | int8 |
|
|
The ID of the membership associated with the transaction. E.g. 2410. |
|||
| label | text |
|
|
The type of transaction. E.g. “Credit Note”, “Deposit”, “Invoice”, and “Withdrawal”. |
|||
| reporting_category | text |
|
|
For reporting of member spending or reimbursements. Inferred from the label and the invoice item source type(s). E.g. “Third Party Orders”, “Visit Fees”, “Visit Reimbursements”, “Membership Fees”, “Membership Reimbursements”, “Reimbursements”, “Ad-hoc Invoices”, “Package Management”, “Opening Balance”, “Income Tested Fee Contribution”, “Government Subsidies and Supplements.” |
|||
| amount | numeric |
|
|
The total transaction amount, excluding tax. Invoice amounts are negative, and credit note amounts are positive. E.g. -89.50, 91.00. |
|||
| amount_currency | varchar |
|
|
The total transaction amount currency, e.g. "AUD, “NZD”. |
|||
| opening_balance | numeric |
|
|
The opening balance. E.g. 0.00. |
|||
| opening_balance_currency | varchar |
|
|
The opening balance currency, e.g. “AUD”, “NZD”. |
|||
| closing_balance | numeric |
|
|
The closing balance. E.g. -89.50. |
|||
| closing_balance_currency | varchar |
|
|
The closing balance currency, e.g. “AUD”, “NZD”. |
|||
| account_type | text |
|
|
The account type. E.g. “ProviderHeldCommonwealthFundsAccount”, “IncomeTestedFeeAccount”, “ClientContributionAccount”, “CareAndServicesAccount”, and “HomeCareAccount”. |
|||
| previous_transaction_id | int8 |
|
|
The ID of the previous transaction, e.g. 117. |
|||
| created_at | timestamp |
|
|
The date and time created (in UTC). E.g. 2021-03-02 00:12:59.996101. |
|||
| created_at_company_tz | timestamp |
|
|
||||
| created_by_profile_id | int8 |
|
|
The profile ID of the person who created the transaction (can be null). E.g. 8239. |
|||
| source_type | varchar |
|
|
The source of the transaction. E.g. “Invoice”, “Finance::HCPClaim”, “FinanceImport”, null. |
|||
| source_id | int8 |
|
|
The ID of the entity in source_type. E.g. 2576. |
|||
| invoice_category | text |
|
|
The type of invoice. E.g. “Invoice”, “Credit Note”, null. See also label. |
|||
| invoice_item_labels | text |
|
|
A string aggregation of labels on the associated invoice item. E.g. |
|||
| invoice_is_adhoc | bool |
|
|
Whether the invoice is an ad-hoc invoice. E.g. true, false, null. See also reporting_category. |
|||
| invoice_source_type | varchar |
|
|
The source of the invoice if it is not a billing run or ad-hoc invoice. E.g. “Invoice”, “FinanceImport”, “SupplierGeneratedInvoice”, null. |
|||
| invoice_source_id | int8 |
|
|
The ID of the entity in invoice_source_type. E.g. 2635. |
|||
| invoice_gross_amount | numeric |
|
|
The total of all line items, including tax. E.g. 10.00. |
|||
| invoice_net_amount | numeric |
|
|
The total of all line items excluding tax. This is also the transaction amount. E.g. 9.09. |
|||
| invoice_item_count | int8 |
|
|
The number of line items in the invoice. It can be zero. E.g. 6. |
|||
| finance_account_id | int8 |
|
|
The account ID. E.g. 9483. |
|||
| company_id | int8 |
|
|
The company ID. E.g. 345. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| fct_finance_transactions_pkey | Primary key | Asc | transaction_id |
| fct_finance_transactions_company_id_idx | Performance | Asc | company_id |