PeopleSoft 9.0
Cash Management

Table Name TRA_TMPL_DETL

Table Description
TRA_TMPL_DETL
Columns
Name Datatype Is PK Is FK
SETID CHAR(5) Yes Yes
ACCTG_TMPL_ID CHAR(15) Yes Yes
ACCTG_TMPL_LINE SMALLINT Yes No
CHARTFIELD_OPTION CHAR(2) No No
SIGN_MODE CHAR(2) No No
ACCOUNT CHAR(10) No No
ALTACCT CHAR(10) No No
DEPTID CHAR(10) No No
OPERATING_UNIT CHAR(8) No No
PRODUCT CHAR(6) No No
FUND_CODE CHAR(5) No No
CLASS_FLD CHAR(5) No No
PROGRAM_CODE CHAR(5) No No
BUDGET_REF CHAR(8) No No
AFFILIATE CHAR(5) No No
AFFILIATE_INTRA1 CHAR(10) No No
AFFILIATE_INTRA2 CHAR(10) No No
CHARTFIELD1 CHAR(10) No No
CHARTFIELD2 CHAR(10) No No
CHARTFIELD3 CHAR(10) No No
PROJECT_ID CHAR(15) No No
STATISTICS_CODE CHAR(3) No No
BANK_ACCT_LED_TYPE CHAR(1) No No
SUBSTITUTE_CF CHAR(1) No No
AMOUNT_CALC_TYPE CHAR(2) No No
TRANSACTION_LINE SMALLINT No No
TRANSACTION_LEG SMALLINT No No
IU_ANCHOR_FLG CHAR(1) No No
VAT_TR_FLG CHAR(1) No No
Index
Name Type Unique Member
PS_TRA_TMPL_DETL PK Yes
Member(s) of "PS_TRA_TMPL_DETL" Index
SETID
ACCTG_TMPL_ID
ACCTG_TMPL_LINE

Published April 30, 2007