Schema Information of Xero v2
This topic provides a structured reference to assist you in working with Daton's Xero v2 connector and the associated fields and tables.
Schema Information of Xero v2
This topic provides a structured reference to assist you in working with Daton's Xero v2 connector and the associated fields and tables.
Tables/APIs
The following is the list of tables or APIs associated with the Xero v2 connector:
- Accounts
- Bank_Transfer
- Bank_Transactions
- Contacts
- ContactGroups
- Employees
- Invoices
- Currencies
- CreditNotes
Xero Data
Accounts
This API retrieves the full chart of accounts. For more information, see Accounts
Fields
Field Name |
Data Type |
|---|---|
AccountID |
STRING |
Code |
STRING |
Name |
STRING |
Status |
STRING |
Type |
STRING |
TaxType |
STRING |
Class |
STRING |
EnablePaymentsToAccount |
BOOLEAN |
ShowInExpenseClaims |
BOOLEAN |
BankAccountNumber |
STRING |
BankAccountType |
STRING |
CurrencyCode |
STRING |
ReportingCode |
STRING |
ReportingCodeName |
STRING |
HasAttachments |
BOOLEAN |
UpdatedDateUTC |
STRING |
AddToWatchlist |
BOOLEAN |
Description |
STRING |
SystemAccount |
STRING |
Bank_Transfers
This API returns a list of all the bank transfers. For more information, see Bank Transfer
Fields
Field Name |
Data Type |
|---|---|
BankTransferID |
STRING |
CreatedDateUTCString |
DATETIME |
CreatedDateUTC |
STRING |
DateString |
DATETIME |
Date |
STRING |
FromBankAccount |
RECORD |
ToBankAccount |
RECORD |
Amount |
STRING |
FromBankTransactionID |
STRING |
ToBankTransactionID |
STRING |
FromIsReconciled |
STRING |
ToIsReconciled |
STRING |
Reference |
STRING |
FromBankAccount.AccountID |
STRING |
FromBankAccount.Name |
STRING |
ToBankAccount.AccountID |
STRING |
ToBankAccount.Name |
STRING |
Bank_Transactions
This API returns history of any spend or receive money transactions. For more information, see Bank Transactions
Fields
Field Name |
Data Type |
|---|---|
BankTransactionID |
STRING |
BankAccount |
RECORD |
Type |
STRING |
Reference |
STRING |
IsReconciled |
BOOLEAN |
HasAttachments |
BOOLEAN |
Contact |
RECORD |
DateString |
DATETIME |
Date |
STRING |
Status |
STRING |
LineAmountTypes |
STRING |
SubTotal |
NUMERIC |
TotalTax |
NUMERIC |
Total |
NUMERIC |
UpdatedDateUTC |
STRING |
CurrencyCode |
STRING |
BankAccount.AccountID |
STRING |
BankAccount.Code |
STRING |
BankAccount.Name |
STRING |
Contact.ContactID |
STRING |
Contact.Name |
STRING |
Contact.HasValidationErrors |
BOOLEAN |
Contacts
This API returns a list of all the contacts. For more information. see Contacts
Fields
Field Name |
Data Type |
|---|---|
ContactID |
STRING |
ContactStatus |
STRING |
Name |
STRING |
Addresses |
RECORD |
Phones |
RECORD |
UpdatedDateUTC |
STRING |
IsSupplier |
BOOLEAN |
IsCustomer |
BOOLEAN |
HasAttachments |
BOOLEAN |
HasValidationErrors |
BOOLEAN |
Balances |
RECORD |
ContactNumber |
STRING |
FirstName |
STRING |
LastName |
STRING |
EmailAddress |
STRING |
BankAccountDetails |
STRING |
DefaultCurrency |
STRING |
BatchPayments |
RECORD |
ContactGroups |
RECORD |
BrandingTheme |
RECORD |
TaxNumber |
STRING |
AccountsReceivableTaxType |
STRING |
AccountsPayableTaxType |
STRING |
Addresses.AddressType |
STRING |
Addresses.City |
STRING |
Addresses.Region |
STRING |
Addresses.PostalCode |
STRING |
Addresses.Country |
STRING |
Addresses.AttentionTo |
STRING |
Addresses.AddressLine1 |
STRING |
Addresses.AddressLine2 |
STRING |
Addresses.AddressLine3 |
STRING |
Addresses.AddressLine4 |
STRING |
Phones.PhoneType |
STRING |
Phones.PhoneNumber |
STRING |
Phones.PhoneAreaCode |
STRING |
Phones.PhoneCountryCode |
STRING |
Balances.AccountsReceivable |
RECORD |
Balances.AccountsReceivable.Outstanding |
NUMERIC |
Balances.AccountsReceivable.Overdue |
NUMERIC |
Balances.AccountsPayable |
RECORD |
Balances.AccountsPayable.Outstanding |
NUMERIC |
Balances.AccountsPayable.Overdue |
NUMERIC |
BatchPayments.BankAccountNumber |
STRING |
BatchPayments.BankAccountName |
STRING |
BatchPayments.Details |
STRING |
BatchPayments.Code |
STRING |
BatchPayments.Reference |
STRING |
ContactGroups.ContactGroupID |
STRING |
ContactGroups.Name |
STRING |
ContactGroups.Status |
STRING |
ContactGroups.HasValidationErrors |
BOOLEAN |
BrandingTheme.BrandingThemeID |
STRING |
BrandingTheme.Name |
STRING |
Contact_Groups
This API returns a list of all the Contact groups. For more information, see Conact Groups
Fields
Field Name |
Data Type |
|---|---|
ContactGroupID |
STRING |
Name |
STRING |
Status |
STRING |
HasValidationErrors |
BOOLEAN |
Employees
This API returns a list of all the employees. For more information, see Employees
Fields
Field Name |
Data Type |
|---|---|
EmployeeID |
STRING |
Status |
STRING |
FirstName |
STRING |
LastName |
STRING |
ExternalLink |
RECORD |
UpdatedDateUTC |
STRING |
ExternalLink.Url |
STRING |
ExternalLink.Description |
STRING |
Invoices
This API Returns a list of all the Invoices. For more information, see invoices
Fields
Field Name |
Data Type |
|---|---|
Type |
STRING |
InvoiceID |
STRING |
InvoiceNumber |
STRING |
Reference |
STRING |
AmountDue |
NUMERIC |
AmountPaid |
NUMERIC |
AmountCredited |
NUMERIC |
CurrencyRate |
NUMERIC |
IsDiscounted |
BOOLEAN |
HasAttachments |
BOOLEAN |
HasErrors |
BOOLEAN |
Contact |
RECORD |
DateString |
DATETIME |
Date |
STRING |
DueDateString |
DATETIME |
DueDate |
STRING |
BrandingThemeID |
STRING |
Status |
STRING |
LineAmountTypes |
STRING |
SubTotal |
NUMERIC |
TotalTax |
NUMERIC |
Total |
NUMERIC |
UpdatedDateUTC |
STRING |
CurrencyCode |
STRING |
LineItems |
RECORD |
Url |
STRING |
Contact.ContactID |
STRING |
Contact.Name |
STRING |
Contact.HasValidationErrors |
BOOLEAN |
Contact.ContactNumber |
STRING |
LineItems.Description |
STRING |
LineItems.UnitAmount |
NUMERIC |
LineItems.TaxType |
STRING |
LineItems.TaxAmount |
NUMERIC |
LineItems.LineAmount |
NUMERIC |
LineItems.AccountCode |
STRING |
LineItems.Quantity |
NUMERIC |
LineItems.LineItemID |
STRING |
LineItems.AccountID |
STRING |
Currencies
This API returns the list of all the currencies. For more information, see currencies
Fields
Field Name |
Data Type |
|---|---|
Code |
STRING |
Description |
STRING |
CreditNotes
This API retrieves the list of all the Credit notes. For more information, see Credit Notes
Fields
Field Name |
Data Type |
|---|---|
CreditNoteID |
STRING |
CreditNoteNumber |
STRING |
ID |
STRING |
HasErrors |
BOOLEAN |
Type |
STRING |
Reference |
STRING |
RemainingCredit |
NUMERIC |
Allocations |
RECORD |
HasAttachments |
BOOLEAN |
Contact |
RECORD |
DateString |
DATETIME |
Date |
STRING |
Status |
STRING |
LineAmountTypes |
STRING |
SubTotal |
NUMERIC |
TotalTax |
NUMERIC |
Total |
NUMERIC |
UpdatedDateUTC |
STRING |
CurrencyCode |
STRING |
FullyPaidOnDate |
STRING |
Allocations.AllocationID |
STRING |
Allocations.Amount |
NUMERIC |
Allocations.Date |
STRING |
Allocations.Invoice |
RECORD |
Allocations.Invoice.InvoiceID |
STRING |
Allocations.Invoice.InvoiceNumber |
STRING |
Allocations.Invoice.IsDiscounted |
BOOLEAN |
Allocations.Invoice.HasErrors |
BOOLEAN |
Contact.ContactID |
STRING |
Contact.Name |
STRING |
Contact.HasValidationErrors |
BOOLEAN |