Fusion Reference

Financials

Receivables, payables, and general-ledger journal records the supply-chain subledgers post into

9 tables

Extraction map

The BICC extract data store (PVO) reaching each of this module’s tables — the bulk path out of the SaaS database. Full details, OTBI subject areas, and provenance links live on each table page.

Table	BICC extract data store (PVO)
AP_INVOICE_DISTRIBUTIONS_ALL	FscmTopModelAM.FinExtractAM.ApBiccExtractAM.InvoiceDistributionExtractPVO
AP_INVOICE_LINES_ALL	FscmTopModelAM.FinExtractAM.ApBiccExtractAM.InvoiceLineExtractPVO
AP_INVOICES_ALL	FscmTopModelAM.FinExtractAM.ApBiccExtractAM.InvoiceHeaderExtractPVO
AR_CASH_RECEIPTS_ALL	FscmTopModelAM.FinExtractAM.ArBiccExtractAM.ReceiptHeaderExtractPVO
AR_PAYMENT_SCHEDULES_ALL	FscmTopModelAM.FinExtractAM.ArBiccExtractAM.PaymentScheduleExtractPVO
GL_JE_HEADERS	FscmTopModelAM.FinExtractAM.GlBiccExtractAM.JournalHeaderExtractPVO
GL_JE_LINES	FscmTopModelAM.FinExtractAM.GlBiccExtractAM.JournalLineExtractPVO
RA_CUSTOMER_TRX_ALL	FscmTopModelAM.FinExtractAM.ArBiccExtractAM.TransactionHeaderExtractPVO
RA_CUSTOMER_TRX_LINES_ALL	FscmTopModelAM.FinExtractAM.ArBiccExtractAM.TransactionLineExtractPVO

Tables

Transaction · 9

AP_INVOICE_DISTRIBUTIONS_ALLPayables invoice distributions — the accounting grain under each line: one row per charged GL account with the amount, accounting date, period, and posted state; where AP spend meets the ledger
Product: APtransaction
AP_INVOICE_LINES_ALLPayables invoice lines — the goods/services, freight, tax, and prepayment rows under each invoice, carrying the amount, quantity, and the PO/receipt match pointers
Product: APtransaction
AP_INVOICES_ALLPayables invoice headers — one row per supplier invoice, prepayment, or credit/debit memo, with the supplier, invoice number, amounts, payment status, and approval state; business-unit striped
Product: APtransaction
AR_CASH_RECEIPTS_ALLCash receipts — one row per receipt entered, with receipt number, date, amount, status, and the paying customer account; the cash side that payment schedules apply against
Product: ARtransaction
AR_PAYMENT_SCHEDULES_ALLThe open-receivables ledger — one row per installment of every transaction and receipt, restated as amounts due, applied, and remaining; the table AR aging actually reads
Product: ARtransaction
GL_JE_HEADERSGeneral ledger journal headers — one row per journal within a batch, with the ledger, category, source, period, currency, posting status, and running debit/credit totals
Product: GLtransaction
GL_JE_LINESGeneral ledger journal lines — the debit/credit grain: one row per line with the account combination, entered and accounted amounts, effective date, and the drill-back link to subledger accounting
Product: GLtransaction
RA_CUSTOMER_TRX_ALLReceivables transaction headers — one row per invoice, credit memo, debit memo, or bill receivable, with the transaction number, type, dates, customer account and site-use pointers, and currency; business-unit striped
Product: RAtransaction
RA_CUSTOMER_TRX_LINES_ALLReceivables transaction lines — mixed row kinds under each transaction: LINE rows carry the goods/services amounts, TAX and FREIGHT rows attach to their parent line, CB rows carry chargebacks
Product: RAtransaction