EOEP_PROMO_VW

(SQL View)
 Index Back

Prompt view without promotions

Prompt view if promotion management is not installed

SELECT SETID , PPRC_PROMO_CD , DESCR , DESCRSHORT FROM PS_PPRC_PROMO_TBL WHERE (STATUS_TD = 'CA' OR ALLOW_STATUS = '4') AND EFF_STATUS = 'A'

  • Related Language Record: EOEP_PROMO_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID_INQ Character(5) VARCHAR2(5) NOT NULL SetID
    2 EOEP_TD_PROMO_CD Character(20) VARCHAR2(20) NOT NULL Period to date pricing
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description