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

VIEW: APPS.FV_XLA_AP_REF_V

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

View Type

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


The view is used as payables federal accounting source.


[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)
Expired status of fund
FEDERAL_FUND_CAT_DESC VARCHAR2 (12)
Description of fund category
FEDERAL_ADJUSTMENT_TYPE VARCHAR2 (15)
Upward or Downward adjustment type
FEDERAL_PRIOR_YEAR_FLAG VARCHAR2 (1)
Flag to denote a prior year transaction
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_PAID_RECEIVED_AMT NUMBER

Paid portion of unexpended obligation. Receipt must correctly liquidate the obligation based on its paid amount confirmed with Treasury.
FEDERAL_PAID_UNEXP_OBG_AMT NUMBER

Paid unexpended obligation amount
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.
ENT_UNPAID_OBL_AMOUNT NUMBER

Entered Unpaid Obligation Amount
ACC_UNPAID_OBL_AMOUNT NUMBER

Accounted Unpaid Obligation 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
ENT_CHARGE_AMOUNT NUMBER

Entered Charge Amount
ACC_CHARGE_AMOUNT NUMBER

Accounted Charge 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_PAID_OBL_AMOUNT NUMBER

FV Entered Paid Obligation Amount
ACC_PAID_OBL_AMOUNT NUMBER

FV Accounted Paid Obligation Amount
ENT_UNPAID_EXP_PYA_AMOUNT NUMBER

FV Entered Unpaid Expenditure PYA Amount
ACC_UNPAID_EXP_PYA_AMOUNT NUMBER

FV Accounted Unpaid Expenditure PYA Amount
ENT_UNPAID_EXP_PYA_OFF_AMOUNT NUMBER

FV Entered Unpaid Expenditure PYA Offset Amount
ACC_UNPAID_EXP_PYA_OFF_AMOUNT NUMBER

FV Accounted Unpaid Expenditure PYA Offset Amount
ACC_EXPENDED_APPROP_AMOUNT NUMBER

FV Accounted Expended Appropriations Amount
ENT_EXPENDED_APPROP_AMOUNT NUMBER

FV Entered Expended Appropriations Amount
ENT_PAID_EXP_PYA_AMOUNT NUMBER

FV Entered Paid Expenditure PYA Amount
ACC_PAID_EXP_PYA_AMOUNT NUMBER

FV Accounted Paid Expenditure PYA Amount
ENT_PAID_EXP_PYA_OFF_AMOUNT NUMBER

FV Entered Paid Expenditure PYA Offset Amount
ACC_PAID_EXP_PYA_OFF_AMOUNT NUMBER

FV Accounted Paid Expenditure PYA Offset Amount
FEDERAL_DIRECT_OR_REIMB VARCHAR2 (1)
Federal Direct Or Reimb
FEDERAL_FUND_TYPE VARCHAR2 (2)
Fund Type
FED_AR_TRANSACTION_CATEGORY VARCHAR2 (50)
FED AR Transaction Category
FEDERAL_NON_FEDERAL_IND VARCHAR2 (1)
Federal Non Federal Indicator
ENT_REFUND_AMOUNT NUMBER

Entered Refund Amount
ACC_REFUND_AMOUNT NUMBER

Accounted Refund Amount
FEDERAL_ADVANCE_REQUIRED VARCHAR2 (1)
Advance Required
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_FUND_CAT_DESC
,      FEDERAL_ADJUSTMENT_TYPE
,      FEDERAL_PRIOR_YEAR_FLAG
,      FEDERAL_ANTICIPATION
,      FEDERAL_ANTICIPATED_AMT
,      FEDERAL_UNANTICIPATED_AMT
,      FEDERAL_TCF_AMT
,      FEDERAL_PAID_RECEIVED_AMT
,      FEDERAL_PAID_UNEXP_OBG_AMT
,      FEDERAL_UNPAID_UNEXP_OBG_AMT
,      FEDERAL_UNPAID_RECEIVED_AMT
,      FEDERAL_UNPAID_OPEN_AMT
,      ENT_UNPAID_OBL_AMOUNT
,      ACC_UNPAID_OBL_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
,      ENT_CHARGE_AMOUNT
,      ACC_CHARGE_AMOUNT
,      ENT_UNPAID_EXP_AMOUNT
,      ACC_UNPAID_EXP_AMOUNT
,      ENT_PAID_EXP_AMOUNT
,      ACC_PAID_EXP_AMOUNT
,      ENT_PAID_OBL_AMOUNT
,      ACC_PAID_OBL_AMOUNT
,      ENT_UNPAID_EXP_PYA_AMOUNT
,      ACC_UNPAID_EXP_PYA_AMOUNT
,      ENT_UNPAID_EXP_PYA_OFF_AMOUNT
,      ACC_UNPAID_EXP_PYA_OFF_AMOUNT
,      ACC_EXPENDED_APPROP_AMOUNT
,      ENT_EXPENDED_APPROP_AMOUNT
,      ENT_PAID_EXP_PYA_AMOUNT
,      ACC_PAID_EXP_PYA_AMOUNT
,      ENT_PAID_EXP_PYA_OFF_AMOUNT
,      ACC_PAID_EXP_PYA_OFF_AMOUNT
,      FEDERAL_DIRECT_OR_REIMB
,      FEDERAL_FUND_TYPE
,      FED_AR_TRANSACTION_CATEGORY
,      FEDERAL_NON_FEDERAL_IND
,      ENT_REFUND_AMOUNT
,      ACC_REFUND_AMOUNT
,      FEDERAL_ADVANCE_REQUIRED
FROM APPS.FV_XLA_AP_REF_V;

Dependencies

[top of page]

APPS.FV_XLA_AP_REF_V references the following:

SchemaAPPS
TableFV_EXTRACT_DETAIL_GT
APPS.FV_XLA_AP_REF_V is referenced by following:

SchemaAPPS
Package BodyXLA_00200_AAD_S_000012_BC_PKG - show dependent code
Package BodyXLA_00200_AAD_S_000012_PKG - show dependent code