PeopleSoft 9.0
Cash Management

Table Name TRA_TMPL_HDR

Table Description
TRA_TMPL_HDR
Columns
Name Datatype Is PK Is FK
SETID CHAR(5) Yes No
ACCTG_TMPL_ID CHAR(15) Yes No
DESCR60 CHAR(60) No No
APPL_JRNL_ID CHAR(10) No No
SOURCE_TYPE CHAR(1) No No
TRA_REVIEW_STATUS CHAR(1) No No
ACCTG_TMPL_STATUS CHAR(1) No No
LAST_MAINT_DTTM PSDATETIME No No
LAST_MAINT_OPRID CHAR(30) No No
DOC_TYPE CHAR(8) No No
Index
Name Type Unique Member
PS_TRA_TMPL_HDR PK Yes
PS0TRA_TMPL_HDR IE2 No
PS1TRA_TMPL_HDR IE2 No
Member(s) of "PS_TRA_TMPL_HDR" Index
SETID
ACCTG_TMPL_ID
Member(s) of "PS0TRA_TMPL_HDR" Index
SOURCE_TYPE
SETID
ACCTG_TMPL_ID
Member(s) of "PS1TRA_TMPL_HDR" Index
ACCTG_TMPL_STATUS
SETID
ACCTG_TMPL_ID

Published April 30, 2007