ODBC Driver for Xero

Build 25.0.9434

EmployeeBankAccounts

Queries the bank accounts associated with an employee. It is used to track the employee's payment details and manage their salary or reimbursement payments.

Columns

Name Type Filterable Description
EmployeeID String The unique identifier for the employee. This field is automatically assigned by Xero.
StatementText String The text that will appear on the employee's bank statement, providing details about the payment.
AccountName String The name of the employee's bank account.
BSB String Bank State Branch (BSB) number for the employee's bank account, required for Australian accounts.
AccountNumber String The account number of the employee's bank account.
Remainder Boolean Indicates whether the remaining part of the employee's salary should be transferred to this account. If true, this account will receive the remainder of the salary after other allocations.
Amount Decimal A fixed amount of the employee's salary to be transferred to this account. This value must be less than or equal to the total salary amount.
TenantId String The unique identifier for the tenant. This allows the query to target a specific tenant, overriding the connection's default tenant.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434