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 |