Documentation

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Talk To sales
  • Start Trial

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.

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Pulse

    • Daton

      Need help with something?

      Talk to data expert

      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:

      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
      database schema xero v2

      Was this article helpful?

      Yes
      No
      Give feedback about this article

      Related Articles

      • Essential Attributes and Supported Tables
      • About Xero v2
      • How to Integrate Xero V2 with Daton

      Table of Contents

      Tables/APIs Xero Data Accounts Bank_Transfers Bank_Transactions Contacts Contact_Groups Employees Invoices Currencies CreditNotes

      Get Started on your Data Journey Today!

      Get a free 14-day trial of Daton today, no credit card is required.

      Start Free Trial
      Talk To Experts
      • Quick & Easy Setup
      • Secure & Reliable
      • No-Code Platform
      • Auto Updates
      • 24/7 Support

      Follow Us

      Linkedin Youtube

      Company

      • Customers
      • Partner With Us
      • Contact Us

      Culture

      • About
      • People
      • Careers

      Offerings

      • Daton
      • For Brands
      • For Agencies

      Policies

      • Terms of Service
      • Privacy Policy
      • MSA

      Follow Us

      Linkedin Youtube

      DISCLAIMER: Various trademarks are held by their respective owners

      © 2023 sarasanalytics.com

      Sitemap

      Get Started on your Data Journey Today!

      Get a free 14-day trial of Daton today, no credit card is required.

      Start Free Trial
      Talk To Sales
      DISCLAIMER: Trademarks are held by their respective owners
      • Quick & Easy Setup
      • Secure & Reliable
      • No-Code Platform
      • Auto Updates
      • 24/7 Support

      Company

      • Customers
      • Partners
      • About
      • People
      • Careers
      • Contact Us

      Offerings

      • Daton
      • Solution for Brands
      • Solution for Agencies
      • Dashboards
      • Founder's Note
      • Status

      Policies

      • Terms of Service
      • Privacy Policy
      • MSA
      • Sitemap

      © 2023 sarasanalytics.com

      Linkedin Youtube

      Knowledge Base Software powered by Helpjuice

      Expand