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