EBS Reference
Financials
Receivables, payables, and general-ledger journal records the supply-chain subledgers post into
9 tables
Tables
Transaction · 9
- AP_INVOICE_DISTRIBUTIONS_ALLSupplier invoice distributions — one row per GL-account allocation of an invoice line; the spend-to-account grain payables accounting posts fromSchema: APtransaction
- AP_INVOICE_LINES_ALLSupplier invoice lines — the R12-new layer between header and distributions, carrying line type, amount, and the purchase-order and receipt matching referencesSchema: APtransaction
- AP_INVOICES_ALLSupplier invoice headers — standard invoices, credit/debit memos, prepayments, and expense reports share the table by type, with amounts, payment status, and the liability accountSchema: APtransaction
- AR_CASH_RECEIPTS_ALLCash receipts — one row per customer or miscellaneous receipt with amount, date, status, and reversal detail; application detail against invoices lives in companion tablesSchema: ARtransaction
- AR_PAYMENT_SCHEDULES_ALLThe open-receivables engine — one row per transaction installment AND one row per receipt, carrying original and remaining amounts, due date, and closure state; what aging, DSO, and collections analytics readSchema: ARtransaction
- GL_JE_HEADERSJournal headers — one row per journal within a batch, carrying ledger, source, category, period, posting status, and control totals; where every subledger's accounting landsSchema: GLtransaction
- GL_JE_LINESJournal lines — the atomic debit/credit rows against account combinations; the source of trial-balance and account-activity analyticsSchema: GLtransaction
- RA_CUSTOMER_TRX_ALLReceivables transaction headers — invoices, credit and debit memos, chargebacks, and deposits share the table, classified by transaction type; the revenue-document anchor of order-to-cashSchema: ARtransaction
- RA_CUSTOMER_TRX_LINES_ALLReceivables transaction lines — product lines, tax, and freight share the table by line type, with quantities, selling price, and the extended amount revenue analytics sumSchema: ARtransaction