LedgerEntries
Query LedgerEntries in Sage Business Cloud Accounting.
Table Specific Information
Query the available LedgerEntries
Select
The driver uses the Sage Accounting API to process search criteria that refer to TransactionId,LedgerAccountId,JournalCodeId,FromDate,ToDate,TransactionTypeId,UpdatedOrCreatedSince columns. The driver processes other filters client-side within the driver.
- TransactionId supports the '=' operator.
- LedgerAccountId supports the '=' operator.
- JournalCodeId supports the '=' operator.
- FromDate supports the '=' operator.
- ToDate supports the '=' operator.
- TransactionTypeId supports the '=' operator.
- UpdatedOrCreatedSince supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM LedgerEntries WHERE TransactionId = 'abc' SELECT * FROM LedgerEntries WHERE LedgerAccountId = 'abc' SELECT * FROM LedgerEntries WHERE JournalCodeId = 'abc' SELECT * FROM LedgerEntries WHERE FromDate = '2018-12-15' SELECT * FROM LedgerEntries WHERE ToDate = '2018-12-15' SELECT * FROM LedgerEntries WHERE TransactionTypeId = 'abc' SELECT * FROM LedgerEntries WHERE UpdatedOrCreatedSince = '2018-12-15'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier for the item | |
| CreatedAt | Datetime | The datetime when the item was created | |
| DisplayedAs | String | The name of the resource | |
| Deleted | Bool | Indicates whether the ledger entry has been deleted or not | |
| TransactionId | String |
Transactions.Id | The unique identifier for the item |
| Date | Datetime | The date of the ledger entry | |
| Credit | String | The credit amount of the ledger entry | |
| LedgerAccountId | String | The unique identifier for the item | |
| ContactId | String |
Contacts.Id | The unique identifier for the item |
| LinksAggregate | String | Links for the resource | |
| UpdatedAt | Datetime | The datetime when the item was last updated | |
| LegacyId | Int | The legacy ID for the item | |
| Debit | String | The debit amount of the ledger entry | |
| TaxRateId | String |
TaxRates.Id | The unique identifier for the item |
| ComponentTaxRatesAggregate | String | The component tax rates which make up a combined rate | |
| Description | String | The ledger entry description | |
| JournalCodeId | String |
JournalCodes.Id | The unique identifier for the item |
| FromDate | Datetime | ||
| ToDate | Datetime | ||
| TransactionTypeId | String |