PeopleSoft 9
Asset Management

Table Name AM_EPL_PARTS

Table Description
AM_EPL_PARTS
Columns
Name Datatype Is PK Is FK
SETID CHAR(5) Yes Yes
EPL_TMPL_ID char(15) Yes Yes
SEQNBR int Yes No
INV_ITEM_TYPE char(5) No No
INV_STOCK_TYPE char(4) No No
INV_ITEM_ID char(18) No No
SUPPLIER_REFERENCE char(20) No No
QUANTITY decimal(15,4) No No
UNIT_OF_MEASURE char(3) No No
ASSET_FLG char(1) No No
DESCR254_MIXED char(254) No No
Index
Name Type Unique Member
PS_AM_EPL_PARTS PK Yes
Member(s) of "PS_AM_EPL_PARTS" Index
SETID
EPL_TMPL_ID
SEQNBR

Published December 16, 2006