SSIS Components for Sage Business Cloud Accounting

Build 22.0.8509


Query LedgerAccountClassifications in Sage Business Cloud Accounting.

Table Specific Information

Query the available LedgerAccountClassifications


The driver uses the Sage Accounting API to process search criteria that refer to LedgerAccountTypeId column. The driver processes other filters client-side within the driver.

  • LedgerAccountTypeId supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM LedgerAccountClassifications WHERE LedgerAccountTypeId='abc'


Name Type References Description
Id [KEY] String The unique identifier for the item
DisplayedAs String The name of the resource
LegacyId Int The legacy ID for the item
LedgerAccountTypeId String

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