DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.FV_XLA_CST_REF_V

Object Details
Object Name: FV_XLA_CST_REF_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFV.FV_XLA_CST_REF_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view is used as costing federal accounting source in sub ledger accounting (XLA)


[View Source]

Columns
Name Datatype Length Mandatory Comments
FEDERAL_EVENT_ID NUMBER (15)
Event identifier
FEDERAL_LINE_NUMBER NUMBER (15)
Line number
FEDERAL_FUND_VALUE VARCHAR2 (30)
Balancing segment value
FEDERAL_FUND_CATEGORY VARCHAR2 (1)
Fund category
FEDERAL_FUND_EXPIRED_STATUS VARCHAR2 (15)
Fund expired status
FEDERAL_PRIOR_YEAR_FLAG VARCHAR2 (1)
Flag to denote prior year transaction
FEDERAL_ADJUSTMENT_TYPE VARCHAR2 (15)
Upward or Downward adjustment type
FEDERAL_NET_PYA_ADJ_AMT NUMBER

Adjustment amount
FEDERAL_ANTICIPATION VARCHAR2 (15)
Denotes whether the amount is anticipated, unanticipated or partial
FEDERAL_ANTICIPATED_AMT NUMBER

Anticipated amount
FEDERAL_UNANTICIPATED_AMT NUMBER

Unanticipated amount
FEDERAL_TCF_AMT NUMBER

Treasury confirmed Amount. Paid amount only from payments that are not voided and are treasury confirmed.
FEDERAL_UNEXP_OBG_AMT NUMBER

Unexpended obligation amount
FEDERAL_PAID_UNEXP_OBG_AMT NUMBER

Paid unexpended obligation amount
FEDERAL_PAID_RECEIVED_AMT NUMBER

Paid portion of unexpended obligation. Receipt must correctly liquid ate the obligation based on its paid amount confirmed with Treasury.
FEDERAL_UNPAID_UNEXP_OBG_AMT NUMBER

Unpaid unexpended obligation amount
FEDERAL_UNPAID_RECEIVED_AMT NUMBER

Unpaid portion of unexpended obligation. Receipt must correctly liquidate the obligation based on its unpaid amount confirmed with Treasury.
FEDERAL_UNPAID_OPEN_AMT NUMBER

Calculated financed amount only from payments that are not voided and are treasury confirmed.
FEDERAL_RCV_SUB_LEDGER_ID NUMBER

Receivable sub ledger identifier
ENT_CHARGE_AMOUNT NUMBER

Entered Charge Amount
ACC_CHARGE_AMOUNT NUMBER

Accounted Charge Amount
ENT_UNPAID_OBL_AMOUNT NUMBER

Entered Unpaid Obligation Amount
ACC_UNPAID_OBL_AMOUNT NUMBER

Accounted Unpaid Obligation Amount
ENT_UNPAID_EXP_AMOUNT NUMBER

Entered Unpaid Expenditure Amount
ACC_UNPAID_EXP_AMOUNT NUMBER

Accounted Unpaid Expenditure Amount
ENT_PAID_EXP_AMOUNT NUMBER

Entered Paid Expenditure Amount
ACC_PAID_EXP_AMOUNT NUMBER

Accounted Paid Expenditure Amount
ENT_UNPAID_OBL_PYA_AMOUNT NUMBER

Entered Unpaid Obligation Pya Amount
ACC_UNPAID_OBL_PYA_AMOUNT NUMBER

Accounted Unpaid Obligation Pya Amount
ENT_UNPAID_OBL_PYA_OFF_AMOUNT NUMBER

Entered Unpaid Obligation Pya Offset Amount
ACC_UNPAID_OBL_PYA_OFF_AMOUNT NUMBER

Accounted Unpaid Obligation Pya Offset Amount
ENT_ANTICIPATED_BUDGET_AMOUNT NUMBER

Entered Anticipated Budget Amount
ACC_ANTICIPATED_BUDGET_AMOUNT NUMBER

Accounted Anticipated Budget Amount
ENT_UNANTICIPATED_BUD_AMOUNT NUMBER

Entered Unanticipated Budget Amount
ACC_UNANTICIPATED_BUD_AMOUNT NUMBER

Accounted Unanticipated Budget Amount
FEDERAL_DIRECT_OR_REIMB VARCHAR2 (1)
Federal Direct Or Reimbursable
FEDERAL_FUND_TYPE VARCHAR2 (2)
Fund Type
ACC_UNPAID_EXP_PYA_AMOUNT NUMBER

Accounted Unpaid Expenditure PYA Amount
ENT_UNPAID_EXP_PYA_AMOUNT NUMBER

Entered Unpaid Expenditure PYA Amount
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT FEDERAL_EVENT_ID
,      FEDERAL_LINE_NUMBER
,      FEDERAL_FUND_VALUE
,      FEDERAL_FUND_CATEGORY
,      FEDERAL_FUND_EXPIRED_STATUS
,      FEDERAL_PRIOR_YEAR_FLAG
,      FEDERAL_ADJUSTMENT_TYPE
,      FEDERAL_NET_PYA_ADJ_AMT
,      FEDERAL_ANTICIPATION
,      FEDERAL_ANTICIPATED_AMT
,      FEDERAL_UNANTICIPATED_AMT
,      FEDERAL_TCF_AMT
,      FEDERAL_UNEXP_OBG_AMT
,      FEDERAL_PAID_UNEXP_OBG_AMT
,      FEDERAL_PAID_RECEIVED_AMT
,      FEDERAL_UNPAID_UNEXP_OBG_AMT
,      FEDERAL_UNPAID_RECEIVED_AMT
,      FEDERAL_UNPAID_OPEN_AMT
,      FEDERAL_RCV_SUB_LEDGER_ID
,      ENT_CHARGE_AMOUNT
,      ACC_CHARGE_AMOUNT
,      ENT_UNPAID_OBL_AMOUNT
,      ACC_UNPAID_OBL_AMOUNT
,      ENT_UNPAID_EXP_AMOUNT
,      ACC_UNPAID_EXP_AMOUNT
,      ENT_PAID_EXP_AMOUNT
,      ACC_PAID_EXP_AMOUNT
,      ENT_UNPAID_OBL_PYA_AMOUNT
,      ACC_UNPAID_OBL_PYA_AMOUNT
,      ENT_UNPAID_OBL_PYA_OFF_AMOUNT
,      ACC_UNPAID_OBL_PYA_OFF_AMOUNT
,      ENT_ANTICIPATED_BUDGET_AMOUNT
,      ACC_ANTICIPATED_BUDGET_AMOUNT
,      ENT_UNANTICIPATED_BUD_AMOUNT
,      ACC_UNANTICIPATED_BUD_AMOUNT
,      FEDERAL_DIRECT_OR_REIMB
,      FEDERAL_FUND_TYPE
,      ACC_UNPAID_EXP_PYA_AMOUNT
,      ENT_UNPAID_EXP_PYA_AMOUNT
FROM APPS.FV_XLA_CST_REF_V;

Dependencies

[top of page]

APPS.FV_XLA_CST_REF_V references the following:

SchemaAPPS
TableFV_EXTRACT_DETAIL_GT
APPS.FV_XLA_CST_REF_V is referenced by following:

SchemaAPPS
Package BodyXLA_00707_AAD_S_000007_BC_PKG - show dependent code