JDBC Driver for Sage Business Cloud Accounting

Build 22.0.8462

BankOpeningBalances

Query BankOpeningBalances in Sage Business Cloud Accounting.

Table Specific Information

Query the available BankOpeningBalances

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 BankOpeningBalances WHERE BankAccountId='abc'
SELECT * FROM BankOpeningBalances WHERE UpdatedOrCreatedSince='2018-12-15'

Insert


INSERT INTO BankOpeningBalances (TransactionId, BankAccountId) VALUES ('2', '123')

Update

Updates are performed based on Id.

UPDATE BankOpeningBalances SET Date='2018-12-15' WHERE Id='123'

Delete

You must specify the Id of the BankOpeningBalances to delete it.

DELETE FROM BankOpeningBalances 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

TransactionId String False

Transactions.Id

The unique identifier for the item

Date Datetime True

The date of the opening balance

Credit String False

The credit amount of the opening balance

BankAccountId String False

BankAccounts.Id

The unique identifier for the item

UpdatedAt Datetime True

The datetime when the item was last updated

LegacyId Int False

The legacy ID for the item

Debit String False

The debit amount of the opening balance

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