LedgerAccountOpeningBalances
Query LedgerAccountOpeningBalances in Sage Business Cloud Accounting.
Table Specific Information
Query the available LedgerAccountOpeningBalances
Select
The driver uses the Sage Accounting API to process search criteria that refer to UpdatedOrCreatedSince column. The driver processes other filters client-side within the driver.
- UpdatedOrCreatedSince supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM LedgerAccountOpeningBalances WHERE UpdatedOrCreatedSince = '2018-12-15'
Update
Updates are performed based on Id.
UPDATE LedgerAccountOpeningBalances SET Details = 'abc' WHERE Id = '123'
Delete
You must specify the Id of the LedgerAccountOpeningBalances to delete it.
DELETE FROM LedgerAccountOpeningBalances 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 | |
Details | String | False |
A description of the opening balance | |
DisplayedAs | String | False |
The name of the resource | |
Credit | String | False |
The credit amount of the opening balance | |
LedgerAccountId | String | False |
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 |