PeopleSoft 9.0
Cash Management

Table Name TRP_PART_TXN

Table Description
TRP_PART_TXN
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT CHAR(5) Yes Yes
POOL_ID CHAR(10) Yes No
PARTICIPANT_ID CHAR(10) Yes Yes
PARTICIPANT_ACCT CHAR(25) Yes No
TRP_ACCOUNT_TYPE CHAR(1) Yes No
TRANSACTIONID int Yes No
DESCR CHAR(30) No No
TRP_TXN_TYPE CHAR(1) No No
TRANSACTION_DT datetime No No
AMOUNT DECIMAL(26,3) No No
CURRENCY_CD CHAR(3) No No
TRP_ACCOUNT_TO CHAR(25) No No
ACCOUNT_TO_TYPE CHAR(1) No No
TRP_TXN_STATUS CHAR(1) No No
ACCTG_TMPL_ID CHAR(15) No No
TR_WR_TEMPLATE_ID CHAR(12) No No
ENTERED_BY CHAR(30) No No
ENTERED_ON PSDATETIME No No
DOC_TYPE CHAR(8) No No
Index
Name Type Unique Member
PS_TRP_PART_TXN PK Yes
Member(s) of "PS_TRP_PART_TXN" Index
BUSINESS_UNIT
POOL_ID
PARTICIPANT_ID
PARTICIPANT_ACCT
TRP_ACCOUNT_TYPE
TRANSACTIONID

Published April 30, 2007