SSIS Components for Xero

Build 24.0.9062

Accounts

Query, insert, update and delete accounts for a Xero organisation.

Table Specific Information

The Accounts table allows you to SELECT and INSERT accounts for a Xero organization.

SELECT

The Xero API allows extensive filtering and ordering. You can define WHERE and ORDER BY clauses in a query to filter and order the results using any non-line-item column.

Note: The Xero API does not support filtering on line items or journal lines.

INSERT

To insert a single row, set the required fields. A new table object is created as a single entry. The following fields are required for inserts: Code, Name, and Type.

INSERT INTO Accounts (Name, Code, Type) VALUES ('John Doe', '2000', 'BANK')

Columns

Name Type ReadOnly Description
AccountId [KEY] String True

The unique, Xero-assigned identifier of the account.

Code String False

Customer-defined alphanumeric account code. For example, 200 or SALES.

Name String False

Name of the account.

Type String False

The account type. Valid values are BANK, CURRENT, CURRLIAB, DEPRECIATN, DIRECTCOSTS, EQUITY, EXPENSE, FIXED, LIABILITY, NONCURRENT, OTHERINCOME, OVERHEADS, PREPAYMENT, REVENUE, SALES, TERMLIAB, PAYGLIABILITY, SUPERANNUATIONEXPENSE, SUPERANNUATIONLIABILITY, and WAGESEXPENSE.

Description String False

Description of the account. All accounts except bank accounts return this element.

TaxType String False

The tax type. For example, INPUT or NONE.

EnablePaymentsToAccount Boolean False

Describes whether the account can have payments applied to it.

ShowInExpenseClaims Boolean False

Describes whether the account code is available for use with expense claims.

Class String True

The account class type. For example, ASSET or EQUITY.

Status String False

The account status code.

SystemAccount String True

Returned only for system accounts, such as DEBTORS, CREDITORS, etc.

BankAccountNumber String False

The bank account number associated with the account. BANK account types only.

CurrencyCode String False

The currency code associated with the account. BANK account types only.

ReportingCode String True

The reporting code. Only available for NZ organisations.

ReportingCodeName String True

The reporting code name. Only available for NZ organisations.

UpdatedDateUTC Datetime True

Timestamp of the last change to the user record.

HasAttachments Boolean True

This field indicates whether the invoice has an attachment.

BankAccountType String False

Valid types are BANK, CREDITCARD, and PAYPAL

TenantId String False

The ID of the tenant to query instead of the connection tenant

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062