BankOpeningBalances
Query BankOpeningBalances in Sage Business Cloud Accounting.
Table Specific Information
Query the available BankOpeningBalances
Select
The driver uses the Sage Accounting API to process search criteria that refer to BankAccountId,UpdatedOrCreatedSince columns. The driver processes other filters client-side within the driver.
- BankAccountId supports the '=' operator.
- UpdatedOrCreatedSince supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM BankOpeningBalances WHERE BankAccountId = 'abc' SELECT * FROM BankOpeningBalances WHERE UpdatedOrCreatedSince = '2018-12-15'
Insert
INSERT INTO BankOpeningBalances (TransactionId, BankAccountId) VALUES ('2', '123')
Update
Updates are performed based on Id.
UPDATE BankOpeningBalances SET Date = '2018-12-15' WHERE Id = '123'
Delete
You must specify the Id of the BankOpeningBalances to delete it.
DELETE FROM BankOpeningBalances 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 | Datetime | True |
The date of the opening balance | |
| Credit | String | False |
The credit amount of the opening balance | |
| BankAccountId | String | False |
BankAccounts.Id |
The unique identifier for the item |
| UpdatedAt | Datetime | True |
The datetime when the item was last updated | |
| LegacyId | Int | False |
The legacy ID for the item | |
| Debit | String | False |
The debit amount of the opening balance |