CoaAccounts
Query CoaAccounts in Sage Business Cloud Accounting.
Table Specific Information
Query the available CoaAccounts
Select
The driver uses the Sage Accounting API to process search criteria that refer to CoaTemplateId column. The driver processes other filters client-side within the driver.
- CoaTemplateId supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM CoaAccounts WHERE CoaTemplateId='SMALL_BUSINESS_GB'
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 | |
| FixedTaxRate | Bool | Indicates whether the default tax rate is fixed or may be changed | |
| Name | String | The name for the COA account | |
| LedgerAccountTypeId | String | The unique identifier for the item
The allowed values are SALES, OTHER_INCOME, DIRECT_EXPENSES, OVERHEADS, DEPRECIATION, CURRENT_ASSETS, FIXED_ASSETS, FUTURE_ASSETS, BANK, CURRENT_LIABILITY, FUTURE_LIABILITY, v, LINE_OF_CREDIT. | |
| LedgerAccountGroupDisplayedAs | String | The name of the resource | |
| LedgerAccountGroupLegacyId | Int | The legacy ID for the item | |
| LedgerAccountGroupId | String | The unique identifier for the item | |
| NominalCode | Int | The nominal code of the COA account | |
| UpdatedAt | Datetime | The datetime when the item was last updated | |
| LegacyId | Int | The legacy ID for the item | |
| ControlName | String | The system control name for the COA account | |
| LedgerAccountClassificationId | String | The unique identifier for the item | |
| TaxRateId | String |
TaxRates.Id | The unique identifier for the item |
| CoaTemplateId | String |