Tables
The driver models the data in Exact Online as a list of tables in a relational database that can be queried using standard SQL statements.
CData ODBC 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. |
BillOfMaterialRoutings | Use this endpoint to create, read, update and delete routings in a bill of material version linked to a make item. |
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. |
DropShipmentLines | To List, Create and Update DropShipmentLines. |
DropShipments | To List, Create and Update DropShipments. |
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. |
GLAccountClassificationMappings | Usage information for the operation GLAccountClassificationMappings.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. |
ProjectClassifications | ProjectClassifications |
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. |
PurchaseReturnLines | Use this endpoint to create a new purchase return line, retrieve an existing purchase return line and update an existing purchase return line |
QuotationLines | Usage information for the operation QuotationLines.rsd. |
QuotationOrderChargeLines | Use this endpoint to create, read, update and delete quotation's order charge lines. |
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. |
SalesInvoiceOrderChargeLines | Use this endpoint to create, read, update and delete sales invoice shipping cost and order charge lines. |
SalesInvoices | Usage information for the operation SalesInvoices.rsd. |
SalesItemPrices | Usage information for the operation SalesItemPrices.rsd. |
SalesOrderHeaders | Usage information for the operation SalesOrderHeaders.rsd. |
SalesOrderID | Usage information for the operation SalesOrderID.rsd. |
SalesOrderLines | Usage information for the operation SalesOrderLines.rsd. |
SalesOrderOrderChargeLines | Use this endpoint to create, read, update and delete sales order shipping cost and order charge lines. |
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. |