PeopleSoft 9 Asset Management |
Table Name | AM_SUBTYPE |
Table Description |
AM_SUBTYPE |
Columns |
Name | Datatype | Is PK | Is FK |
SETID | char(5) | Yes | No |
ASSET_TYPE | char(3) | Yes | No |
ASSET_SUBTYPE | char(15) | Yes | No |
DESCRSHORT | char(10) | No | No |
DESCR | char(30) | No | No |
IT_SUBTYPE | char(15) | No | No |
DFLT_RULE_STYPE_SW | char(1) | No | No |
RETIRE_AC_SW | char(1) | No | No |
TRF_OUT_SW | char(1) | No | No |
TRF_IN_SW | char(1) | No | No |
TRF_ACQ_DET_SW | char(1) | No | No |
TRF_ATTRIBUTES_SW | char(1) | No | No |
TRF_COMMENTS_SW | char(1) | No | No |
TRF_LEASE_SW | char(1) | No | No |
TRF_LIC_REG_SW | char(1) | No | No |
TRF_MAINT_SW | char(1) | No | No |
TRF_WARRANTY_SW | char(1) | No | No |
TRF_NON_CAP_COST | char(1) | No | No |
TRK_COMP_HIST_SW | CHAR(1) | No | No |
TRF_INSPECTION_SW | char(1) | No | No |
TRF_INSURANCE_SW | char(1) | No | No |
ATTRIBUTE_GROUP_SW | CHAR(1) | No | No |
Index |
Name | Type | Unique | Member |
PS_AM_SUBTYPE | PK | Yes |
![]() |
Member(s) of "PS_AM_SUBTYPE" Index |
SETID |
ASSET_TYPE |
ASSET_SUBTYPE |
Published December 16, 2006 |