PeopleSoft 9
Asset Management

Table Name RET_DET_TBL

Table Description
RET_DET_TBL
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
ASSET_ID char(12) Yes Yes
BOOK char(10) Yes Yes
DTTM_STAMP PSDATETIME Yes No
SERIAL_COUNT int Yes No
TXN_TRADE_IN_VALUE decimal(26,3) No No
TRADE_IN_VALUE decimal(26,3) No No
DESCR char(30) No No
LIKE_EXCH_ASSET_ID char(12) No No
LIKE_KIND_DATESTMP PSDATETIME No No
TXN_LK_KIND_BASIS decimal(26,3) No No
LIKE_KIND_BASIS decimal(26,3) No No
CURRENCY_CD char(3) No No
RATE_DIV decimal(15,8) No No
RATE_MULT decimal(15,8) No No
RT_TYPE char(5) No No
RT_EFFDT PSDATE No No
TXN_CURRENCY_CD char(3) No No
Index
Name Type Unique Member
PS_RET_DET_TBL PK Yes
Member(s) of "PS_RET_DET_TBL" Index
BUSINESS_UNIT
ASSET_ID
BOOK
DTTM_STAMP
SERIAL_COUNT

Published December 16, 2006