RBT_PRD_DF_SRCH

(SQL View)
 Index Back

Com Product search

This view filters out Product attributes for Communications market

SELECT A.SETID , A.PRODUCT_ID , A.DESCR , A.PROD_TYPE , A.PRODUCT_KIT_FLAG , A.MARKET FROM PS_PROD_ITEM A WHERE A.MARKET='COM'

  • Related Language Record: RBT_PRD_DFLSRCH

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Default Value: OPR_DEF_TBL_RB.SETID

    Prompt Table: SP_SETID_NONVW

    2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 PROD_TYPE Character(4) VARCHAR2(4) NOT NULL A new field has been introduced as Product Type to distingush the product types like, Physical Products and Service Products. It is used for PDM enhancement.
    AGR=Service Agreement
    CMT=Commitment Product
    ENG=Engagement Service
    PHY=Standard Product
    PKG=Package Product
    SUB=Subscription Product
    SVC=Service Product
    5 PRODUCT_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Product Kit Flag

    Y/N Table Edit

    Default Value: N

    6 MARKET Character(3) VARCHAR2(3) NOT NULL Market