ADO.NET Provider for Sage Business Cloud Accounting

Build 22.0.8479

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

使用できる値は次のとおりです。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

LedgerAccountClassifications.Id

The unique identifier for the item
TaxRateId String

TaxRates.Id

The unique identifier for the item
CoaTemplateId String

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