Important Tables in Fusion Financials

There are many tables in each module of Oracle Fusion Financials. I have listed here a few important tables for your reference.

Accounts Payables

• AP_INVOICES_ALL contains records for invoices you enter. There is one row for each invoice youenter. An invoice can have one or more invoice distribution lines.
• AP_INVOICE_LINES_ALL contains records for invoice lines entered manually, generated automatically or imported from the Open Interface. An invoice can have one or more invoice lines.
• AP_INVOICES_INTERFACE stores header information about invoices that you create or load for import
• AP_TERMS_B stores header information about payment terms you define. You need one row for each type of terms you use to create scheduled payments for invoices.
• AP_PAYMENT_SCHEDULES_ALL contains information about scheduled payments for an invoice
• AP_DISTRIBUTION_SETS_ALL contains information about Distribution Sets you define to distribute invoices automatically.
• AP_INVOICE_DISTRIBUTIONS_ALL holds the distribution information that is manually entered or system-generated. There is one row for each invoice distribution. A distribution must be associated with an invoice.

Accounts Receivables

• RA_CUSTOMER_TRX_ALL:  This table helps to store the complete AR Invoice Header details. We can find the TRX_NUMBER, Transaction/Invoice Date, Customer , Customer Site, Payment Terms, Invoice Source, Invoice Transaction Type, Currency and many other header related information's.
• RA_CUSTOMER_TRX_LINES_ALL:  This table stores invoice, debit memo, and credit memo line level information. We can get the Invoice Line No, Item, Description, Qty, Unit Price, Accounted price. Here in this Table, We will get the separate Lines for the Each Tax line. If any invoice has 1 Line and two taxes applied to this Line. Then we will get three lines for this Invoice. One for Line and Two for Taxes.
• RA_CUST_TRX_LINE_SALESREPS_ALL:  This tables helps to store the Sales representative information's for the AR Invoice in Oracle Fusion. 
• RA_CUST_TRX_LINE_GL_DIST_ALL:  This table store the AR Invoice accounting information’s for each line of the AR Invoice. Here will get all the Accounting Information.
• AR_PAYMENT_SCHEDULES_ALL:  This table stores all transactions except adjustments and miscellaneous cash receipts. Oracle Receivables updates this table when activity occurs against an invoice, debit memo, chargeback, credit memo, on-account credit, or receipt.
• AR_RECEIVABLE_APPLICATIONS_ALL table stores all accounting entries for both your cash and credit memo applications. The APPLICATION_TYPE column stores either CASH or CM (for credit memo applications). Each row in this table includes the amount applied, status, and accounting flexfield information.

Cash Management

• CE_BANK_ACCOUNTS contains Legal Entity Level bank account information. Each bank account must be affiliated with one bank branch.
• CE_CHECKBOOKS contains information related to payment checkbook.
• CE_PAYMENT_DOCUMENTS contains information related to payment documents.
• CE_STATEMENT_LINES contains information about statement lines.
• CE_STMT_BALANCES contains information about statement balances.

General Ledger

• GL_BALANCES contains actual, budget, and encumbrance balances for detail and summary accounts. This table stores ledger currency, foreign currency, and statistical balances for each accounting period that has ever been opened.
• GL_DAILY_RATES contains the daily conversion rates for foreign currency transactions. It replaces the GL_DAILY_CONVERSION_RATES table.
• GL_INTERFACE contains journal entry batches through Journal Import.
• GL_JE_BATCHES contains journal entry batches. Each row includes the batch name, description, status, running total debits and credits, and other information.
• GL_JE_HEADERS contains journal entries. There is a one-to-many relationship between journal entry batches and journal entries
• GL_JE_LINES contains the journal entry lines that you enter in the Enter Journals form. There is a one-to-many relationship between journal entries and journal entry lines
• GL_JE_SOURCES_B contains journal entry sources. Each journal entry in your Oracle General Ledger application is assigned a source name to indicate how it was created.
• GL_LEDGERS contains information about the ledgers defined in the Accounting Setup Manager and the ledger sets defined in the Ledger Set form.
• GL_PERIODS contains information about the accounting periods that are defined using the Accounting Calendar form.

Fixed Assets

• FA_ADDITIONS_B contains descriptive information to help identify your assets.
• FA_ADJUSTMENTS stores information that Oracle Assets needs to create journal entries for transactions.
• FA_ASSET_INVOICES contains the invoice information from Oracle Fusion Payables and Oracle Fusion Purchasing for the assets to track the source asset information.
• FA_BOOKS contains the information needed for calculating depreciation. When you initially add an asset, Oracle Fusion Assets inserts one row into the table and that becomes the active row for the asset.
• FA_CATEGORIES_B stores information about your asset categories. This table provides default information when you add an asset.
• FA_DEPRN_DETAIL contains the depreciation amounts that the depreciation program charges to the depreciation expense account in each distribution line.
• FA_MASS_ADDITIONS stores information about assets that you want to automatically add to Oracle Assets from another system.