# Xero schema ERD

Table and field reference for the Fivetran Xero connector.

## Table & Field Reference

### expense_claim

| Column | Type | Keys |
| --- | --- | --- |
| expense_claim_id | String | PK |
| user_id | String | FK |
| amount_due | BigDecimal |  |
| amount_paid | BigDecimal |  |
| payment_due_date | LocalDate |  |
| reporting_date | LocalDate |  |
| status | String |  |
| total | BigDecimal |  |
| updated_date_utc | Instant |  |

### journal_line_has_tracking_category

| Column | Type | Keys |
| --- | --- | --- |
| journal_id | String | PK, FK |
| journal_line_id | String | PK, FK |
| tracking_category_id | String | PK, FK |
| tracking_category_option_id | String | FK |
| option | String |  |

### overpayment

| Column | Type | Keys |
| --- | --- | --- |
| overpayment_id | String | PK |
| applied_amount | BigDecimal |  |
| contact_id | String |  |
| currency_code | String |  |
| currency_rate | BigDecimal |  |
| date | LocalDate |  |
| fully_paid_on_date | Instant |  |
| has_attachments | Boolean |  |
| line_amount_types | String |  |
| reference | String |  |
| remaining_credit | BigDecimal |  |
| status | String |  |
| sub_total | BigDecimal |  |
| total | BigDecimal |  |
| total_tax | BigDecimal |  |
| type | String |  |
| updated_date_utc | Instant |  |

### tax_rate

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| can_apply_to_assets | Boolean |  |
| can_apply_to_equity | Boolean |  |
| can_apply_to_expenses | Boolean |  |
| can_apply_to_liabilities | Boolean |  |
| can_apply_to_revenue | Boolean |  |
| display_tax_rate | BigDecimal |  |
| effective_rate | BigDecimal |  |
| name | String |  |
| report_tax_type | String |  |
| status | String |  |
| tax_type | String |  |

### user

| Column | Type | Keys |
| --- | --- | --- |
| user_id | String | PK |
| email_address | String |  |
| first_name | String |  |
| is_subscriber | Boolean |  |
| last_name | String |  |
| organisation_role | String |  |
| updated_date_utc | Instant |  |

### asset_type

| Column | Type | Keys |
| --- | --- | --- |
| asset_type_id | String | PK |
| accumulated_depreciation_account_id | String |  |
| asset_type_name | String |  |
| depreciation_expense_account_id | String |  |
| fixed_asset_account_id | String |  |
| lock_private_use_account | Boolean |  |
| locks | Int |  |
| depreciation_** |  |  |

### repeating_invoice

| Column | Type | Keys |
| --- | --- | --- |
| repeating_invoice_id | String | PK |
| branding_theme_id | String | FK |
| contact_id | String | FK |
| currency_code | String |  |
| has_attachments | Boolean |  |
| id | String |  |
| line_amount_types | String |  |
| reference | String |  |
| status | String |  |
| sub_total | BigDecimal |  |
| total | BigDecimal |  |
| total_discount | BigDecimal |  |
| total_tax | BigDecimal |  |
| type | String |  |
| schedule_** |  |  |

### prepayment_line_item

| Column | Type | Keys |
| --- | --- | --- |
| line_item_id | String | PK |
| prepayment_id | String | PK, FK |
| account_code | String |  |
| account_id | String |  |
| description | String |  |
| discount_entered_as_percent | Boolean |  |
| item_code | String |  |
| line_amount | BigDecimal |  |
| quantity | BigDecimal |  |
| tax_amount | BigDecimal |  |
| tax_type | String |  |
| unit_amount | BigDecimal |  |
| validation_errors | Json |  |

### repeating_invoice_line_item_has_tracking_category

| Column | Type | Keys |
| --- | --- | --- |
| line_item_id | String | PK, FK |
| repeating_invoice_id | String | PK, FK |
| tracking_category_id | String | PK, FK |
| option | String |  |

### branding_theme

| Column | Type | Keys |
| --- | --- | --- |
| branding_theme_id | String | PK |
| created_date_utc | Instant |  |
| name | String |  |
| sort_order | Int |  |

### organization

| Column | Type | Keys |
| --- | --- | --- |
| organisation_id | String | PK |
| apikey | String |  |
| base_currency | String |  |
| class | String |  |
| country_code | String |  |
| created_date_utc | Instant |  |
| default_purchases_tax | String |  |
| default_sales_tax | String |  |
| edition | String |  |
| employer_identification_number | String |  |
| end_of_year_lock_date | LocalDate |  |
| financial_year_end_day | Int |  |
| financial_year_end_month | Int |  |
| is_demo_company | Boolean |  |
| legal_name | String |  |
| line_of_business | String |  |
| name | String |  |
| organisation_entity_type | String |  |
| organisation_status | String |  |
| organisation_type | String |  |
| pays_tax | Boolean |  |
| period_lock_date | LocalDate |  |
| registration_number | String |  |
| sales_tax_basis | String |  |
| sales_tax_period | String |  |
| short_code | String |  |
| tax_number | String |  |
| tax_number_name | String |  |
| timezone | String |  |
| version | String |  |

