Xero

Explore the interactive ERD

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	PKFK
`journal_line_id`	String	PKFK
`tracking_category_id`	String	PKFK
`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	PKFK
`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	PKFK
`repeating_invoice_id`	String	PKFK
`tracking_category_id`	String	PKFK
`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	PKFK
`overpayment_id`	String	PKFK
`tracking_category_id`	String	PKFK
`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	PKFK
`is_compound`	Boolean
`is_non_recoverable`	Boolean
`rate`	BigDecimal

aus_payroll_leave_period

Column	Type	Keys
`index_id`	Long	PK
`leave_application_id`	String	PKFK
`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	PKFK
`journal_line_id`	String	PKFK
`tracking_category_id`	String	PKFK
`tracking_category_option_id`	String	FK
`option`	String

budget_balance

Column	Type	Keys
`period`	String	PK
`budget_id`	String	PKFK
`budget_line_index`	Int	PKFK
`amount`	BigDecimal
`notes`	String
`unit_amount`	BigDecimal

invoice_line_item_has_tracking_category

Column	Type	Keys
`invoice_id`	String	PKFK
`line_item_id`	String	PKFK
`tracking_category_id`	String	PKFK
`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	PKFK
`receipt_id`	String	PKFK
`tracking_category_id`	String	PKFK
`tracking_category_option_id`	String	FK
`option`	String

overpayment_line_item

Column	Type	Keys
`line_item_id`	String	PK
`overpayment_id`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`tracking_option_id`	String	PKFK

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	PKFK
`tracking_category_id`	String	PKFK
`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	PKFK
`pre_payment_id`	String	PKFK
`tracking_category_id`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`account_id`	String	FK
`account_code`	String

contact_group_member

Column	Type	Keys
`contact_group_id`	String	PKFK
`contact_id`	String	PKFK

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	PKFK
`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	PKFK
`purchase_order_id`	String	PKFK
`tracking_category_id`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`line_item_id`	String	PKFK
`tracking_category_id`	String	PKFK
`tracking_category_option_id`	String	FK
`option`	String

journal_cash_line

Column	Type	Keys
`journal_line_id`	String	PK
`journal_id`	String	PKFK
`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	PKFK
`manual_journal_line_id`	String	PKFK
`tracking_category_id`	String	PKFK
`tracking_category_option_id`	String	FK
`option`	String

aus_payroll_timesheet_line

Column	Type	Keys
`index_id`	Long	PK
`timesheet_id`	String	PKFK
`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