SSIS Components for Xero

Build 24.0.9062

BankStatement

Query the transactions listed on the account.

Table Specific Information

SELECT

A bankAccountId may be provided when querying this view. If one is not given, then this report will be run for each bank account stored in Xero.

Note: To access bank statements, you must complete additional security requirements:

  1. Sign an addendum to Xero's developer terms and conditions.
  2. Request the accounting.reports.bankstatement.read scope in your custom OAuth app.

For more information and to complete these steps, reach out directly to Xero API support.

Columns

Name Type Description
BankAccountId String The ID of the bank account this is reporting on
Date Date The date when the transaction occurred
Description String The transaction's description
Reference String The transaction's reference value
Reconciled String Whether the transaction has been reconciled ('Yes' or 'No')
Source String Where the transaction came from
Amount Decimal The transaction's value
Balance Decimal The statement's running total
TenantId String The ID of the tenant to query instead of the connection tenant

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
fromDate Date The start date of the statement
toDate Date The end date of the statement. Must be within 365 days of the start.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062