### bank_transaction

| Column | Type | Keys |
| --- | --- | --- |
| bank_transaction_id | String | PK |
| bank_account_id | String | FK |
| contact_id | String | FK |
| overpayment_id | String | FK |
| prepayment_id | String | FK |
| currency_code | String |  |
| currency_rate | BigDecimal |  |
| date | LocalDate |  |
| external_link_provider_name | String |  |
| has_attachments | Boolean |  |
| is_reconciled | Boolean |  |
| line_amount_types | String |  |
| reference | String |  |
| status | String |  |
| sub_total | BigDecimal |  |
| total | BigDecimal |  |
| total_tax | BigDecimal |  |
| type | String |  |
| updated_date_utc | Instant |  |
| url | String |  |
| batch_payment_** |  |  |

### overpayment_line_item_has_tracking_category

| Column | Type | Keys |
| --- | --- | --- |
| line_item_id | String | PK, FK |
| overpayment_id | String | PK, FK |
| tracking_category_id | String | PK, FK |
| tracking_category_option_id | String | FK |
| option | String |  |

### aus_payroll_leave_application

| Column | Type | Keys |
| --- | --- | --- |
| leave_application_id | String | PK |
| employee_id | String | FK |
| end_date | Instant |  |
| leave_type_id | String |  |
| start_date | Instant |  |
| title | String |  |
| updated_date_utc | Instant |  |

### aus_payroll_employee

| Column | Type | Keys |
| --- | --- | --- |
| employee_id | String | PK |
| date_of_birth | Instant |  |
| email | String |  |
| first_name | String |  |
| last_name | String |  |
| ordinary_earnings_rate_id | String |  |
| payroll_calendar_id | String |  |
| phone | String |  |
| start_date | Instant |  |
| status | String |  |
| updated_date_utc | Instant |  |

### settings

| Column | Type | Keys |
| --- | --- | --- |
| asset_number_sequence | String | PK |
| asset_number_prefix | String |  |
| asset_start_date | Instant |  |
| default_capital_gain_on_disposal_account_id | String |  |
| default_gain_on_disposal_account_id | String |  |
| default_loss_on_disposal_account_id | String |  |
| last_depreciation_date | Instant |  |
| opt_in_for_tax | Boolean |  |

### tax_rate_component

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| _fivetran_id | String | PK, FK |
| is_compound | Boolean |  |
| is_non_recoverable | Boolean |  |
| rate | BigDecimal |  |

### aus_payroll_leave_period

| Column | Type | Keys |
| --- | --- | --- |
| index_id | Long | PK |
| leave_application_id | String | PK, FK |
| leave_period_status | String |  |
| number_of_units | Double |  |
| pay_period_end_date | Instant |  |
| pay_period_start_date | Instant |  |

### journal_cash_line_has_tracking_category

| Column | Type | Keys |
| --- | --- | --- |
| journal_id | String | PK, FK |
| journal_line_id | String | PK, FK |
| tracking_category_id | String | PK, FK |
| tracking_category_option_id | String | FK |
| option | String |  |

### budget_balance

| Column | Type | Keys |
| --- | --- | --- |
| period | String | PK |
| budget_id | String | PK, FK |
| budget_line_index | Int | PK, FK |
| amount | BigDecimal |  |
| notes | String |  |
| unit_amount | BigDecimal |  |

### invoice_line_item_has_tracking_category

| Column | Type | Keys |
| --- | --- | --- |
| invoice_id | String | PK, FK |
| line_item_id | String | PK, FK |
| tracking_category_id | String | PK, FK |
| tracking_category_option_id | String | FK |
| option | String |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| account_id | String | PK |
| add_to_watchlist | Boolean |  |
| bank_account_number | String |  |
| bank_account_type | String |  |
| class | String |  |
| code | String |  |
| currency_code | String |  |
| description | String |  |
| enable_payments_to_account | Boolean |  |
| has_attachments | Boolean |  |
| name | String |  |
| reporting_code | String |  |
| reporting_code_name | String |  |
| reporting_code_updated_utc | Instant |  |
| show_in_expense_claims | Boolean |  |
| status | String |  |
| system_account | String |  |
| tax_type | String |  |
| type | String |  |
| updated_date_utc | Instant |  |

### currency

| Column | Type | Keys |
| --- | --- | --- |
| code | String | PK |
| description | String |  |

