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:
- Sign an addendum to Xero's developer terms and conditions.
- 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. |