[Home] [Help] [Dependency Information]
Object Name: | FV_STATUS_FUNDS_FINAL |
---|---|
Object Type: | TABLE |
Owner: | FV |
FND Design Data: | FV.FV_STATUS_FUNDS_FINAL |
Subobject Name: | |
Status: | VALID |
FV_STATUS_FUNDS_FINAL stores all of the calculations performed in the stored procedure for the Status of Funds report.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SET_OF_BOOKS_ID | NUMBER | Yes | Set of Books identifier | |
FUND | VARCHAR2 | (25) | Balancing segment values | |
TREASURY_SYMBOL | VARCHAR2 | (35) | Treasury symbol values | |
PAGEBREAK_SEG1 | VARCHAR2 | (60) | Lists all available segment names | |
PAGEBREAK_SEG2 | VARCHAR2 | (60) | All segments minus previous selection | |
PAGEBREAK_SEG3 | VARCHAR2 | (60) | All segments minus previous two selections | |
BUDGET_AUTH_TOTAL | NUMBER | (19) | Budget authority total for particular fund or Treasury symbol | |
TRANSFERS_IN_TOTAL | NUMBER | (19) | Transfers-in total for particular fund or Treasury symbol | |
TRANSFERS_OUT_TOTAL | NUMBER | (19) | Transfers-out total for particular fund or Treasury symbol | |
UNLIQUID_COMM_TOTAL | NUMBER | (19) | Unliquidated commitments total for particular fund or Treasury symbol | |
EXPEN_AMT_TOTAL | NUMBER | (19) | Expended amount total for particular fund or Treasury symbol | |
TOTAL_BUDGETARY | NUMBER | (19) | Budgetary total for particular fund or Treasury symbol | |
TOTAL_ACTUALS | NUMBER | (19) | Total actuals for particular fund or Treasury symbol | |
FUNDS_AVAILABLE | NUMBER | (19) | Total funds available for particular fund or Treasury symbol | |
UNLIQUID_OBLIG_TOTAL | NUMBER | (19) | Unliquidated obligations total for particular fund or Treasury symbol | |
TREASURY_SYMBOL_ID | NUMBER | (15) | Yes | References treasury_symbol_id of the table FV_TREASURY_SYMBOLS |
Cut, paste (and edit) the following text to query this object:
SELECT SET_OF_BOOKS_ID
, FUND
, TREASURY_SYMBOL
, PAGEBREAK_SEG1
, PAGEBREAK_SEG2
, PAGEBREAK_SEG3
, BUDGET_AUTH_TOTAL
, TRANSFERS_IN_TOTAL
, TRANSFERS_OUT_TOTAL
, UNLIQUID_COMM_TOTAL
, EXPEN_AMT_TOTAL
, TOTAL_BUDGETARY
, TOTAL_ACTUALS
, FUNDS_AVAILABLE
, UNLIQUID_OBLIG_TOTAL
, TREASURY_SYMBOL_ID
FROM FV.FV_STATUS_FUNDS_FINAL;
FV.FV_STATUS_FUNDS_FINAL does not reference any database object
FV.FV_STATUS_FUNDS_FINAL is referenced by following:
|
|
|