[Home] [Help] [Dependency Information]
Object Name: | FV_XLA_PO_REF_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | FV.FV_XLA_PO_REF_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view is used for Purchasing related federal sources fro accounting in sub ledger(XLA) .
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_PYA_AMT | NUMBER | Prior year amount | ||
FEDERAL_PYA_DIFF_AMT | NUMBER | Prior year difference amount | ||
FEDERAL_ADJUSTMENT_TYPE | VARCHAR2 | (15) | Upward of Downward adjustment type | |
FEDERAL_NET_PYA_ADJ_AMT | NUMBER | Prior year 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_OLD_CCID | NUMBER | Old CCID |
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_PYA_AMT
, FEDERAL_PYA_DIFF_AMT
, FEDERAL_ADJUSTMENT_TYPE
, FEDERAL_NET_PYA_ADJ_AMT
, FEDERAL_ANTICIPATION
, FEDERAL_ANTICIPATED_AMT
, FEDERAL_UNANTICIPATED_AMT
, FEDERAL_TCF_AMT
, FEDERAL_OLD_CCID
FROM APPS.FV_XLA_PO_REF_V;
|
|
|