MuleSoft Connector for Sage Business Cloud Accounting

Build 21.0.7930

Tables

The connector 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 MuleSoft 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.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930