Tables
The driver models the data in Sage Business Cloud Accounting into a list of tables that can be queried using standard SQL statements.
Generally, querying Sage Business Cloud Accounting tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.
CData JDBC Driver 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. |