OpeningBalanceJournals
Query OpeningBalanceJournals in Sage Business Cloud Accounting.
Table Specific Information
Query the available OpeningBalanceJournals
Select
The driver processes all filters client-side within the driver.
Insert
- Insert a journal with aggregate value.
INSERT INTO [OpeningBalanceJournals] ( BaseJournalLineAggregate, date, reference) VALUES ('{"ledger_account_id": "1fcc2765741311ea8d3c022ace1a91e2","debit": 12,"credit": 0,"details": "details","tax_reconciled": true,"cleared": true,"bank_reconciled": true},{"ledger_account_id": "1fcc2765741311ea8d3c022ace1a91e2","debit": 0,"credit": 12,"details": "details","tax_reconciled": true,"cleared": true,"bank_reconciled": true}', '2019-07-12', 'Journal Reference')
- Insert a journal using temp tables.
INSERT INTO [JournalLineItemsAggregate#TEMP] (credit, debit, details, ledgerAccountId) VALUES ('10', '0', 'details1', '6035f3d39d7511e9a2b70e070fead9d0') INSERT INTO [JournalLineItemsAggregate#TEMP] (credit, debit, details, ledgerAccountId) VALUES ('0', '10', 'details2', '6035f3d39d7511e9a2b70e070fead9d0') INSERT INTO [OpeningBalanceJournals] (BaseJournalLineAggregate, date, reference) VALUES ('JournalLineItemsAggregate#TEMP', '2019-07-12', 'Reference2')
Delete
You must specify the Id of the OpeningBalanceJournals to delete it.
DELETE FROM OpeningBalanceJournals 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 | |
BaseJournalLineAggregate | String | False |
The journal lines | |
TransactionTypeId | String | False |
The unique identifier for the item | |
TransactionId | String | False |
Transactions.Id |
The unique identifier for the item |
Date | Datetime | True |
The date of the opening balance journal | |
Reference | String | False |
A reference for the opening balance journal | |
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 |