PeopleSoft 9.0
Cash Management

Table Name TR_WR_HEADER

Table Description
TR_WR_HEADER
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT CHAR(5) Yes Yes
TR_SOURCE_ID CHAR(12) Yes No
DESCR CHAR(30) No No
OPRID_ENTERED_BY CHAR(30) No No
DTTM_ENTERED PSDATETIME No No
APPR_STATUS CHAR(1) No No
OPRID_APPROVED_BY CHAR(30) No No
APPROVAL_DT PSDATE No No
TR_WR_TEMPLATE_ID CHAR(12) No No
ACCTG_TMPL_ID CHAR(15) No No
FED_WIRE_ID CHAR(12) No No
REPETITVE_TRNFR_CD CHAR(15) No No
DRAWDOWN_FLG CHAR(1) No No
TMPL_EXPIRATION_DT PSDATE No No
TRP_BUSINESS_UNIT CHAR(5) No No
POOL_ID CHAR(10) No No
PRENOTE_FLAG CHAR(1) No No
Index
Name Type Unique Member
PS_TR_WR_HEADER PK Yes
PS0TR_WR_HEADER IE1 No
Member(s) of "PS_TR_WR_HEADER" Index
BUSINESS_UNIT
TR_SOURCE_ID
Member(s) of "PS0TR_WR_HEADER" Index
DESCR
BUSINESS_UNIT
TR_SOURCE_ID

Published April 30, 2007