[Home] [Help] [Dependency Information]
Object Name: | FV_YE_CLOSED_TREASURY_SYMBOLS |
---|---|
Object Type: | TABLE |
Owner: | FV |
FND Design Data: | FV.FV_YE_CLOSED_TREASURY_SYMBOLS |
Subobject Name: | |
Status: | VALID |
FV_YE_CLOSED_TREASURY_SYMBOLS is populated by the Year-End Closing process when closing a Treasury symbol in the Final mode.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TREASURY_SYMBOL | VARCHAR2 | (35) | Treasury symbol that Year-End Closing process successfully closed | |
CLOSE_DATE | DATE | Yes | Date Treasury symbol closed | |
FISCAL_YEAR | NUMBER | Yes | Closing fiscal year for Treasury symbol | |
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Set of Books identifier |
APPROPRIATION_STATUS | VARCHAR2 | (25) | Yes | Indicates appropriation status. Valid values are Expired, Carryover, or Canceled. |
TREASURY_SYMBOL_ID | NUMBER | (15) | Yes | references treasury symbol identifier in the FV_TREASURY_SYMBOLS table |
Cut, paste (and edit) the following text to query this object:
SELECT TREASURY_SYMBOL
, CLOSE_DATE
, FISCAL_YEAR
, SET_OF_BOOKS_ID
, APPROPRIATION_STATUS
, TREASURY_SYMBOL_ID
FROM FV.FV_YE_CLOSED_TREASURY_SYMBOLS;
FV.FV_YE_CLOSED_TREASURY_SYMBOLS does not reference any database object
FV.FV_YE_CLOSED_TREASURY_SYMBOLS is referenced by following:
|
|
|