Tables
The connector models the data in Sage Business Cloud Accounting as a list of tables in a relational database that can be queried using standard SQL statements.
CData Power BI Connector for Sage Business Cloud Accounting Tables
| Name | Description |
| Addresses | Query Addresses in Sage Business Cloud Accounting. |
| Attachments | Query Attachments in Sage Business Cloud Accounting. |
| BankAccounts | Query BankAccounts in Sage Business Cloud Accounting. |
| BankDeposits | Query BankDeposits in Sage Business Cloud Accounting. |
| BankOpeningBalances | Query BankOpeningBalances in Sage Business Cloud Accounting. |
| BankReconciliations | Query BankReconciliations in Sage Business Cloud Accounting. |
| BankTransfers | Query BankTransfers in Sage Business Cloud Accounting. |
| BusinessExchangeRates | Query BusinessExchangeRates in Sage Business Cloud Accounting. |
| ContactAllocations | Query ContactAllocations in Sage Business Cloud Accounting. |
| ContactOpeningBalances | Query ContactOpeningBalances in Sage Business Cloud Accounting. |
| ContactPayments | Query ContactPayments in Sage Business Cloud Accounting. |
| ContactPeople | Query ContactPeople in Sage Business Cloud Accounting. |
| Contacts | Query Contacts in Sage Business Cloud Accounting. |
| DatevSettings | Query DatevSettings in Sage Business Cloud Accounting. |
| EmailSettings | Query EmailSettings in Sage Business Cloud Accounting. |
| FinancialSettings | Query FinancialSettings in Sage Business Cloud Accounting. |
| HostedArtefactPaymentSettings | Query HostedArtefactPaymentSettings in Sage Business Cloud Accounting. |
| InvoiceSettings | Query InvoiceSettings in Sage Business Cloud Accounting. |
| JournalCodes | Query JournalCodes in Sage Business Cloud Accounting. |
| Journals | Query Journals in Sage Business Cloud Accounting. |
| LedgerAccountOpeningBalances | Query LedgerAccountOpeningBalances in Sage Business Cloud Accounting. |
| LedgerAccounts | Query LedgerAccounts in Sage Business Cloud Accounting. |
| MigrationTaxReturns | Query MigrationTaxReturns in Sage Business Cloud Accounting. |
| OpeningBalanceJournals | Query OpeningBalanceJournals in Sage Business Cloud Accounting. |
| OtherPayments | Query OtherPayments in Sage Business Cloud Accounting. |
| Products | Query Products in Sage Business Cloud Accounting. |
| ProductSalesPriceTypes | Query ProductSalesPriceTypes in Sage Business Cloud Accounting. |
| PurchaseCreditNotes | Query PurchaseCreditNotes in Sage Business Cloud Accounting. |
| PurchaseInvoices | Query PurchaseInvoices in Sage Business Cloud Accounting. |
| PurchaseQuickEntries | Query PurchaseQuickEntries in Sage Business Cloud Accounting. |
| SalesCreditNotes | Query SalesCreditNotes in Sage Business Cloud Accounting. |
| SalesEstimates | Query SalesEstimates in Sage Business Cloud Accounting. |
| SalesInvoices | Query SalesInvoices in Sage Business Cloud Accounting. |
| SalesQuickEntries | Query SalesQuickEntries in Sage Business Cloud Accounting. |
| SalesQuotes | Query SalesQuotes in Sage Business Cloud Accounting. |
| Services | Query Services in Sage Business Cloud Accounting. |
| StockItems | Query StockItems in Sage Business Cloud Accounting. |
| StockMovements | Query StockMovements in Sage Business Cloud Accounting. |
| TaxProfiles | Query TaxProfiles in Sage Business Cloud Accounting. |
| TaxRates | Query TaxRates in Sage Business Cloud Accounting. |