CData Python Connector for Sage Business Cloud Accounting

Build 22.0.8479

ビュー

ビューは、カラムと疑似カラムで構成されます。ビューは、データを示すという点でテーブルに似ていますが、ビューでは更新はサポートされません。通常、ビューとして表されるエンティティは、読み取り専用のエンティティです。多くの場合、これらのデータはストアドプロシージャを使用することで更新できます(その機能がデータソースに適用できる場合)。

ビューに対しては、通常のテーブルと同じようにクエリを実行でき、このときに返されるデータも同様です。

ビューとして公開されるクエリなどの動的ビューや、project_team ワークアイテムの特定の組み合わせを検索するためのビューがサポートされています。

CData Python Connector for Sage Business Cloud Accounting ビュー

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.8479