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.

  • Saras Pulse

    • Saras Daton

      • Saras IQ

        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