PeopleSoft 9
Asset Management

Table Name DIST_TMPLLN_TBL

Table Description
DIST_TMPLLN_TBL
Columns
Name Datatype Is PK Is FK
SETID char(5) Yes Yes
CATEGORY char(5) Yes Yes
COST_TYPE char(1) Yes Yes
TRANS_TYPE char(3) Yes Yes
TRANS_CODE char(5) Yes Yes
ACCT_ENT_TMPL_ID char(10) Yes Yes
TRANS_IN_OUT char(1) Yes No
DISTRIBUTION_TYPE char(2) Yes No
ACCOUNT_SIGN smallint No No
ACCOUNT char(10) No Yes
ALTACCT char(10) No No
SIGN_ADJUSTER smallint No No
BOOK_CODE char(4) No No
Index
Name Type Unique Member
PS_DIST_TMPLLN_TBL PK Yes
PSADIST_TMPLLN_TBL IE1 No
PSBDIST_TMPLLN_TBL IE2 No
Member(s) of "PS_DIST_TMPLLN_TBL" Index
SETID
CATEGORY
COST_TYPE
TRANS_TYPE
TRANS_CODE
ACCT_ENT_TMPL_ID
TRANS_IN_OUT
DISTRIBUTION_TYPE
Member(s) of "PSADIST_TMPLLN_TBL" Index
TRANS_TYPE
TRANS_CODE
DISTRIBUTION_TYPE
Member(s) of "PSBDIST_TMPLLN_TBL" Index
CATEGORY
TRANS_TYPE
TRANS_CODE
TRANS_IN_OUT

Published December 16, 2006