PeopleSoft 9
Asset Management

Table Name AM_WTMPL_CRTR

Table Description
AM_WTMPL_CRTR
Columns
Name Datatype Is PK Is FK
SETID char(5) Yes Yes
WRTY_TMPL_NAME char(40) Yes Yes
CRTR_NUM smallint Yes No
ASSET_TYPE char(3) No No
ASSET_SUBTYPE char(15) No No
VENDOR_ID char(10) No Yes
MODEL char(30) No No
INV_ITEM_ID char(18) No Yes
Index
Name Type Unique Member
PS_AM_WTMPL_CRTR PK Yes
Member(s) of "PS_AM_WTMPL_CRTR" Index
SETID
WRTY_TMPL_NAME
CRTR_NUM

Published December 16, 2006