### purchase_order

| Column | Type | Keys |
| --- | --- | --- |
| purchase_order_id | String | PK |
| branding_theme_id | String | FK |
| contact_id | String | FK |
| attention_to | String |  |
| currency_code | String |  |
| currency_rate | Double |  |
| date | Instant |  |
| delivery_address | String |  |
| delivery_date | Instant |  |
| delivery_instructions | String |  |
| is_discounted | Boolean |  |
| line_amount_types | String |  |
| purchase_order_number | String |  |
| reference | String |  |
| status | String |  |
| sub_total | Double |  |
| telephone | String |  |
| total | Double |  |
| total_tax | Double |  |
| type | String |  |
| updated_date_utc | Instant |  |

### bank_transfer

| Column | Type | Keys |
| --- | --- | --- |
| bank_transfer_id | String | PK |
| from_bank_account_id | String | FK |
| from_bank_transaction_id | String | FK |
| to_bank_account_id | String | FK |
| to_bank_transaction_id | String | FK |
| amount | BigDecimal |  |
| created_date_utc | Instant |  |
| created_date_utcstring | Instant |  |
| currency_rate | BigDecimal |  |
| date | LocalDate |  |
| has_attachments | Boolean |  |

### journal_cash

| Column | Type | Keys |
| --- | --- | --- |
| journal_id | String | PK |
| created_date_utc | Instant |  |
| journal_date | LocalDate |  |
| journal_number | Int |  |
| reference | String |  |
| source_id | String |  |
| source_type | String |  |

### receipt_line_item_has_tracking_category

| Column | Type | Keys |
| --- | --- | --- |
| line | Int | PK, FK |
| receipt_id | String | PK, FK |
| tracking_category_id | String | PK, FK |
| tracking_category_option_id | String | FK |
| option | String |  |

### overpayment_line_item

| Column | Type | Keys |
| --- | --- | --- |
| line_item_id | String | PK |
| overpayment_id | String | PK, FK |
| account_code | String |  |
| account_id | String |  |
| description | String |  |
| discount_entered_as_percent | Boolean |  |
| item_code | String |  |
| line_amount | BigDecimal |  |
| quantity | BigDecimal |  |
| tax_amount | BigDecimal |  |
| tax_type | String |  |
| unit_amount | BigDecimal |  |
| validation_errors | Json |  |

### invoice

| Column | Type | Keys |
| --- | --- | --- |
| invoice_id | String | PK |
| branding_theme_id | String | FK |
| contact_id | String | FK |
| repeating_invoice_id | String | FK |
| amount_credited | BigDecimal |  |
| amount_due | BigDecimal |  |
| amount_paid | BigDecimal |  |
| cisdeduction | BigDecimal |  |
| currency_code | String |  |
| currency_rate | BigDecimal |  |
| date | LocalDate |  |
| due_date | LocalDate |  |
| expected_payment_date | Instant |  |
| fully_paid_on_date | LocalDate |  |
| has_attachments | Boolean |  |
| has_errors | Boolean |  |
| invoice_number | String |  |
| is_discounted | Boolean |  |
| line_amount_types | String |  |
| planned_payment_date | Instant |  |
| reference | String |  |
| sent_to_contact | Boolean |  |
| status | String |  |
| sub_total | BigDecimal |  |
| total | BigDecimal |  |
| total_tax | BigDecimal |  |
| type | String |  |
| updated_date_utc | Instant |  |
| url | String |  |

### journal_line

| Column | Type | Keys |
| --- | --- | --- |
| journal_line_id | String | PK |
| account_id | String | FK |
| journal_id | String | FK |
| account_code | String |  |
| account_name | String |  |
| account_type | String |  |
| description | String |  |
| gross_amount | BigDecimal |  |
| net_amount | BigDecimal |  |
| tax_amount | BigDecimal |  |
| tax_name | String |  |
| tax_type | String |  |

### budget

| Column | Type | Keys |
| --- | --- | --- |
| budget_id | String | PK |
| description | String |  |
| status | String |  |
| type | String |  |
| updated_date_utc | Instant |  |

### bank_transaction_line_items

| Column | Type | Keys |
| --- | --- | --- |
| line_item_id | String | PK |
| bank_transaction_id | String | PK, FK |
| account_code | String |  |
| account_id | String |  |
| description | String |  |
| item_code | String |  |
| line_amount | BigDecimal |  |
| quantity | BigDecimal |  |
| tax_amount | BigDecimal |  |
| tax_type | String |  |
| unit_amount | BigDecimal |  |

