PeopleSoft 9
Asset Management

Table Name MANUFACTURER

Table Description
MANUFACTURER
Columns
Name Datatype Is PK Is FK
SETID char(5) Yes No
MFG_ID char(50) Yes No
DESCRSHORT char(10) No No
DESCR char(30) No No
UPN_TYPE_CD char(4) No No
LOCALLY_OWNED_FLG char(1) No No
Index
Name Type Unique Member
PS_MANUFACTURER PK Yes
PS0MANUFACTURER IE1 No
Member(s) of "PS_MANUFACTURER" Index
SETID
MFG_ID
Member(s) of "PS0MANUFACTURER" Index
DESCR
SETID
MFG_ID

Published December 16, 2006