PROD_ITEMVW (SQL View)	Index Back
OM Product Item This record holds all the Product attributes for an Order Management Product. Added product type for PDM enhancement.

PROD_ITEMVW

(SQL View)

OM Product Item

This record holds all the Product attributes for an Order Management Product. Added product type for PDM enhancement.

SELECT SETID ,PRODUCT_ID ,DESCR FROM PS_PROD_ITEM

Related Language Record: RC_PRODVW_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PRODUCT_SETID Character(5) VARCHAR2(5) NOT NULL This is the field for Dashboard setid recname.

2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
Default Value: NEXT

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PRODUCT_SETID	Character(5)	VARCHAR2(5) NOT NULL	This is the field for Dashboard setid recname.
2	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID Default Value: NEXT
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description