### asset

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| asset_type_id | String | FK |
| accounting_book_value | BigDecimal |  |
| asset_name | String |  |
| asset_number | String |  |
| asset_status | String |  |
| can_rollback | Boolean |  |
| current_accum_depreciation_amount | BigDecimal |  |
| description | String |  |
| disposal_date | Instant |  |
| disposal_price | BigDecimal |  |
| is_delete_enabled_for_date | Boolean |  |
| prior_accum_depreciation_amount | BigDecimal |  |
| purchase_date | Instant |  |
| purchase_price | BigDecimal |  |
| serial_number | String |  |
| warranty_expiry_date | Instant |  |
| depreciation_** |  |  |

### receipt_line_item

| Column | Type | Keys |
| --- | --- | --- |
| line | Int | PK |
| receipt_id | String | PK, FK |
| account_code | String |  |
| account_id | String |  |
| description | String |  |
| discount_entered_as_percent | Boolean |  |
| discount_rate | BigDecimal |  |
| line_amount | BigDecimal |  |
| quantity | BigDecimal |  |
| tax_amount | BigDecimal |  |
| tax_type | String |  |
| unit_amount | BigDecimal |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| contact_id | String | PK |
| branding_theme_id | String | FK |
| account_number | String |  |
| accounts_payable_tax_type | String |  |
| accounts_receivable_tax_type | String |  |
| balances_accounts_payable_outstanding | BigDecimal |  |
| balances_accounts_payable_overdue | BigDecimal |  |
| balances_accounts_receivable_outstanding | BigDecimal |  |
| balances_accounts_receivable_overdue | BigDecimal |  |
| bank_account_details | String |  |
| contact_number | String |  |
| contact_status | String |  |
| default_currency | String |  |
| discount | Int |  |
| email_address | String |  |
| first_name | String |  |
| has_attachments | Boolean |  |
| has_validation_errors | Boolean |  |
| is_customer | Boolean |  |
| is_supplier | Boolean |  |
| last_name | String |  |
| merged_to_contact_id | String |  |
| name | String |  |
| purchases_default_account_code | String |  |
| sales_default_account_code | String |  |
| skype_user_name | String |  |
| tax_number | String |  |
| updated_date_utc | Instant |  |
| website | String |  |
| xero_network_key | String |  |
| batch_payments_** |  |  |

### aus_payroll_timesheet

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| employee_id | String | FK |
| end_date | Instant |  |
| hours | Double |  |
| start_date | Instant |  |
| status | String |  |
| updated_date_utc | Instant |  |

### payment

| Column | Type | Keys |
| --- | --- | --- |
| payment_id | String | PK |
| account_id | String | FK |
| credit_note_id | String | FK |
| expense_claim_id | String | FK |
| invoice_id | String | FK |
| overpayment_id | String | FK |
| prepayment_id | String | FK |
| amount | BigDecimal |  |
| bank_amount | BigDecimal |  |
| currency_rate | BigDecimal |  |
| date | LocalDate |  |
| has_account | Boolean |  |
| has_validation_errors | Boolean |  |
| is_reconciled | Boolean |  |
| payment_type | String |  |
| reference | String |  |
| status | String |  |
| updated_date_utc | Instant |  |
| batch_payment_** |  |  |

### tracking_category_has_option

| Column | Type | Keys |
| --- | --- | --- |
| tracking_category_id | String | PK, FK |
| tracking_option_id | String | PK, FK |

### prepayment

| Column | Type | Keys |
| --- | --- | --- |
| prepayment_id | String | PK |
| applied_amount | BigDecimal |  |
| contact_id | String |  |
| currency_code | String |  |
| currency_rate | BigDecimal |  |
| date | LocalDate |  |
| fully_paid_on_date | Instant |  |
| has_attachments | Boolean |  |
| line_amount_types | String |  |
| reference | String |  |
| remaining_credit | BigDecimal |  |
| status | String |  |
| sub_total | BigDecimal |  |
| total | BigDecimal |  |
| total_tax | BigDecimal |  |
| type | String |  |
| updated_date_utc | Instant |  |

### employee

| Column | Type | Keys |
| --- | --- | --- |
| employee_id | String | PK |
| first_name | String |  |
| last_name | String |  |
| status | String |  |
| updated_date_utc | Instant |  |

### credit_note_line_item_has_tracking_category

| Column | Type | Keys |
| --- | --- | --- |
| line_itemindex | Int | PK |
| credit_note_id | String | PK, FK |
| tracking_category_id | String | PK, FK |
| tracking_category_option_id | String | FK |
| option | String |  |

### journal

| Column | Type | Keys |
| --- | --- | --- |
| journal_id | String | PK |
| created_date_utc | Instant |  |
| journal_date | LocalDate |  |
| journal_number | Int |  |
| reference | String |  |
| source_id | String |  |
| source_type | String |  |

### prepayment_line_item_has_tracking_category

