BankReconciliations
Query BankReconciliations in Sage Business Cloud Accounting.
Table Specific Information
Query the available BankReconciliations
Select
The driver uses the Sage Accounting API to process search criteria that refer to BankAccountId,UpdatedOrCreatedSince columns. The driver processes other filters client-side within the driver.
- BankAccountId supports the '=' operator.
- UpdatedOrCreatedSince supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM BankReconciliations WHERE BankAccountId = 'abc' SELECT * FROM BankReconciliations WHERE UpdatedOrCreatedSince = '2018-12-15'
Update
Updates are performed based on Id.
UPDATE BankReconciliations SET BalanceDifference = 'abc' WHERE Id = '123'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | False |
The unique identifier for the item | |
| CreatedAt | Datetime | True |
The datetime when the item was created | |
| DisplayedAs | String | False |
The name of the resource | |
| BalanceDifference | String | False |
The difference between the statement end balance and the reconciled balance | |
| TotalPaid | String | False |
The total amount paid | |
| Reference | String | False |
A reference for the bank reconciliation | |
| TotalReceived | String | False |
The total amount received | |
| StatusDisplayedAs | String | False |
The bank reconciliation status name | |
| StatusId | String | False |
The bank reconciliation status id | |
| BankAccountId | String | False |
BankAccounts.Id |
The unique identifier for the item |
| StatementDate | String | False |
The date of the bank reconciliation | |
| UpdatedAt | Datetime | True |
The datetime when the item was last updated | |
| LegacyId | Int | False |
The legacy ID for the item | |
| StatementEndBalance | String | False |
The statement end balance for the reconciliation | |
| StartingBalance | String | False |
The starting balance of the bank reconciliation | |
| ClosingBalance | String | False |
The closing balance of the bank reconciliation | |
| ReconciledBalance | String | False |
The reconciled balance of the bank reconciliation |