JDBC Driver for Sage Business Cloud Accounting

Build 22.0.8462

Views

Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.

Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.

Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.

CData JDBC Driver for Sage Business Cloud Accounting Views

Name Description
AddressRegions Query AddressRegions in Sage Business Cloud Accounting.
ArtefactStatuses Query ArtefactStatuses in Sage Business Cloud Accounting.
BaseJournalLine Query BaseJournalLine in Sage Business Cloud Accounting.
BusinessActivityTypes Query BusinessActivityTypes in Sage Business Cloud Accounting.
Businesses Query Businesses in Sage Business Cloud Accounting.
BusinessSettings Query BusinessSettings in Sage Business Cloud Accounting.
CoaAccounts Query CoaAccounts in Sage Business Cloud Accounting.
CoaTemplates Query CoaTemplates in Sage Business Cloud Accounting.
CorrectiveReasonCodes Query CorrectiveReasonCodes in Sage Business Cloud Accounting.
Countries Query Countries in Sage Business Cloud Accounting.
CountryGroups Query CountryGroups in Sage Business Cloud Accounting.
CountryOfRegistrations Query CountryOfRegistrations in Sage Business Cloud Accounting.
Currencies Query Currencies in Sage Business Cloud Accounting.
EuSalesDescriptions Query EuSalesDescriptions in Sage Business Cloud Accounting.
ExchangeRates Query ExchangeRates in Sage Business Cloud Accounting.
JournalLine Query JournalLine in Sage Business Cloud Accounting.
LedgerAccountClassifications Query LedgerAccountClassifications in Sage Business Cloud Accounting.
LedgerEntries Query LedgerEntries in Sage Business Cloud Accounting.
LiveExchangeRates Query LiveExchangeRates in Sage Business Cloud Accounting.
OtherPaymentLineItem Query OtherPaymentLineItem in Sage Business Cloud Accounting.
PaymentMethods Query PaymentMethods in Sage Business Cloud Accounting.
PurchaseCorrectiveInvoice Query PurchaseCorrectiveInvoice in Sage Business Cloud Accounting.
PurchaseCreditNoteLineItem Query PurchaseCreditNoteLineItem in Sage Business Cloud Accounting.
PurchaseInvoiceLineItem Query PurchaseInvoiceLineItem in Sage Business Cloud Accounting.
SalesCorrectiveInvoice Query SalesCorrectiveInvoice in Sage Business Cloud Accounting.
SalesCreditNoteLineItem Query SalesCreditNoteLineItem in Sage Business Cloud Accounting.
SalesQuoteLineItem Query SalesEstimatesQuoteLineItem in Sage Business Cloud Accounting.
SalesInvoiceLineItem Query SalesInvoiceLineItem in Sage Business Cloud Accounting.
SalesQuoteLineItem Query SalesQuoteLineItem in Sage Business Cloud Accounting.
TaxOffices Query TaxOffices in Sage Business Cloud Accounting.
TaxReturnFrequencies Query TaxReturnFrequencies in Sage Business Cloud Accounting.
TaxSchemes Query TaxSchemes in Sage Business Cloud Accounting.
Transactions Query Transactions in Sage Business Cloud Accounting.
TransactionTypes Query TransactionTypes in Sage Business Cloud Accounting.
UnallocatedArtefacts Query UnallocatedArtefacts in Sage Business Cloud Accounting.

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