| Column | Type | Keys |
| --- | --- | --- |
| line_item_id | String | PK, FK |
| pre_payment_id | String | PK, FK |
| tracking_category_id | String | PK, FK |
| option | String |  |

### invoice_linked_transactions

| Column | Type | Keys |
| --- | --- | --- |
| linked_transaction_id | String | PK |
| contact_id | String | FK |
| invoice_id | String | FK |
| invoice_line_item_id | String | FK |
| source_transaction_type_code | String |  |
| status | String |  |
| type | String |  |
| updated_date_utc | String |  |

### contact_address

| Column | Type | Keys |
| --- | --- | --- |
| _index | Int | PK |
| contact_id | String | PK, FK |
| address_line_1 | String |  |
| address_line_2 | String |  |
| address_line_3 | String |  |
| address_line_4 | String |  |
| address_type | String |  |
| attention_to | String |  |
| city | String |  |
| country | String |  |
| postal_code | String |  |
| region | String |  |

### repeating_invoice_line_item

| Column | Type | Keys |
| --- | --- | --- |
| line_item_id | String | PK |
| repeating_invoice_id | String | PK, FK |
| account_code | String |  |
| account_id | String |  |
| description | String |  |
| discount_entered_as_percent | Boolean |  |
| discount_rate | BigDecimal |  |
| item_code | String |  |
| line_amount | BigDecimal |  |
| quantity | BigDecimal |  |
| tax_amount | BigDecimal |  |
| tax_type | String |  |
| unit_amount | BigDecimal |  |
| validation_errors | Json |  |

### item

| Column | Type | Keys |
| --- | --- | --- |
| item_id | String | PK |
| code | String |  |
| description | String |  |
| inventory_asset_account_code | String |  |
| is_purchased | Boolean |  |
| is_sold | Boolean |  |
| is_tracked_as_inventory | Boolean |  |
| name | String |  |
| purchase_description | String |  |
| quantity_on_hand | BigDecimal |  |
| total_cost_pool | BigDecimal |  |
| updated_date_utc | Instant |  |
| purchase_details_** |  |  |
| sales_details_** |  |  |

### invoice_line_item

| Column | Type | Keys |
| --- | --- | --- |
| line_item_id | String | PK |
| invoice_id | String | PK, FK |
| item_id | String | FK |
| account_code | String |  |
| account_id | String |  |
| description | String |  |
| discount_entered_as_percent | Boolean |  |
| discount_rate | Int |  |
| item_code | String |  |
| line_amount | BigDecimal |  |
| quantity | BigDecimal |  |
| tax_amount | BigDecimal |  |
| tax_type | String |  |
| unit_amount | BigDecimal |  |
| validation_errors | Json |  |

### tracking_category

| Column | Type | Keys |
| --- | --- | --- |
| tracking_category_id | String | PK |
| name | String |  |
| status | String |  |

### contact_group

| Column | Type | Keys |
| --- | --- | --- |
| contact_group_id | String | PK |
| has_validation_errors | Boolean |  |
| name | String |  |
| status | String |  |

### credit_note_line_item

| Column | Type | Keys |
| --- | --- | --- |
| line_index | Int | PK |
| credit_note_id | String | PK, FK |
| account_code | String |  |
| account_id | String |  |
| description | String |  |
| discount_entered_as_percent | Boolean |  |
| item_code | String |  |
| line_amount | BigDecimal |  |
| quantity | BigDecimal |  |
| tax_amount | BigDecimal |  |
| tax_type | String |  |
| unit_amount | BigDecimal |  |
| validation_errors | Json |  |

### budget_line

| Column | Type | Keys |
| --- | --- | --- |
| _index | Int | PK |
| budget_id | String | PK, FK |
| account_id | String | FK |
| account_code | String |  |

### contact_group_member

| Column | Type | Keys |
| --- | --- | --- |
| contact_group_id | String | PK, FK |
| contact_id | String | PK, FK |

### bank_linked_transactions

| Column | Type | Keys |
| --- | --- | --- |
| linked_transaction_id | String | PK |
| contact_id | String | FK |
| source_line_item_id | String | FK |
| source_transaction_id | String | FK |
| target_line_item_id | String | FK |
| target_transaction_id | String | FK |
| source_transaction_type_code | String |  |
| status | String |  |
| type | String |  |
| updated_date_utc | String |  |

### tracking_category_option

| Column | Type | Keys |
| --- | --- | --- |
| tracking_option_id | String | PK |
| has_validation_errors | Boolean |  |
| is_active | Boolean |  |
| is_archived | Boolean |  |
| is_deleted | Boolean |  |
| name | String |  |
| status | String |  |

