PeopleSoft 9.0
Cash Management

Table Name TRP_POOL_TXN

Table Description
TRP_POOL_TXN
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT CHAR(5) Yes Yes
POOL_ID CHAR(10) Yes Yes
TRANSACTIONID INT Yes No
POSITION_TYPE CHAR(1) No No
TRANSACTION_DT datetime No No
AMOUNT DECIMAL(26,3) No No
CURRENCY_CD CHAR(3) No No
ACCTG_TMPL_ID CHAR(15) No No
PART_ACCTG_TMPL_ID CHAR(15) No No
INCOME_ALLOCATED CHAR(1) No No
ENTERED_BY CHAR(30) No No
ENTERED_ON PSDATETIME No No
TRP_EXT_SEQ_NBR DECIMAL(15) No No
Index
Name Type Unique Member
PS_TRP_POOL_TXN PK Yes
Member(s) of "PS_TRP_POOL_TXN" Index
BUSINESS_UNIT
POOL_ID
TRANSACTIONID

Published April 30, 2007