テーブル
本製品 はExact Online のデータを、標準のSQL ステートメントを使用してクエリできるリレーショナルデータベースのテーブルのリストとしてモデル化します。
CData Power BI Connector for Exact Online テーブル
| 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. |