RET_DET_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: RETIREMENT
2	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification Prompt Table: RETIREMENT
3	BOOK	Character(10)	VARCHAR2(10) NOT NULL	Asset Book Name Prompt Table: RETIREMENT
4	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. Prompt Table: RETIREMENT
5	SERIAL_COUNT	Number(6,0)	INTEGER NOT NULL	Serial Count
6	TXN_TRADE_IN_VALUE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Transaction Trade-In Value
7	TRADE_IN_VALUE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Trade In value
8	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
9	LIKE_EXCH_ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Like Exch Asset
10	LIKE_KIND_DATESTMP	DateTime(26)	TIMESTAMP	Like Kind datetimestmp
11	TXN_LK_KIND_BASIS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Transaction Like Kind Basis
12	LIKE_KIND_BASIS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Like Kind Exch Basis
13	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
14	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
15	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
16	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
17	RT_EFFDT	Date(10)	DATE	The effective date for a given item of market rate data.
18	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency