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 |