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_SF133_LOAD_ACCTS

Object Details

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

FV_SF133_LOAD_ACCTS table is a seed table used to load the USSGL account codes into the FV_SF133_DEFINTIONS_LINES table. The loading of the default account codes is optional and is controlled by the SF 133 Table Setup procedure.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FV_SF133_LOAD_ACCTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SF133_LINE_NUMBER SF133_LINE_ACCOUNT

Columns

Name	Datatype	Length	Mandatory	Comments
SF133_LINE_NUMBER	NUMBER	(15)	Yes	Relative line number
SF133_LINE_ACCOUNT	VARCHAR2	(25)	Yes	Flexfield account code
SF133_BALANCE_TYPE	VARCHAR2	(1)	Yes	Indicates whether account balance is from beginning or end of year
SF133_ADDITIONAL_INFO	VARCHAR2	(100)		Additional line information

Query Text

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


SELECT SF133_LINE_NUMBER
,      SF133_LINE_ACCOUNT
,      SF133_BALANCE_TYPE
,      SF133_ADDITIONAL_INFO
FROM FV.FV_SF133_LOAD_ACCTS;

Dependencies

[top of page]

FV.FV_SF133_LOAD_ACCTS does not reference any database object

FV.FV_SF133_LOAD_ACCTS is referenced by following:

FV: FV_SF133_LOAD_ACCTS#