Tableau Connector for Sage Business Cloud Accounting

Build 22.0.8342


Query LedgerEntries in Sage Business Cloud Accounting.

Table Specific Information

Query the available LedgerEntries


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'


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


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


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


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


The unique identifier for the item
FromDate Datetime
ToDate Datetime
TransactionTypeId String

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 22.0.8342