PeopleSoft 9 Asset Management |
Table Name | DIST_TMPL_TBL |
Table Description |
DIST_TMPL_TBL |
Columns |
Name | Datatype | Is PK | Is FK |
SETID | char(5) | Yes | Yes |
CATEGORY | char(5) | Yes | No |
COST_TYPE | char(1) | Yes | No |
TRANS_TYPE | char(3) | Yes | No |
TRANS_CODE | char(5) | Yes | No |
ACCT_ENT_TMPL_ID | char(10) | Yes | No |
APPL_JRNL_ID | char(10) | No | Yes |
APPL_JRNL_ID_BUD | char(10) | No | No |
Index |
Name | Type | Unique | Member |
PS_DIST_TMPL_TBL | PK | Yes |
![]() |
PSADIST_TMPL_TBL | IE1 | No |
![]() |
Member(s) of "PS_DIST_TMPL_TBL" Index |
SETID |
CATEGORY |
COST_TYPE |
TRANS_TYPE |
TRANS_CODE |
ACCT_ENT_TMPL_ID |
Member(s) of "PSADIST_TMPL_TBL" Index |
CATEGORY |
TRANS_TYPE |
TRANS_CODE |
Published December 16, 2006 |