Financials Data Model
In the Financials Data Model schema, the add-in models information such as expenses, invoices, and receivables associated with the authenticated account as an easy-to-use SQL database. Live connectivity to these objects means that any changes to your Oracle Fusion Cloud Financials account are immediately reflected in the add-in.
Tables
The Tables section, which details standard SQL tables, and the Views section, which lists read-only SQL tables, contain samples of what you might have access to in your Oracle Fusion Cloud Financials account.
Common tables include:
| Table | Description |
| 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. |
Stored Procedures
Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including cancelling invoices and creating expense reports.