Excel Add-In for Sage Business Cloud Accounting

Build 22.0.8479

BankDeposits

Query BankDeposits in Sage Business Cloud Accounting.

Table Specific Information

Query the available BankDeposits

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 BankDeposits WHERE UpdatedOrCreatedSince='2018-12-15'
SELECT * FROM BankDeposits WHERE DeletedSince='2018-12-15'
SELECT * FROM BankDeposits WHERE FromDate='2018-12-15'
SELECT * FROM BankDeposits WHERE ToDate='2018-12-15'

Delete

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

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

TransactionTypeId String False

TransactionTypes.id

The unique identifier for the item

ChequeAmount String False

Cheque total in the deposit

TransactionId String False

Transactions.id

The unique identifier for the item

Date Datetime True

User generated date of transaction, not necessarily when it was created

Reference String False

Reference

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

TotalAmount String False

Total of cash and cheques in the deposit

CashAmount String False

Cash total in the deposit

DeletedSince Datetime True

FromDate Datetime True

ToDate Datetime True

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