Xero Data Model_v2
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
4
Last Updated:Sep 20, 2018
5
Title:Expected Xero Data Model
6
Blendo (Apirise Inc.)
https://www.blendo.co/knowledge-category/integrations/
7
8
ResourceTable NameDescription
9
AccountsaccountsThe table contains information about the accounts in a Xero organisation
10
Bank TransactionsbanktransactionsThe table contains information about money transactions in Xero
11
Bank Transactions Line Itemsbanktransactionslineitems
12
Bank Transaction Line Items Trackingbanktransactionslineitemstracking
13
Bank TransfersbanktransfersThe table contains information about bank transfers in a Xero organisation
14
Branding ThemesbrandingthemesThe table contains information about the Branding Themes in a Xero organisation
15
Budget Summary ReportbudgetsummaryreportThe table contains information about the Budget Summary Reports.
16
ContactscontactsThe table contains information about the contacts in a Xero organisation
17
Contact GroupscontactgroupsThe table contains information about contact groups
18
Credit NotescreditnotesThe table contains information about credit notes in a Xero organisation
19
Credit Notes Line ItemscreditnoteslineitemsThe table contains information about credit notes line items in a Xero organisation
20
CurrenciescurrenciesThe table contains information about the currencies in a Xero organisation
21
EmployeesemployeesThe table contains information about the employees used in Xero payrun functionality
22
Expense ClaimsexpenseclaimsThe table contains information about the expense claims status
23
Invoice Credit Notesinvoicecreditnotes
24
InvoicesinvoicesThe table contains information about the sales invoices or purchase bills
25
ItemsitemsThe table contains information about the tracked or untracked items in a Xero organisation
26
JournalsjournalsThe table contains information about the journals in a Xero organisation
27
Journal LinesjournallinesThe table contains information about the Journal Lines in a Xero organisation
28
Line ItemslineitemsThe table contains information about the Line Items in a Xero organisation
29
Line Items TrackinglineitemstrackingThe table contains information about the tracking of Line Items
30
OrganisationorganisationThe table contains information about Xero organisations
31
PaymentspaymentsThe table contains information about the payments for invoices and credit notes in Xero
32
PrepaymentsprepaymentsThe table contains information about the prepayments in Xero
33
Purchase OrderspurchaseordersThe table contains information about the POs
34
Purchase Orders Line ItemspurchaseorderslineitemsThe table contains information about the POs Line Items
35
Purchase Orders Line Items TrackingpurchaseorderslineitemstrackingThe table contains information about the POs Line Items Tracking
36
ReceiptsreceiptsThe table contains information about expense claim receipts in Xero
37
Repeating InvoicesrepeatinginvoicesThe table contains information about the repeating invoices in Xero
38
Tax RatestaxratesThe table contains information about tax rates for a Xero organisation
39
Tracking CategoriestrackingcategoriesThe table contains information about tracking categories and options for a Xero organisation
40
Tracking Categories Optionstrackingcategoriesoptions
41
UsersusersThe table contains information about the users for a Xero organisation
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...