Xero schema and ERD

31 tables

Loading diagram…

bank_transaction

budget

contact

contact_group

credit_note

invoice

journal

organisation

quote

tracking_category

account

account_id

string

tenant_id

string

code

string

name

string

status

string

type

string

tax_type

string

description

string

class

string

balance_sheet_report

report_id

string

report_name

string

report_type

string

report_titles

string

report_date

date

updated_date_utc

date

tenant_id

string

row_type

string

title

string

_weld_synced

date

bank_transaction

bank_transaction_id

string

tenant_id

string

contact_contact_id

string

contact_name

string

date_string

date

status

string

line_amount_types

string

sub_total

double

bank_transaction_line_item

bank_transaction_id

string

account_id

string

tenant_id

string

line_item_id

string

description

string

quantity

double

unit_amount

double

account_code

string

item_code

string

tax_type

string

tax_amount

double

line_amount

double

tracking

string

_weld_synced

date

budget

budget_id

string

tenant_id

string

type

string

description

string

updated_date_utc

date

_weld_synced

date

budget_tracking

budget_id

string

tracking_category_id

string

tenant_id

string

tracking_option_id

string

name

string

option

string

status

string

_weld_synced

date

budget_tracking_option

budget_id

string

tracking_category_id

string

tenant_id

string

tracking_option_id

string

name

string

status

string

_weld_synced

date

budget_line

budget_id

string

account_id

string

tenant_id

string

account_code

string

_weld_synced

date

budget_balance

budget_id

string

account_id

string

tenant_id

string

period

date

amount

double

unit_amount

double

_weld_synced

date

contact

contact_id

string

contact_status

string

name

string

first_name

string

last_name

string

email_address

string

bank_account_details

string

tax_number

string

accounts_receivable_tax_type

string

contact_phone

contact_id

string

index

int

phone_type

string

phone_number

string

phone_area_code

string

phone_country_code

string

_weld_synced

date

contact_address

contact_id

string

index

int

address_type

string

address_line_1

string

address_line_2

string

city

string

postal_code

string

country

string

attention_to

string

_weld_synced

date

contact_group

contact_group_id

string

tenant_id

string

name

string

status

string

_weld_synced

date

contact_group_contact

contact_group_id

string

contact_id

string

tenant_id

string

name

string

_weld_synced

date

credit_note

credit_note_id

string

tenant_id

string

contact_contact_id

string

contact_name

string

date_string

date

due_date

date

status

string

line_amount_types

string

credit_note_payment

credit_note_id

string

payment_id

string

tenant_id

string

date

amount

double

reference

string

currency_rate

double

has_account

boolean

has_validation_errors

boolean

_weld_synced

date

credit_note_allocation

credit_note_id

string

tenant_id

string

allocation_id

string

amount

double

date

invoice_invoice_id

string

invoice_invoice_number

string

_weld_synced

date

credit_note_line_item

credit_note_id

string

account_id

string

tenant_id

string

line_item_id

string

description

string

quantity

double

unit_amount

double

tax_type

string

tax_amount

double

line_amount

double

account_code

string

tracking

string

_weld_synced

date

invoice

invoice_id

string

type

string

contact_contact_id

string

contact_contact_status

string

contact_name

string

contact_addresses

string

contact_phones

string

contact_updated_date_utc

date

contact_is_supplier

boolean

invoice_payment

invoice_id

string

payment_id

string

date

amount

double

_weld_synced

date

invoice_line_item

invoice_id

string

description

string

quantity

double

unit_amount

double

tax_type

string

tax_amount

double

line_amount

double

account_code

string

item_item_id

string

journal

journal_id

string

journal_date

date

journal_number

int

created_date_utc

date

tenant_id

string

source_id

string

source_type

string

_weld_synced

date

journal_line

journal_id

string

journal_line_id

string

account_id

string

account_code

string

account_type

string

account_name

string

description

string

net_amount

double

gross_amount

double

tax_amount

double

tax_type

string

tax_name

string

tracking_categories

string

_weld_synced

date

organisation

organisation_id

string

tenant_id

string

name

string

legal_name

string

pays_tax

boolean

version

string

organisation_type

string

base_currency

string

country_code

string

organisation_external_link

organisation_id

string

link_type

string

url

string

_weld_synced

date

payment

payment_id

string

batch_payment_id

string

batch_payment_account_account_id

string

batch_payment_date

date

batch_payment_type

string

batch_payment_status

string

batch_payment_total_amount

double

batch_payment_updated_date_utc

date

batch_payment_is_reconciled

boolean

profit_and_loss_report

account_id

string

date

title

string

section

string

value

double

tenant_id

string

_weld_synced

date

quote

quote_id

string

quote_number

string

reference

string

terms

string

contact_contact_id

string

contact_name

string

contact_email_address

string

contact_first_name

string

contact_last_name

string

quote_line_item

quote_id

string

line_item_id

string

account_code

string

description

string

unit_amount

double

discount_rate

double

line_amount

double

item_code

string

quantity

double

tracking_category

tracking_category_id

string

tenant_id

string

name

string

status

string

_weld_synced

date

tracking_category_option

tracking_category_id

string

tracking_option_id

string

tenant_id

string

name

string

status

string

has_validation_errors

boolean

is_deleted

boolean

is_archived

boolean

is_active

boolean

_weld_synced

date