### contact_phone

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| contact_id | String | PK, FK |
| phone_area_code | String |  |
| phone_country_code | String |  |
| phone_number | String |  |
| phone_type | String |  |

### purchase_order_line_item_has_tracking_category

| Column | Type | Keys |
| --- | --- | --- |
| line_item_id | String | PK, FK |
| purchase_order_id | String | PK, FK |
| tracking_category_id | String | PK, FK |
| tracking_category_option_id | String | FK |
| option | String |  |

### manual_journal

| Column | Type | Keys |
| --- | --- | --- |
| manual_journal_id | String | PK |
| date | LocalDate |  |
| has_attachments | Boolean |  |
| line_amount_types | String |  |
| narration | String |  |
| show_on_cash_basis_reports | Boolean |  |
| status | String |  |
| updated_date_utc | Instant |  |

### purchase_order_line_item

| Column | Type | Keys |
| --- | --- | --- |
| line_item_id | String | PK |
| purchase_order_id | String | PK, FK |
| account_code | String |  |
| account_id | String |  |
| description | String |  |
| discount_rate | BigDecimal |  |
| item_code | String |  |
| line_amount | BigDecimal |  |
| quantity | BigDecimal |  |
| tax_amount | BigDecimal |  |
| tax_type | String |  |
| unit_amount | BigDecimal |  |

### bank_account

| Column | Type | Keys |
| --- | --- | --- |
| account_id | String | PK |
| code | String |  |
| name | String |  |

### credit_note

| Column | Type | Keys |
| --- | --- | --- |
| credit_note_id | String | PK |
| branding_theme_id | String | FK |
| contact_id | String | FK |
| applied_amount | BigDecimal |  |
| credit_note_number | String |  |
| currency_code | String |  |
| currency_rate | BigDecimal |  |
| date | LocalDate |  |
| due_date | LocalDate |  |
| fully_paid_on_date | LocalDate |  |
| has_attachments | Boolean |  |
| line_amount_types | String |  |
| reference | String |  |
| remaining_credit | BigDecimal |  |
| sent_to_contact | Boolean |  |
| status | String |  |
| sub_total | BigDecimal |  |
| total | BigDecimal |  |
| total_tax | BigDecimal |  |
| type | String |  |
| updated_date_utc | Instant |  |

### receipt

| Column | Type | Keys |
| --- | --- | --- |
| receipt_id | String | PK |
| contact_id | String | FK |
| expense_claim_id | String | FK |
| user_id | String | FK |
| date | LocalDate |  |
| has_attachments | Boolean |  |
| id | String |  |
| line_amount_types | String |  |
| receipt_number | Int |  |
| reference | String |  |
| status | String |  |
| sub_total | BigDecimal |  |
| total | BigDecimal |  |
| total_tax | BigDecimal |  |
| updated_date_utc | Instant |  |

### manual_journal_line

| Column | Type | Keys |
| --- | --- | --- |
| line | Int | PK |
| manual_journal_id | String | PK, FK |
| account_id | String | FK |
| account_code | String |  |
| description | String |  |
| is_blank | Boolean |  |
| line_amount | BigDecimal |  |
| tax_amount | BigDecimal |  |
| tax_type | String |  |

### bank_transaction_line_item_has_tracking_category

| Column | Type | Keys |
| --- | --- | --- |
| bank_transaction_id | String | PK, FK |
| line_item_id | String | PK, FK |
| tracking_category_id | String | PK, FK |
| tracking_category_option_id | String | FK |
| option | String |  |

### journal_cash_line

| Column | Type | Keys |
| --- | --- | --- |
| journal_line_id | String | PK |
| journal_id | String | PK, FK |
| account_id | String | FK |
| account_code | String |  |
| account_name | String |  |
| account_type | String |  |
| description | String |  |
| gross_amount | BigDecimal |  |
| net_amount | BigDecimal |  |
| tax_amount | BigDecimal |  |
| tax_name | String |  |
| tax_type | String |  |

### manual_journal_line_has_tracking_category

| Column | Type | Keys |
| --- | --- | --- |
| manual_journal_id | String | PK, FK |
| manual_journal_line_id | String | PK, FK |
| tracking_category_id | String | PK, FK |
| tracking_category_option_id | String | FK |
| option | String |  |

### aus_payroll_timesheet_line

| Column | Type | Keys |
| --- | --- | --- |
| index_id | Long | PK |
| timesheet_id | String | PK, FK |
| earnings_rate_id | String |  |
| number_of_units | Json |  |
| updated_date_utc | Instant |  |

### allocation

| Column | Type | Keys |
| --- | --- | --- |
| allocation_id | String | PK |
| index | Long | PK |
| credit_note_id | String | FK |
| invoice_id | String | FK |
| overpayment_id | String | FK |
| prepayment_id | String | FK |
| amount | BigDecimal |  |
| date | LocalDate |  |

