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 |
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 |