JDBC Driver for Sage Business Cloud Accounting

Build 22.0.8462

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

LedgerAccounts.Id

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462