ODBC Driver for Sage Business Cloud Accounting

Build 22.0.8479

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479