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 |