## Relationships

- expense_claim(user_id) → user(user_id)
- journal_line_has_tracking_category(tracking_category_id) → tracking_category(tracking_category_id)
- journal_line_has_tracking_category(tracking_category_option_id) → tracking_category_option(tracking_option_id)
- journal_line_has_tracking_category(journal_id) → journal(journal_id)
- journal_line_has_tracking_category(journal_line_id) → journal_line(journal_line_id)
- repeating_invoice(branding_theme_id) → branding_theme(branding_theme_id)
- repeating_invoice(contact_id) → contact(contact_id)
- prepayment_line_item(prepayment_id) → prepayment(prepayment_id)
- repeating_invoice_line_item_has_tracking_category(tracking_category_id) → tracking_category(tracking_category_id)
- repeating_invoice_line_item_has_tracking_category(repeating_invoice_id) → repeating_invoice(repeating_invoice_id)
- repeating_invoice_line_item_has_tracking_category(line_item_id) → repeating_invoice_line_item(line_item_id)
- bank_transaction(overpayment_id) → overpayment(overpayment_id)
- bank_transaction(prepayment_id) → prepayment(prepayment_id)
- bank_transaction(bank_account_id) → bank_account(account_id)
- bank_transaction(contact_id) → contact(contact_id)
- overpayment_line_item_has_tracking_category(tracking_category_id) → tracking_category(tracking_category_id)
- overpayment_line_item_has_tracking_category(tracking_category_option_id) → tracking_category_option(tracking_option_id)
- overpayment_line_item_has_tracking_category(overpayment_id) → overpayment(overpayment_id)
- overpayment_line_item_has_tracking_category(line_item_id) → overpayment_line_item(line_item_id)
- aus_payroll_leave_application(employee_id) → aus_payroll_employee(employee_id)
- tax_rate_component(_fivetran_id) → tax_rate(_fivetran_id)
- aus_payroll_leave_period(leave_application_id) → aus_payroll_leave_application(leave_application_id)
- journal_cash_line_has_tracking_category(tracking_category_id) → tracking_category(tracking_category_id)
- journal_cash_line_has_tracking_category(tracking_category_option_id) → tracking_category_option(tracking_option_id)
- journal_cash_line_has_tracking_category(journal_id) → journal_cash(journal_id)
- journal_cash_line_has_tracking_category(journal_line_id) → journal_cash_line(journal_id)
- budget_balance(budget_id) → budget(budget_id)
- budget_balance(budget_line_index) → budget_line(budget_id)
- invoice_line_item_has_tracking_category(tracking_category_id) → tracking_category(tracking_category_id)
- invoice_line_item_has_tracking_category(tracking_category_option_id) → tracking_category_option(tracking_option_id)
- invoice_line_item_has_tracking_category(invoice_id) → invoice(invoice_id)
- invoice_line_item_has_tracking_category(line_item_id) → invoice_line_item(line_item_id)
- purchase_order(branding_theme_id) → branding_theme(branding_theme_id)
- purchase_order(contact_id) → contact(contact_id)
- bank_transfer(from_bank_transaction_id) → bank_transaction(bank_transaction_id)
- bank_transfer(to_bank_transaction_id) → bank_transaction(bank_transaction_id)
- bank_transfer(from_bank_account_id) → bank_account(account_id)
- bank_transfer(to_bank_account_id) → bank_account(account_id)
- receipt_line_item_has_tracking_category(tracking_category_id) → tracking_category(tracking_category_id)
- receipt_line_item_has_tracking_category(tracking_category_option_id) → tracking_category_option(tracking_option_id)
- receipt_line_item_has_tracking_category(receipt_id) → receipt(receipt_id)
- receipt_line_item_has_tracking_category(line) → receipt_line_item(receipt_id)
- overpayment_line_item(overpayment_id) → overpayment(overpayment_id)
- invoice(branding_theme_id) → branding_theme(branding_theme_id)
- invoice(repeating_invoice_id) → repeating_invoice(repeating_invoice_id)
- invoice(contact_id) → contact(contact_id)
- journal_line(account_id) → account(account_id)
- journal_line(journal_id) → journal(journal_id)
- bank_transaction_line_items(bank_transaction_id) → bank_transaction(bank_transaction_id)
- asset(asset_type_id) → asset_type(asset_type_id)
- receipt_line_item(receipt_id) → receipt(receipt_id)
- contact(branding_theme_id) → branding_theme(branding_theme_id)
- aus_payroll_timesheet(employee_id) → aus_payroll_employee(employee_id)
- payment(expense_claim_id) → expense_claim(expense_claim_id)
- payment(credit_note_id) → credit_note(credit_note_id)
- payment(overpayment_id) → overpayment(overpayment_id)
- payment(prepayment_id) → prepayment(prepayment_id)
- payment(invoice_id) → invoice(invoice_id)
- payment(account_id) → account(account_id)
- tracking_category_has_option(tracking_category_id) → tracking_category(tracking_category_id)
- tracking_category_has_option(tracking_option_id) → tracking_category_option(tracking_option_id)
- credit_note_line_item_has_tracking_category(tracking_category_id) → tracking_category(tracking_category_id)
- credit_note_line_item_has_tracking_category(tracking_category_option_id) → tracking_category_option(tracking_option_id)
- credit_note_line_item_has_tracking_category(credit_note_id) → credit_note(credit_note_id)
- prepayment_line_item_has_tracking_category(tracking_category_id) → tracking_category(tracking_category_id)
- prepayment_line_item_has_tracking_category(pre_payment_id) → prepayment(prepayment_id)
- prepayment_line_item_has_tracking_category(line_item_id) → prepayment_line_item(line_item_id)
- invoice_linked_transactions(invoice_id) → invoice(invoice_id)
- invoice_linked_transactions(invoice_line_item_id) → invoice_line_item(line_item_id)
- invoice_linked_transactions(contact_id) → contact(contact_id)
- contact_address(contact_id) → contact(contact_id)
- repeating_invoice_line_item(repeating_invoice_id) → repeating_invoice(repeating_invoice_id)
- invoice_line_item(invoice_id) → invoice(invoice_id)
- invoice_line_item(item_id) → item(item_id)
- credit_note_line_item(credit_note_id) → credit_note(credit_note_id)
- budget_line(budget_id) → budget(budget_id)
- budget_line(account_id) → account(account_id)
- contact_group_member(contact_group_id) → contact_group(contact_group_id)
- contact_group_member(contact_id) → contact(contact_id)
- bank_linked_transactions(source_transaction_id) → bank_transaction(bank_transaction_id)
- bank_linked_transactions(source_line_item_id) → bank_transaction_line_items(bank_transaction_id)
- bank_linked_transactions(target_transaction_id) → bank_transaction(bank_transaction_id)
- bank_linked_transactions(target_line_item_id) → bank_transaction_line_items(bank_transaction_id)
- bank_linked_transactions(contact_id) → contact(contact_id)
- contact_phone(contact_id) → contact(contact_id)
- purchase_order_line_item_has_tracking_category(tracking_category_id) → tracking_category(tracking_category_id)
- purchase_order_line_item_has_tracking_category(tracking_category_option_id) → tracking_category_option(tracking_option_id)
- purchase_order_line_item_has_tracking_category(purchase_order_id) → purchase_order(purchase_order_id)
- purchase_order_line_item_has_tracking_category(line_item_id) → purchase_order_line_item(purchase_order_id)
- purchase_order_line_item(purchase_order_id) → purchase_order(purchase_order_id)
- credit_note(branding_theme_id) → branding_theme(branding_theme_id)
- credit_note(contact_id) → contact(contact_id)
- receipt(expense_claim_id) → expense_claim(expense_claim_id)
- receipt(contact_id) → contact(contact_id)
- receipt(user_id) → user(user_id)
- manual_journal_line(manual_journal_id) → manual_journal(manual_journal_id)
- manual_journal_line(account_id) → account(account_id)
- bank_transaction_line_item_has_tracking_category(tracking_category_id) → tracking_category(tracking_category_id)
- bank_transaction_line_item_has_tracking_category(tracking_category_option_id) → tracking_category_option(tracking_option_id)
- bank_transaction_line_item_has_tracking_category(bank_transaction_id) → bank_transaction(bank_transaction_id)
- bank_transaction_line_item_has_tracking_category(line_item_id) → bank_transaction_line_items(bank_transaction_id)
- journal_cash_line(journal_id) → journal_cash(journal_id)
- journal_cash_line(account_id) → account(account_id)
- manual_journal_line_has_tracking_category(tracking_category_id) → tracking_category(tracking_category_id)
- manual_journal_line_has_tracking_category(tracking_category_option_id) → tracking_category_option(tracking_option_id)
- manual_journal_line_has_tracking_category(manual_journal_id) → manual_journal(manual_journal_id)
- manual_journal_line_has_tracking_category(manual_journal_line_id) → manual_journal_line(manual_journal_id)
- aus_payroll_timesheet_line(timesheet_id) → aus_payroll_timesheet(id)
- allocation(credit_note_id) → credit_note(credit_note_id)
- allocation(overpayment_id) → overpayment(overpayment_id)
- allocation(prepayment_id) → prepayment(prepayment_id)
- allocation(invoice_id) → invoice(invoice_id)