TD_PRO_CUS_M_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 , C.DESCR , A.STATUS_TD , B.MERCH_COST , A.CURRENCY_CD , A.PROMO_GROUP , A.PRODUCT_ID , A.BUSINESS_UNIT_GL , B.DST_ID FROM PS_TD_PROMO_CUST A , PS_TD_PRO_MERC_CUS B , PS_TD_MERCH_TYPE C , PS_SET_CNTRL_REC D 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

  • Related Language Record: TD_PROCUMLNG_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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 STATUS_TD Character(2) VARCHAR2(2) NOT NULL Promotion Status
    CA=Customer Approved
    CE=Customer Cancelled
    CL=Closed
    CR=Customer Rejected
    MA=Management Approved
    MR=Management Rejected
    PA=Pending Approval
    PL=Planned
    RE=Recalled
    RL=Released
    7 MERCH_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Merchandising Cost
    8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    9 PROMO_GROUP Character(10) VARCHAR2(10) NOT NULL Promotional Group
    10 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

    Prompt Table: PROD_ITEM
    Set Control Field: SETID

    11 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

    Prompt Table: SP_BUTDGL_NONVW

    12 DST_ID Character(10) VARCHAR2(10) NOT NULL Distribution Code

    Prompt Table: DSTCD_DIS_OM_VW