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_TP_TREASURY_SYMBOLS

Object Details

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

Table to store Trading Partner Treasury Account Symbols

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FV_TP_TREASURY_SYMBOL_COMB_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SUB_LEVEL_PREFIX_CODE DEPT_TRANSFER AGENCY_ID ESTABLISHED_FISCAL_YR END_YEAR_AVAIL AVAILABILITY_TYPE_CODE MAIN_ACCT_CODE SUB_ACCT_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
TREASURY_SYMBOL	VARCHAR2	(35)	Yes	Treasury Symbol value
SUB_LEVEL_PREFIX_CODE	VARCHAR2	(2)		Sublevel Prefix Code
DEPT_TRANSFER	VARCHAR2	(3)		Allocation Transfer Agency Identifier
AGENCY_ID	VARCHAR2	(3)	Yes	Unique Agency Identifier used to represent FPA
ESTABLISHED_FISCAL_YR	NUMBER	(15)		Beginning Period of Availability
END_YEAR_AVAIL	NUMBER	(15)		Ending Period of Availability
AVAILABILITY_TYPE_CODE	VARCHAR2	(1)		Availability Type Code
MAIN_ACCT_CODE	VARCHAR2	(4)	Yes	Main Account Code
SUB_ACCT_CODE	VARCHAR2	(3)	Yes	Sub-Account Code
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
AUTHORITY_DURATION_CODE	VARCHAR2	(1)	Yes	Indicates validity period of a trading partner Treasury Account Symbol
AUTO_CREATE_FLAG#1	VARCHAR2	(1)
FEDERAL_ACCT_SYMBOL_NAME	VARCHAR2	(125)		Federal Account Symbol Name
TREASURY_SYMBOL_ID	NUMBER	(15)		Treasury symbol identifier
SET_OF_BOOKS_ID	NUMBER	(15)		Ledger ID
ORG_ID	NUMBER	(15)		Organization identifier
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flex Field segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flex Field segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flex Field segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flex Field segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flex Field segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flex Field segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flex Field segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flex Field segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flex Field segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flex Field segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flex Field segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flex Field segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flex Field segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flex Field segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flex Field segment
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flex Field structure definition column
START_DATE	DATE			Start Date
END_DATE	DATE			End Date
AUTO_CREATE_FLAG_BETC	VARCHAR2	(1)		Indicates if BETCs associated with the Trading partner TAS can be autocreated

Query Text

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


SELECT TREASURY_SYMBOL
,      SUB_LEVEL_PREFIX_CODE
,      DEPT_TRANSFER
,      AGENCY_ID
,      ESTABLISHED_FISCAL_YR
,      END_YEAR_AVAIL
,      AVAILABILITY_TYPE_CODE
,      MAIN_ACCT_CODE
,      SUB_ACCT_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      AUTHORITY_DURATION_CODE
,      AUTO_CREATE_FLAG#1
,      FEDERAL_ACCT_SYMBOL_NAME
,      TREASURY_SYMBOL_ID
,      SET_OF_BOOKS_ID
,      ORG_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      START_DATE
,      END_DATE
,      AUTO_CREATE_FLAG_BETC
FROM FV.FV_TP_TREASURY_SYMBOLS;

Dependencies

[top of page]

FV.FV_TP_TREASURY_SYMBOLS does not reference any database object

FV.FV_TP_TREASURY_SYMBOLS is referenced by following:

FV: FV_TP_TREASURY_SYMBOLS#