ERD for Xero

13 tables

Loading diagram…

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

accounts_payable_tax_type

string

company_number

string

account_number

string

updated_date_utc

date

is_supplier

boolean

is_customer

boolean

discount

int

website

string

purchases_default_account_code

string

sales_default_line_amount_type

string

purchases_default_line_amount_type

string

sales_default_account_code

string

batch_payments_bank_account_number

string

batch_payments_bank_account_name

string

batch_payments_details

string

payment_terms_bills_day

int

payment_terms_bills_type

string

payment_terms_sales_day

int

payment_terms_sales_type

string

xero_network_key

string

has_attachments

boolean

has_validation_errors

boolean

merged_to_contact_id

string

tracking_category_name

string

tracking_option_name

string

tenant_id

string

_weld_synced

date

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

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

contact_is_customer

boolean

date

due_date

date

date_string

date

due_date_string

date

status

string

line_amount_types

string

sub_total

double

total_tax

double

total

double

updated_date_utc

date

currency_code

string

currency_rate

double

invoice_number

string

amount_due

double

amount_paid

double

amount_credited

double

tenant_id

string

_weld_synced

date

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

item_name

string

item_code

string

tracking

string

line_item_id

string

_weld_synced

date

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

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

date

date_string

string

expiry_date

date

expiry_date_string

string

status

string

currency_rate

double

currency_code

string

sub_total

double

total_tax

double

total

double

total_discount

double

title

string

summary

string

branding_theme_id

string

updated_date_utc

date

line_amount_types

string

tenant_id

string

_weld_synced

date

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

tax_amount

double

tax_type

string

tracking_tracking_category_id

string

tracking_tracking_option_id

string

tracking_name

string

tracking_option

string

index

int

_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

is_demo_company

boolean

organisation_status

string

financial_year_end_day

int

financial_year_end_month

int

default_sales_tax

string

default_purchases_tax

string

created_date_utc

string

organisation_entity_type

string

timezone

string

short_code

string

edition

string

class

string

line_of_business

string

phones

string

payment_terms_bills_day

int

payment_terms_bills_type

string

payment_terms_sales_day

int

payment_terms_sales_type

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

date

bank_amount

double

amount

double

reference

string

currency_rate

double

payment_type

string

status

string

updated_date_utc

date

has_account

boolean

is_reconciled

boolean

account_account_id

string

account_code

string

invoice_type

string

invoice_invoice_id

string

invoice_invoice_number

string

invoice_contact_contact_id

string

invoice_contact_name

string

tenant_id

string

_weld_synced

date

profit_and_loss_report

date

title

string

section

string

value

double

account_id

string

tenant_id

string

_weld_synced

date

Table

Sub table