PROD_ITEM_OPVW

(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.

SELECT A.SETID ,A.PRODUCT_ID ,A.DESCR FROM PS_PROD_ITEM A , PS_SEC_SETID_OPR F WHERE A.SETID=F.SETID

  • 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