Schema Information

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:

1. Accounts

2. Bank_Transfer

3. Bank_Transactions

4. Contacts

5. ContactGroups

6. Employees

7. Invoices

8. Currencies

9. 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