Excel Add-In for Oracle Fusion Cloud Financials

Build 24.0.9111

テーブル

本製品 はOracle Fusion Cloud Financials のデータを、標準のSQL ステートメントを使用してクエリできるリレーショナルデータベースのテーブルのリストとしてモデル化します。

CData Excel Add-In for Oracle Fusion Cloud Financials テーブル

Name Description
ExpenseReports The expense reports resource contains information about an expense report.
Expenses The expenses resource is a parent resource that contains all the expense information incurred by an employee.
Invoices The payables invoices resource is used to manage details about supplier invoices, that includes header, lines, distributions, installments, descriptive flexfields, global descriptive flexfields, and attachments. Note: You can only update certain attributes and the update applies only to those attributes. Related fields don't automatically get populated. In summary, the cascade defaulting doesn't automatically happen and you must review and update the dependent attributes. For example, when you update the invoice date in the Create or Edit Invoice pages, related fields, such as the terms date or due date, may be autopopulated based on the invoice date you enter. Using REST API, the invoice date is updated, but the related fields aren't autopopulated. Before updating a key attribute, consider the impact on the related attributes.
InvoicesinvoiceDff The payables invoices descriptive flexfields resource is used to manage details about the descriptive flexfield references for an invoice.
InvoicesinvoiceInstallments The payables invoice installments resource is used to manage details about the payment due dates, amounts, and other payment information. An invoice can have one or more installments.
InvoicesinvoiceLines The payables invoice lines resource is used to manage details about goods and services, which includes freight, and miscellaneous charges that can be allocated to item lines. It also captures details necessary for integration with applications, such as Oracle Fusion Assets.
InvoicesinvoiceLinesinvoiceDistributions The payables invoice distributions resource is used to manage details that are used to create accounting entries, and includes information, such as accounting date, distribution combinations, and the details necessary for integration with applications, such as Oracle Fusion Assets.
ReceivablesCreditMemos The receivables credit memos resource is used to get and find a receivables credit memo.
ReceivablesInvoices The receivables invoices resource is used to create, get, update, and delete a receivables invoice.
StandardReceipts The standard receipts resource is used to create standard receipts in Receivables to record payment from customers for goods received or services rendered.
TaxRegistrations The tax registrations resource is used to query, update, and create tax registrations.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9111