ビュー
ビューは、カラムと疑似カラムで構成されます。ビューは、データを示すという点でテーブルに似ていますが、ビューでは更新はサポートされません。通常、ビューとして表されるエンティティは、読み取り専用のエンティティです。多くの場合、これらのデータはストアドプロシージャを使用することで更新できます（その機能がデータソースに適用できる場合）。
ビューに対しては、通常のテーブルと同じようにクエリを実行でき、このときに返されるデータも同様です。
ビューとして公開されるクエリなどの動的ビューや、project_team ワークアイテムの特定の組み合わせを検索するためのビューがサポートされています。
CData Excel Add-In 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. |