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 使用できる値は次のとおりです。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 |
The unique identifier for the item | |
Deletable | Bool | False |
Indicates whether or not the bank account can be deleted | |
LedgerAccountId | String | False |
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 |