Power BI Connector for Xero

Build 26.0.9655

BankTransactionsItems

Queries the line items associated with bank transactions in Xero. Each row represents a single line item within a bank transaction, including details such as the item description, quantity, unit amount, and tracking categories.

Columns

Name Type Description
BankTransactionId [KEY] String The unique identifier for the parent bank transaction. This ID links the line item to its corresponding bank transaction record.
LineItemId [KEY] String The Xero-generated unique identifier for the line item within the bank transaction.
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 transaction.
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.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655