Xero Accounting Endpoint: Items
Jump to navigation
Jump to search
Overview
The Xero Items endpoint allows you to access the list items that can be included on Invoices.
Note that an alternate endpoint named ItemsTable is available which provides a format that can more easily integrate with Tableau, SSIS and Azure Data Factory.
Fields
The following fields are available for the Items endpoint.
- DataFile
- A record field that identifies the source data file for this record.
- ItemID
- A GUID field representing the internal id of an item.
- This field can be used to link to other endpoints.
- Code
- A text field that provides the unique item code.
- This field can be used to link to other endpoints.
- Name
- A text field provides the name of the item.
- IsSold
- A true/false value that indicates if the item can be included on customer invoices.
- IsPurchased
- A true/false value that indicates if the item can be included on supplier invoices.
- Description
- A text field provides the description of the item.
- PurchaseDescription
- A text field provides the purchase description of the item.
- PurchaseDetails
- A record field provides further information for purchases.
- See PurchaseDetails Fields for more information.
- SalesDetails
- A record field provides further information for sales.
- See SalesDetails Fields for more information.
- IsTrackedAsInventory
- A true/false value that indicates if the item is tracked for inventory purposes.
- InventoryAssetAccountCode
- A text field that provides the account code used for inventory management.
- TotalCostPool
- A decimal field that provides total value of items currently in stock.
- QuantityOnHand
- A decimal field that provides total quantity on hand of items currently in stock.
- UpdatedDateUTC
- A date time field that indicates the last time this record was updated.
PurchaseDetails Fields
The PurchaseDetails Fields include the following sub fields.
- UnitPrice
- A decimal field that provides default unit price when purchasing this item.
- AccountCode
- A text field that provides the account code used when purchasing this item.
- COGSAccountCode
- A text field that provides the cost of sales account code used when selling this item.
- TaxType
- A text field that provides the tax type used when purchasing this item.
SalesDetails Fields
The SalesDetails Fields include the following sub fields.
- UnitPrice
- A decimal field that provides default unit price when selling this item.
- AccountCode
- A text field that provides the account code used when selling this item.
- TaxType
- A text field that provides the tax type used when selling this item.
Xero API
For a detailed run through of the endpoint, you can see the Xero API.
Related Fields
Related Endpoints
- Accounts
- BankTransactionsExpanded
- CreditNotesExpanded
- InvoicesExpanded
- ItemsTable
- PurchaseOrders
- Quotes
- RepeatingInvoices
- TaxRates