Fusion Reference
Financials
Receivables, payables, and general-ledger journal records the supply-chain subledgers post into
9 tables
docs release 26C · Verified September 2026
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 ledgerProduct: 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 pointersProduct: 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 stripedProduct: 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 againstProduct: 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 readsProduct: 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 totalsProduct: 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 accountingProduct: 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 stripedProduct: 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 chargebacksProduct: RAtransaction