JDBC Driver for Sage Business Cloud Accounting

Build 22.0.8462

CoaTemplates

Query CoaTemplates in Sage Business Cloud Accounting.

Table Specific Information

Query the available CoaTemplates

Select

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

  • CountryId supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM CoaTemplates WHERE CountryId='AF'

Columns

Name Type References Description
Id [KEY] String The unique identifier for the item
UpdatedAt Datetime The datetime when the item was last updated
Name String The name for the COA template
DisplayedAs String The name of the resource
CreatedAt Datetime The datetime when the item was created
CountryId String

Countries.Id

The unique identifier for the item
LegacyId Int The legacy ID for the item

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