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. |