PROD_ITEM_CSVW

(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 , O.OPRID FROM PS_PROD_ITEM A , PS_SEC_SETID_CLS F , PSOPRDEFN O WHERE A.SETID=F.SETID AND F.OPRCLASS = O.ROWSECCLASS

  • 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
    4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).