Nic: Created page with "== Overview == The Xero '''Items''' endpoint allows you to access the list items that can be included on Xero Accounting Endpoint: Invoices|In..."

2023-06-23T06:01:00Z

Created page with "== Overview == The Xero '''Items''' endpoint allows you to access the list items that can be included on Xero Accounting Endpoint: Invoices|In..."

New page

== Overview ==

The Xero '''Items''' [[Xero Accounting Endpoints|endpoint]] allows you to access the list items that can be included on [[Xero Accounting Endpoint: Invoices|Invoices]].

Note this endpoint is an alternate format of the [[Xero Accounting Endpoint: Items|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 [[Field Type: GUID|guid field]] that provides the id of the xero data file as setup in OdataLink.

;DataFileName
:A [[Field Type: Text|text field]] provides the name of the xero data file as setup in OdataLink.

;DataFileCode
:A [[Field Type: Text|text field]] provides the code of the xero data file as setup in OdataLink.

;ItemID
:A [[Field Type: GUID|GUID field]] representing the internal id of an item.
:This field can be used to link to other endpoints.

;Code
:A [[Field Type: Text|text field]] that provides the unique item code.
:This field can be used to link to other endpoints.

;Name
:A [[Field Type: Text|text field]] provides the name of the item.

;IsSold
:A [[Field Type: Boolean|true/false value]] that indicates if the item can be included on customer invoices.

;IsPurchased
:A [[Field Type: Boolean|true/false value]] that indicates if the item can be included on supplier invoices.

;Description
:A [[Field Type: Text|text field]] provides the description of the item.

;PurchaseDescription
:A [[Field Type: Text|text field]] provides the purchase description of the item.

;PurchaseUnitPrice
:A [[Field Type: Decimal|decimal field]] that provides default unit price when purchasing this item.

;PurchaseAccountCode
:A [[Field Type: Text|text field]] that provides the [[Xero Accounting Endpoint: Accounts|account code]] used when purchasing this item.

;COGSAccountCode
:A [[Field Type: Text|text field]] that provides the [[Xero Accounting Endpoint: Accounts|cost of sales account code]] used when selling this item.

;PurchaseTaxType
:A [[Field Type: Text|text field]] that provides the [[Xero Accounting Field: TaxTypes|tax type]] used when purchasing this item.

;SalesUnitPrice
:A [[Field Type: Decimal|decimal field]] that provides default unit price when selling this item.

;SalesAccountCode
:A [[Field Type: Text|text field]] that provides the [[Xero Accounting Endpoint: Accounts|account code]] used when selling this item.

;SalesTaxType
:A [[Field Type: Text|text field]] that provides the [[Xero Accounting Field: TaxTypes|tax type]] used when selling this item.

;IsTrackedAsInventory
:A [[Field Type: Boolean|true/false value]] that indicates if the item is tracked for inventory purposes.

;InventoryAssetAccountCode
:A [[Field Type: Text|text field]] that provides the [[Xero Accounting Endpoint: Accounts|account code]] used for inventory management.

;TotalCostPool
:A [[Field Type: Decimal|decimal field]] that provides total value of items currently in stock.

;QuantityOnHand
:A [[Field Type: Decimal|decimal field]] that provides total quantity on hand of items currently in stock.

;UpdatedDateUTC
:A [[Field Type: DateTimeOffset|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 [https://developer.xero.com/documentation/api/accounting/items Xero API].

== Related Fields ==

:[[Xero Accounting Field: TaxTypes|TaxTypes]]

== Related Endpoints ==

:[[Xero Accounting Endpoint: Accounts|Accounts]]
:[[Xero Accounting Endpoint: BankTransactionsExpanded|BankTransactionsExpanded]]
:[[Xero Accounting Endpoint: CreditNotesExpanded|CreditNotesExpanded]]
:[[Xero Accounting Endpoint: InvoicesExpanded|InvoicesExpanded]]
:[[Xero Accounting Endpoint: Items|Items]]
:[[Xero Accounting Endpoint: PurchaseOrders|PurchaseOrders]]
:[[Xero Accounting Endpoint: Quotes|Quotes]]
:[[Xero Accounting Endpoint: RepeatingInvoices|RepeatingInvoices]]
:[[Xero Accounting Endpoint: TaxRates|TaxRates]]

== Related Topics ==

:[[Xero Accounting Models]]
:[[Xero Accounting Endpoints]]

Xero Accounting Endpoint: ItemsTable - Revision history

Nic: Created page with "== Overview == The Xero '''Items''' endpoint allows you to access the list items that can be included on Xero Accounting Endpoint: Invoices|In..."