FV Views (67)

FV - Federal Financials — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

View	Description
`FVFV_APPROPRIATION_PARAMETERS`
`FVFV_FEDERAL_ACCOUNT_SYMBOLS`
`FVFV_STATUS_OBLIGATIONS`
`FVFV_TREASURY_SYMBOLS`
`FV_1099T_V`	Used for the FVR1099T - Electronic filing report
`FV_AAN_SETUP_DETAILS`	Based on the table FV_AAN_SETUP_DETAILS_ALL table
`FV_AAN_SETUP_HDRS`	Based on the table FV_AAN_SETUP_HDRS_ALL table
`FV_ACH_CTX_VENDOR_V`	ACH CTX Vendor format
`FV_AGENCY_LOCATION_CODES_V`	FV_AGENCY_LOCATION_CODES_V is based on the table Ap_Bank_Accounts_All.
`FV_APPROPRIATION_HDR_V`	Based on FV_APPROPRIATION_HDR_V and FV_TREASURY_SYMBOLS
`FV_BE_BA_FD_DTL_V`	The main purpose of this view is used as Transaction Extract lines for SLA to identify the sources
`FV_BE_BA_FD_HDR_V`	The main purpose of this view is used as Transaction extract headers for SLA to identify the sources
`FV_BE_GL_V`
`FV_BE_RPR_DTL_V`	The main purpose of this view is used as RPR Transaction Extract lines for SLA to identify the sources.
`FV_BE_RPR_HDR_V`	View is used as RPR Transaction Extract headers for SLA to identify the source
`FV_BE_RPR_XLA_V`	View is used for reporting the Reprogram BE transactions in SLA
`FV_BE_XLA_V`	View is used for reporting BE transactions in SLA
`FV_BUDGETS_WITH_DATES_V`	Stores budget information
`FV_BUDGET_DISTRIBUTION_HDR_V`	Stores budget distribution information
`FV_CUST_VEND_XREFS_V`	Used for the AR/AP Netting Customer Vendor Cross Reference form that is based on the table FV_CUST_VEND_XREFS
`FV_ECS_ACH_VENDOR_V`	Obtains the data required for the ECS ACH Vendor format
`FV_ECS_PAYMENT_V`	Contains information about payment batch records for ECS NCR payment format process
`FV_EVENTS_TXN_CODE_V`
`FV_FACTS1_PERIOD_BALANCES_V`
`FV_FACTS1_TB_V`	This is view is used to publish FACTS-I Trial balance information in Rxi
`FV_FACTS_CUSTOMERS_V`	Identifies the eliminations department for customers for FACTS I process
`FV_FACTS_PERIOD_BALANCES_TB_V`
`FV_FACTS_TB_V`	This view is used to publish FACTS II Trial balance information in Rxi
`FV_FACTS_TRX_V`	This view is used to publish FACTS transactrion register information in Rxi
`FV_FACTS_VENDORS_V`	Identifies the eliminations department for vendors for FACTS I process
`FV_FUND_PARAMETERS_V`	Stores information about treasury symbol and fund value per set of books
`FV_INVOICE_DTL_V`	The View is used to retrieve Invoice details in the form 'Document Cross-Reference'
`FV_INVOICE_MASTER_V`	The View is used to retrieve invoice header details in the form 'Document Cross-Reference'
`FV_INV_HISTSTAT_V`	Stores invoice status history
`FV_INV_STATCUST_V`	Stores information for invoice status find
`FV_INV_STATUSES_V`	Stores invoice status; includes all late invoices
`FV_LINK_GL_TO_AR_ADJUSTMENTS_V`	Links General Ledger to Receivables adjustments
`FV_LINK_GL_TO_AR_MISC_CASH_V`	Links General Ledger to Receivables miscellaneous cash
`FV_LINK_GL_TO_AR_REC_APPS_V`	Links General Ledger to Receivables receivable applications
`FV_LINK_GL_TO_AR_TRAN_V`	Links General Ledger to Receivables transactions
`FV_LINK_GL_TO_CASH_RECEIPTS_V`	Links General Ledger to cash receipts
`FV_LINK_GL_TO_INVOICES_V`	Links General Ledger to invoices
`FV_LINK_GL_TO_PAYMENTS_V`	Links General Ledger to Payables payments
`FV_LINK_GL_TO_PO_RECEIPTS_V`	Links General Ledger to Purchasing receipts
`FV_LINK_GL_TO_TREAS_CONFIRM_V`	Links General Ledger to treasury confirmation
`FV_LOOKUP_CODES`	Contains Federal seeded lookup codes
`FV_LOOKUP_TYPES`	Contains Federal seeded lookup types
`FV_OPAC_AUDIT`
`FV_OPAC_BILLDATA_V`	FV_OPAC_BILLDATA_V is the main view used by the OPAC process to generate invoices.
`FV_OPAC_BILLING`
`FV_PAYABLE_REFUNDS_V`	Retrieves Refund payment details from Account Payables
`FV_PAYMENT_MASTER_V`	Retrieves payment details in the form Document Cross-Reference
`FV_PO_MASTER_V`	The View is used to retrieve purchase order details in the form
`FV_PYA_GL_V`
`FV_RECEIPT_MASTER_V`	The View is used to retrieve receipt details in the form 'Document Cross-Reference'
`FV_REQUISITION_MASTER_V`	The View is used to retrieve requisition details in the form 'Document Cross-Reference'
`FV_SYSTEM_PARAMETERS_V`	Stores system information used by processes such as Prompt Payment and FMS Form 224 Statement ofTransactions and by disbursements in transit
`FV_TBAL_BY_TS_V`	Lists the treasury symbol processed by the FACTS II Trial balance process
`FV_TC_GL_V`
`FV_TPP_ASSIGNMENTS_V`	Payables(AP) will join with this view to provide third party information to Payments(IBY).
`FV_TRANSACTION_EVENTS_V`
`FV_TRANSACTION_HEADERS_V`
`FV_TREAS_CONFIRM_CHECKS_V`
`FV_XLA_AP_REF_V`
`FV_XLA_AR_REF_V`
`FV_XLA_CST_REF_V`
`FV_XLA_PO_REF_V`