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 |