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 |