InvoicesItems
Queries the item details associated with invoice line items in Xero. Each row represents a single line item within an invoice, including the item ID, name, and code. These fields are only populated when retrieving individual invoices by ID.
Columns
| Name | Type | Description |
| InvoiceId [KEY] | String | The unique identifier for the parent invoice. This ID links the line item to its corresponding invoice record. |
| LineItemId [KEY] | String | The Xero-generated unique identifier for the line item within the invoice. |
| Item_ItemId [KEY] | String | The unique ID of the item the line item refers to. This links the line item to a specific product or service in the system. |
| Item_Name | String | The name of the item the line item refers to. This is the human-readable label for the product or service associated with the invoice. |
| Item_Code | String | The code associated with the item referenced in the line item. This code can be used for identifying and categorizing items in the system. |
| TenantId [KEY] | String | The unique identifier of the tenant, allowing queries to access data specific to a particular tenant instead of using the default connection tenant. |