eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: FV.FV_FACTS1_FED_ACCOUNTS

Object Details

Object Name:	FV_FACTS1_FED_ACCOUNTS
Object Type:	TABLE
Owner:	FV
FND Design Data:	FV.FV_FACTS1_FED_ACCOUNTS
Subobject Name:
Status:	VALID

Stores the Federal accounts required for FACTS I report generation.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FV_FACTS1_FED_ACCOUNTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID ACCOUNT_NUMBER FISCAL_YEAR

Columns

Name	Datatype	Length	Mandatory	Comments
ACCOUNT_NUMBER	VARCHAR2	(30)	Yes	Account number
SGL_ACCOUNT_NUMBER	VARCHAR2	(30)	Yes	USSGL account number
FED_NON_FED	VARCHAR2	(1)	Yes	Federal of Non-federal indicator
JC_FLAG	VARCHAR2	(1)		Journal creation flag
LAST_RUN_DATE	DATE			Last date that the process was run
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of books identifier
FISCAL_YEAR	NUMBER	(15)	Yes	Fiscal Year

Query Text

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


SELECT ACCOUNT_NUMBER
,      SGL_ACCOUNT_NUMBER
,      FED_NON_FED
,      JC_FLAG
,      LAST_RUN_DATE
,      SET_OF_BOOKS_ID
,      FISCAL_YEAR
FROM FV.FV_FACTS1_FED_ACCOUNTS;

Dependencies

[top of page]

FV.FV_FACTS1_FED_ACCOUNTS does not reference any database object

FV.FV_FACTS1_FED_ACCOUNTS is referenced by following:

FV: FV_FACTS1_FED_ACCOUNTS#