Financials データモデル
Financials データモデルスキーマでは、本製品 は認証されたアカウントに関連する経費、請求書、売掛管理などの情報を、使いやすいSQL データベースとしてモデル化します。これらのオブジェクトへのライブ接続により、Oracle Fusion Cloud Financials アカウントへのあらゆる変更は本製品 に即座に反映されます。
テーブル
テーブル セクションには標準SQL テーブルの詳細が、ビュー セクションには読み取り専用SQL テーブルの一覧が記載されています。これらには、Oracle Fusion Cloud Financials アカウントでのアクセスを想定したサンプルが含まれています。
一般的なテーブルには以下のものが含まれます。
| テーブル | 説明 |
| Invoices | Manages key supplier invoice data, including header, lines, distributions, installments, and descriptive flexfields for payables processing. |
| InvoicesinvoiceLines | Captures goods, services, freight, and miscellaneous charges at the invoice line level, forming the basis for accounting entries. |
| InvoicesinvoiceLinesinvoiceDistributions | Creates distribution records per invoice line, detailing account numbers, distribution dates, and expense allocations. |
| ReceivablesInvoices | Controls the creation, retrieval, and management of receivables invoices, streamlining billing and revenue tracking. |
| ReceivablesCreditMemos | Manages credit memo records in Receivables, including creation, retrieval, and referencing for financial adjustments. |
| StandardReceipts | Tracks standard incoming payments (for example, checks, wire transfers), mapping them to customer accounts for settlement. |
| ExpenseReports | Contains header-level details for expense reports, such as total cost, status, and submission date for auditing and payment tracking. |
| Expenses | Acts as the master resource for all incurred expenses by employees, centralizing data for reporting and approvals. |
| ExpenseDistributions | Shows how an expense item’s cost is allocated across multiple accounts or cost centers, ensuring financial accuracy. |
| ExpenseCashAdvances | Tracks employee cash advances for travel or business-related expenses, capturing key data such as status, requested amounts, and repayment details. |
| PaymentsExternalPayees | Defines external payees (for example, suppliers, vendors) for payments, enabling creation and modification of payee records. |
| ExternalBankAccounts | Stores external bank account details for payments or reimbursements, supporting account creation, modifications, and usage tracking. |
| CurrencyRates | Retrieves currency exchange rates for specified dates and currency pairs, informing multi-currency postings and reports. |
| AccountingPeriodsLOV | Lists period details (for example, open, closed) within a specified accounting calendar, aiding period-based reporting and reconciliation. |
| ChartOfAccountsLOV | Outlines details of a chart of accounts structure, including segments and hierarchies for robust financial tracking. |
| LedgersLOV | Task-related data, including project and customer information, task status, and budget/actual quantities. |
| TaxRegistrations | Controls creation and updates of tax registrations, linking registered entities to corresponding tax codes and authorities. |
| PayablesPaymentTerms | Defines the rules (for example, net 30, net 60) for paying a supplier, setting installment schedules and discount opportunities. |
| ReceivablesAdjustments | Allows modification of existing invoices, credit memos, or other transactions, adjusting charges, freight, taxes, or lines. |
| TransactionTaxLines | Allows the creation, retrieval, and modification of manual tax lines for a transaction, ensuring accurate tax posting. |
ストアドプロシージャ
ストアドプロシージャ は、SQLクエリを介して呼び出されるアクションです。標準的なCRUD 操作だけでなく、請求書のキャンセルや経費報告書の作成など、より高度なタスクも実行します。