Xero Accounting Endpoint: ItemsTable
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 this endpoint is an alternate format of the Items endpoint. It 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.
- DataFileID
- A guid field that provides the id of the xero data file as setup in OdataLink.
- DataFileName
- A text field provides the name of the xero data file as setup in OdataLink.
- DataFileCode
- A text field provides the code of the xero data file as setup in OdataLink.
- 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.
- PurchaseUnitPrice
- A decimal field that provides default unit price when purchasing this item.
- PurchaseAccountCode
- 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.
- PurchaseTaxType
- A text field that provides the tax type used when purchasing this item.
- SalesUnitPrice
- A decimal field that provides default unit price when selling this item.
- SalesAccountCode
- A text field that provides the account code used when selling this item.
- SalesTaxType
- A text field that provides the tax type used when selling this item.
- 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.
Xero API
For a detailed run through of the endpoint, you can see the Xero API.
Related Fields
Related Endpoints
- Accounts
- BankTransactionsExpanded
- CreditNotesExpanded
- InvoicesExpanded
- Items
- PurchaseOrders
- Quotes
- RepeatingInvoices
- TaxRates