PeopleSoft 9.0
Cash Management

Table Name TRP_POOLTXN_STG

Table Description
TRP_POOLTXN_STG
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT CHAR(5) Yes Yes
POOL_ID CHAR(10) Yes No
TRP_EXT_SEQ_NBR DECIMAL(15) Yes No
POSITION_TYPE CHAR(1) No No
TRANSACTION_DT PSDATE 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
Index
Name Type Unique Member
PS_TRP_POOLTXN_STG PK Yes
Member(s) of "PS_TRP_POOLTXN_STG" Index
BUSINESS_UNIT
POOL_ID
TRP_EXT_SEQ_NBR

Published April 30, 2007