TD_PROCUMLNG_VW

(SQL View)
 Index Back

Promotion, cust, merch view

List all Promotions/ Merch Activities for a Customer

SELECT A.SETID , A.CUST_ID , A.PPRC_PROMO_CD , B.MERCH_TYPE , E.LANGUAGE_CD , C.DESCR FROM PS_TD_PROMO_CUST A , PS_TD_PRO_MERC_CUS B , PS_TD_MERCH_TYPE C , PS_SET_CNTRL_REC D , PS_TD_MRCH_TYP_LNG E WHERE A.SETID = B.SETID AND A.PPRC_PROMO_CD = B.PPRC_PROMO_CD AND A.CUST_ID = B.CUST_ID AND A.status_td NOT IN ('CR', 'MR') AND A.SETID = D.SETCNTRLVALUE AND D.RECNAME = 'TD_MERCH_TYPE' AND D.SETID = C.SETID AND B.MERCH_TYPE = C.MERCH_TYPE AND C.SETID = E.SETID AND C.MERCH_TYPE = E.MERCH_TYPE AND C.EFFDT = E.EFFDT

  • Related Language Record for TD_PRO_CUS_M_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETTD_NONVW

    2 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

    Prompt Table: TD_CUST_OPRVW

    3 PPRC_PROMO_CD Character(20) VARCHAR2(20) NOT NULL Price Promotion Code

    Prompt Table: PPRC_PROMO_TBL

    4 MERCH_TYPE Character(10) VARCHAR2(10) NOT NULL Merchandising Type

    Prompt Table: TD_MERCH_TYP_VW
    Set Control Field: SETID

    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description