Tables
The provider models the data in Exact Online as a list of tables in a relational database that can be queried using standard SQL statements.
CData ADO.NET Provider for Exact Online Tables
| Name | Description |
| 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. |
| AssemblyBillOfMaterialHeader | To create, read, update and delete item bill of material's header |
| AssemblyBillOfMaterialMaterials | To create, read, update and delete item bill of materials. |
| 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. |
| EmployeeRestrictionItems | Use this endpoint to create, read, update and delete employee restriction items. Restriction items limit the hour types that an employee can use in time entries. |
| Events | Usage information for the operation Events.rsd. |
| ExchangeRates | Usage information for the operation ExchangeRates.rsd. |
| ExpenseReports | Use this endpoint to create, read, update and delete expense reports. Expense reports contain data on employee cost claims, including submission status, approval workflows, and monetary amounts. |
| Expenses | Use this endpoint to create, read, update and delete individual expense entries. Supports receipt, mileage, and per diem expense types with details on amounts, currencies, projects, and approval workflow. |
| 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. |
| 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. |
| OfficialReturns | This service is only to be used in Spain. Use this endpoint to create and retrieve official financial returns submitted to Spanish tax authorities, including period, frequency, amount, and document details. |
| 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. |
| 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 |
| PurchaseReturns | Use this endpoint to create, read, and update purchase returns. A purchase return must include one or more purchase return lines and a return date. |
| 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. |
| SalesChannels | Use this endpoint to create, read, update and delete sales channels. This endpoint allows you to manage the basic information of a sales channel. |
| 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. |
| 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. |
| TimedTimeTransactions | Use this endpoint to start, stop, and delete timed time transactions for shop order operations. Tracks labor hours, machine hours, and production metrics for manufacturing shop floor activities. |
| TimeTransactions | Usage information for the operation TimeTransactions.rsd. |
| VariableMutations | Use this endpoint to create, read, update and delete variable payroll mutation entries for employees. Variable mutations represent adjustments to payroll components for a specific payroll period and year. |
| VATCodes | Usage information for the operation VATCodes.rsd. |
| Warehouses | Usage information for the operation Warehouses.rsd. |
| WebhookSubscriptions | Use this endpoint to subscribe your app to one or more webhook topics. Configure a callback URL to receive notifications when subscribed topics trigger events. |
| Workcenters | Usage information for the operation Workcenters.rsd. |