Financials Data Model
In the Financials Data Model schema, the connector 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 connector.
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.