PeopleSoft 9
Asset Management

Table Name AM_DOCTYPE_TMPL

Table Description
AM_DOCTYPE_TMPL
Columns
Name Datatype Is PK Is FK
SETID CHAR(5) Yes No
CATEGORY char(5) Yes Yes
TRANS_CODE char(5) Yes No
DOC_TYPE_ADD char(10) No No
DOC_TYPE_ADJ char(10) No No
DOC_TYPE_DEPR char(10) No No
DOC_TYPE_DEPR_REV char(10) No No
DOC_TYPE_IMPAIR char(10) No No
DOC_TYPE_IMPREV char(10) No No
DOC_TYPE_INFLATION char(10) No No
DOC_TYPE_LEASEPAY char(10) No No
DOC_TYPE_LSEPAYREV char(10) No No
DOC_TYPE_PDP char(10) No No
DOC_TYPE_PDPREV char(10) No No
DOC_TYPE_REINSTATE char(10) No No
DOC_TYPE_RESERVE char(10) No No
DOC_TYPE_RETIRE char(10) No No
DOC_TYPE_RECAT char(10) No No
DOC_TYPE_TRANS char(10) No No
DOC_TYPE_REVALUTE char(10) No No
Index
Name Type Unique Member
XPKAM_DOCTYPE_TMPL PK Yes
PS_AM_DOCTYPE_TMPL AK1 Yes
Member(s) of "XPKAM_DOCTYPE_TMPL" Index
SETID
CATEGORY
TRANS_CODE
Member(s) of "PS_AM_DOCTYPE_TMPL" Index
SETID
CATEGORY
TRANS_CODE

Published December 16, 2006