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