JDBC Driver for Exact Online

Build 22.0.8462

Tables

The driver models the data in Exact Online into a list of tables that can be queried using standard SQL statements.

Generally, querying Exact Online 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 Exact Online Tables

Name Description
AcceptQuotation Usage information for the operation AcceptQuotation.rsd.
AccountInvolvedAccounts Usage information for the operation AccountInvolvedAccounts.rsd.
AccountOwners Usage information for the operation AccountOwners.rsd.
Accounts Usage information for the operation Accounts.rsd.
Addresses Usage information for the operation Addresses.rsd.
BankAccounts Usage information for the operation BankAccounts.rsd.
BankEntries Usage information for the operation BankEntries.rsd.
BankEntryLines Usage information for the operation BankEntryLines.rsd.
ByProductReceipts Usage information for the operation ByProductReceipts.rsd.
ByProductReversals Usage information for the operation ByProductReversals.rsd.
CashEntries Usage information for the operation CashEntries.rsd.
CashEntryLines Usage information for the operation CashEntryLines.rsd.
CommunicationNotes Usage information for the operation CommunicationNotes.rsd.
Complaints Usage information for the operation Complaints.rsd.
Contacts Usage information for the operation Contacts.rsd.
Costcenters Usage information for the operation Costcenters.rsd.
CostTransactions Usage information for the operation CostTransactions.rsd.
Costunits Usage information for the operation Costunits.rsd.
DepreciationMethods Usage information for the operation DepreciationMethods.rsd.
DirectDebitMandates Usage information for the operation DirectDebitMandates.rsd.
DocumentAttachments Usage information for the operation DocumentAttachments.rsd.
DocumentFolders Usage information for the operation DocumentFolders.rsd.
Documents Usage information for the operation Documents.rsd.
DocumentTypeFolders Usage information for the operation DocumentTypeFolders.rsd.
Events Usage information for the operation Events.rsd.
ExchangeRates Usage information for the operation ExchangeRates.rsd.
GeneralJournalEntries Usage information for the operation GeneralJournalEntries.rsd.
GeneralJournalEntryLines Usage information for the operation GeneralJournalEntryLines.rsd.
GLAccounts Usage information for the operation GLAccounts.rsd.
GoodsDeliveries Usage information for the operation GoodsDeliveries.rsd.
GoodsDeliveryLines Usage information for the operation GoodsDeliveryLines.rsd.
GoodsReceiptLines Usage information for the operation GoodsReceiptLines.rsd.
GoodsReceipts Usage information for the operation GoodsReceipts.rsd.
InvoiceSalesOrders Usage information for the operation InvoiceSalesOrders.rsd.
InvoiceTerms Usage information for the operation InvoiceTerms.rsd.
InvolvedUserRoles Usage information for the operation InvolvedUserRoles.rsd.
InvolvedUsers Usage information for the operation InvolvedUsers.rsd.
Items Usage information for the operation Items.rsd.
ItemWarehouses Usage information for the operation ItemWarehouses.rsd.
Journals Usage information for the operation Journals.rsd.
Mailboxes Usage information for the operation Mailboxes.rsd.
MailMessageAttachments Usage information for the operation MailMessageAttachments.rsd.
MailMessages Usage information for the operation MailMessages.rsd.
MailMessagesSent Usage information for the operation MailMessagesSent.rsd.
MaterialIssues Usage information for the operation MaterialIssues.rsd.
MaterialReversals Usage information for the operation MaterialReversals.rsd.
OperationResources Usage information for the operation OperationResources.rsd.
Operations Usage information for the operation Operations.rsd.
Opportunities Usage information for the operation Opportunities.rsd.
PaymentConditions Usage information for the operation PaymentConditions.rsd.
PrintedSalesInvoices Usage information for the operation PrintedSalesInvoices.rsd.
PrintedSalesOrders Usage information for the operation PrintedSalesOrders.rsd.
PrintQuotation Usage information for the operation PrintQuotation.rsd.
ProcessPayments Usage information for the operation ProcessPayments.rsd.
ProcessStockCount Usage information for the operation ProcessStockCount.rsd.
ProductionAreas Usage information for the operation ProductionAreas.rsd.
ProjectHourBudgets Usage information for the operation ProjectHourBudgets.rsd.
ProjectPlanning Usage information for the operation ProjectPlanning.rsd.
ProjectPlanningRecurring Usage information for the operation ProjectPlanningRecurring.rsd.
ProjectRestrictionEmployees Usage information for the operation ProjectRestrictionEmployees.rsd.
ProjectRestrictionItems Usage information for the operation ProjectRestrictionItems.rsd.
ProjectRestrictionRebillings Usage information for the operation ProjectRestrictionRebillings.rsd.
Projects Usage information for the operation Projects.rsd.
ProjectTimeTransactions Usage information for the operation ProjectTimeTransactions.rsd.
PurchaseEntries Usage information for the operation PurchaseEntries.rsd.
PurchaseEntryLines Usage information for the operation PurchaseEntryLines.rsd.
PurchaseInvoiceLines Usage information for the operation PurchaseInvoiceLines.rsd.
PurchaseInvoices Usage information for the operation PurchaseInvoices.rsd.
QuotationLines Usage information for the operation QuotationLines.rsd.
Quotations Usage information for the operation Quotations.rsd.
RejectQuotation Usage information for the operation RejectQuotation.rsd.
ReopenQuotation Usage information for the operation ReopenQuotation.rsd.
ReviewQuotation Usage information for the operation ReviewQuotation.rsd.
SalesEntries Usage information for the operation SalesEntries.rsd.
SalesEntryLines Usage information for the operation SalesEntryLines.rsd.
SalesInvoiceLines Usage information for the operation SalesInvoiceLines.rsd.
SalesInvoices Usage information for the operation SalesInvoices.rsd.
SalesItemPrices Usage information for the operation SalesItemPrices.rsd.
SalesOrderHeaders null
SalesOrderID Usage information for the operation SalesOrderID.rsd.
SalesOrderLines Usage information for the operation SalesOrderLines.rsd.
SalesOrders Usage information for the operation SalesOrders.rsd.
ServiceRequests Usage information for the operation ServiceRequests.rsd.
ShopOrderMaterialPlans Usage information for the operation ShopOrderMaterialPlans.rsd.
ShopOrderReceipts Usage information for the operation ShopOrderReceipts.rsd.
ShopOrderReversals Usage information for the operation ShopOrderReversals.rsd.
ShopOrderRoutingStepPlans Usage information for the operation ShopOrderRoutingStepPlans.rsd.
ShopOrders Usage information for the operation ShopOrders.rsd.
SolutionLinks Usage information for the operation SolutionLinks.rsd.
StockCountLines Usage information for the operation StockCountLines.rsd.
StockCounts Usage information for the operation StockCounts.rsd.
SubOrderReceipts Usage information for the operation SubOrderReceipts.rsd.
SubOrderReversals Usage information for the operation SubOrderReversals.rsd.
SubscriptionLines Usage information for the operation SubscriptionLines.rsd.
SubscriptionRestrictionEmployees Usage information for the operation SubscriptionRestrictionEmployees.rsd.
SubscriptionRestrictionItems Usage information for the operation SubscriptionRestrictionItems.rsd.
Subscriptions Usage information for the operation Subscriptions.rsd.
SupplierItem Usage information for the operation SupplierItem.rsd.
Tasks Usage information for the operation Tasks.rsd.
TaskTypes Usage information for the operation TaskTypes.rsd.
TimeCorrections Usage information for the operation TimeCorrections.rsd.
TimeTransactions Usage information for the operation TimeTransactions.rsd.
VATCodes Usage information for the operation VATCodes.rsd.
Warehouses Usage information for the operation Warehouses.rsd.
Workcenters Usage information for the operation Workcenters.rsd.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462