JDBC Driver for Sage Business Cloud Accounting

Build 22.0.8479

テーブル

本製品 はSage Business Cloud Accounting のデータを、標準のSQL ステートメントを使用してクエリできるテーブルのリストにモデル化します。

一般的には、Sage Business Cloud Accounting テーブルのクエリは、リレーショナルデータベースのテーブルのクエリと同じです。時には特別なケースもあります。例えば、テーブルの特定のカラムデータを取得するために特定のカラムをWHERE 句に含める必要がある場合などです。これは通常、特定のカラムを取得するために行ごとに個別のリクエストを行う必要がある場合に必要です。これらの特別な状況は、以下にリンクされているテーブルページの上部に明確に文書化されています。

CData JDBC Driver for Sage Business Cloud Accounting テーブル

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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479