JDBC Driver for Sage Business Cloud Accounting

Build 22.0.8479

BankTransfers

Query BankTransfers in Sage Business Cloud Accounting.

Table Specific Information

Query the available BankTransfers

Select

The driver uses the Sage Accounting API to process search criteria that refer to UpdatedOrCreatedSince,DeletedSince,FromDate,ToDate columns. The driver processes other filters client-side within the driver.

  • UpdatedOrCreatedSince supports the '=' operator.
  • DeletedSince supports the '=' operator.
  • FromDate supports the '=' operator.
  • ToDate supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM BankTransfers WHERE UpdatedOrCreatedSince='2018-12-15'
SELECT * FROM BankTransfers WHERE DeletedSince='2018-12-15'
SELECT * FROM BankTransfers WHERE FromDate='2018-12-15'
SELECT * FROM BankTransfers WHERE ToDate='2018-12-15'

Insert


INSERT INTO BankTransfers (Amount, FromBankAccountId, ToBankAccountId) VALUES ('2', '123', '456')

Update

Updates are performed based on Id.

UPDATE BankTransfers SET Date='abc' WHERE Id='123'

Delete

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

DELETE FROM BankTransfers 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 String False

The date of the bank transfer

Reference String False

The reference for the bank transfer

Amount String False

The amount of the bank transfer

UpdatedAt Datetime True

The datetime when the item was last updated

LegacyId Int False

The legacy ID for the item

DeletedAt Datetime True

The datetime when the item was deleted

FromBankAccountId String False

BankAccounts.Id

The unique identifier for the item

ToBankAccountId String False

BankAccounts.Id

The unique identifier for the item

Description String False

The description for the bank transfer

DeletedSince Datetime True

FromDate Datetime True

ToDate Datetime True

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