BankAccounts

Query BankAccounts in Sage Business Cloud Accounting.

Table Specific Information

Query the available BankAccounts

Select

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

UpdatedOrCreatedSince supports the '=' operator.
DeletedSince supports the '=' operator.
ExcludeStripe supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM BankAccounts WHERE UpdatedOrCreatedSince = '2019-10-02T11:46:53Z'
SELECT * FROM BankAccounts WHERE DeletedSince = '2019-10-02T11:46:53Z'
SELECT * FROM BankAccounts WHERE ExcludeStripe = 'false'

Insert

Create a simple bank account.

INSERT INTO  [Addresses] (BankAccountTypeId, Balance, AccountName) VALUES ('2', '0.0', 'test')

Update

Updates are performed based on Id.

UPDATE BankAccounts SET BankAccountTypeId = 'SAVINGS' WHERE Id = '80b34e32b85a46c39a71c3627d577fa2'

Delete

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

DELETE FROM BankAccounts WHERE id = '80b34e32b85a46c39a71c3627d577fa2'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		The unique identifier for the item
BankAccountTypeId	String	False		The unique identifier for the item The allowed values are CHECKING, SAVINGS, CREDIT_CARD, CASH_IN_HAND, LOAN, OTHER.
Balance	String	False		The bank account balance
CreatedAt	Datetime	True		The datetime when the item was created
SortCode	String	False		The sort code
Iban	String	False		The iban
Bic	String	False		The bic
AccountName	String	False		The account name
AccountNumber	String	False		The account number
MainContactId	String	False		The fax number of the contact
DefaultPaymentMethodId	String	False	PaymentMethods.Id	The unique identifier for the item
Deletable	Bool	False		Indicates whether or not the bank account can be deleted
LedgerAccountId	String	False	LedgerAccounts.Id	The unique identifier for the item
MainAddressId	String	False	Addresses.Id	The unique identifier for the item
DeletedAt	Datetime	True		The datetime when the item was deleted
Editable	Bool	False		Indicates whether or not the bank account can be edited
DisplayedAs	String	False		The name of the resource
JournalCodeId	String	False	JournalCodes.Id	The unique identifier for the item
NominalCode	Int	False		The nominal code of the bank account
LegacyId	Int	False		The legacy ID for the item
UpdatedAt	Datetime	True		The datetime when the item was last updated
DeletedSince	Datetime	True
ExcludeStripe	Boolean	True