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_GTAS_ENDING_BALANCES

Object Details

Object Name:	FV_GTAS_ENDING_BALANCES
Object Type:	TABLE
Owner:	FV
Subobject Name:
Status:	VALID

Table used by GTAS Processes

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
ACCOUNT_TYPE	VARCHAR2	(1)		Account Type
AMOUNT	NUMBER		Yes	Amount
AUTHORITY_TYPE_CODE	VARCHAR2	(1)		Authority Type Code
BEGINNING_BALANCE	NUMBER			Beginning Balance
BUDGET_IMPACT_IND	VARCHAR2	(1)		Budget Impact Ind
CCID	NUMBER	(15)	Yes	Ccid
CUST_NON_CUST	VARCHAR2	(1)		Cust Non Cust
D_C_INDICATOR	VARCHAR2	(1)	Yes	D C Indicator
END_BAL_IND	VARCHAR2	(1)		End Bal Ind
EXCH_NON_EXCH	VARCHAR2	(1)		Exch Non Exch
FED_NON_FED	VARCHAR2	(1)		Fed Non Fed
FISCAL_YEAR	NUMBER	(4)	Yes	Fiscal Year
FUND_VALUE	VARCHAR2	(30)	Yes	Fund Value
RECIPIENT_NAME	VARCHAR2	(120)		Recipient Name
RECORD_CATEGORY	VARCHAR2	(25)		Record Category
REPORTED_STATUS	VARCHAR2	(1)		Reported Status
SET_OF_BOOKS_ID	NUMBER		Yes	Set of Books Id
TRADING_PARTNER_AGENCY_ID	VARCHAR2	(3)		Trading Partner Agency Id
TRADING_PARTNER_MAIN_ACCOUNT	VARCHAR2	(4)		Trading Partner Main Account
USSGL_ACCOUNT	VARCHAR2	(6)		Ussgl Account
ACCOUNT_NUMBER	VARCHAR2	(30)	Yes	Account Number
DOLLAR_AMOUNT	NUMBER

Query Text

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


SELECT ACCOUNT_TYPE
,      AMOUNT
,      AUTHORITY_TYPE_CODE
,      BEGINNING_BALANCE
,      BUDGET_IMPACT_IND
,      CCID
,      CUST_NON_CUST
,      D_C_INDICATOR
,      END_BAL_IND
,      EXCH_NON_EXCH
,      FED_NON_FED
,      FISCAL_YEAR
,      FUND_VALUE
,      RECIPIENT_NAME
,      RECORD_CATEGORY
,      REPORTED_STATUS
,      SET_OF_BOOKS_ID
,      TRADING_PARTNER_AGENCY_ID
,      TRADING_PARTNER_MAIN_ACCOUNT
,      USSGL_ACCOUNT
,      ACCOUNT_NUMBER
,      DOLLAR_AMOUNT
FROM FV.FV_GTAS_ENDING_BALANCES;

Dependencies

[top of page]

FV.FV_GTAS_ENDING_BALANCES does not reference any database object

FV.FV_GTAS_ENDING_BALANCES is referenced by following:

FV: FV_GTAS_ENDING_BALANCES#