PeopleSoft 9.0
Cash Management

Table Name TRP_POOL_POS

Table Description
TRP_POOL_POS
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT CHAR(5) Yes Yes
POOL_ID CHAR(10) Yes Yes
TRANSACTION_DT datetime Yes No
MKT_VALUE DECIMAL(26,3) No No
BOOK_VALUE DECIMAL(26,3) No No
CHANGE_AMOUNT DECIMAL(26,3) No No
CURRENCY_CD CHAR(3) No No
NO_OF_SHARES DECIMAL(15) No No
INCOME_ALLOCATED CHAR(1) No No
TRP_SHARE_PRICE DECIMAL(26,3) No No
SOURCE_RECNAME CHAR(15) No No
POSITION_TYPE CHAR(1) No No
Index
Name Type Unique Member
PS_TRP_POOL_POS PK Yes
Member(s) of "PS_TRP_POOL_POS" Index
BUSINESS_UNIT
POOL_ID
TRANSACTION_DT

Published April 30, 2007