Views
Views are similar to tables in the way that data is represented; however, views are read-only.
Queries can be executed against a view as if it were a normal table.
CData Tableau Connector 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. |