TD_PROCU_LNG_VW

(SQL View)
 Index Back

Cust Promotion language view


SELECT DISTINCT A.OPRID , A.SETID , C.PPRC_PROMO_CD , C.CUST_ID , G.LANGUAGE_CD , G.DESCR , G.DESCRSHORT FROM PS_TD_APPR_NODE_VW A , PS_TD_TREE_NODE B , PS_TD_PROMO_CUST C , PS_TD_SETID_TBL D , PS_PPRC_PROMO_TBL E , PS_SET_CNTRL_REC F , PS_PPRC_PROTBL_LNG G WHERE A.SETID = F.SETCNTRLVALUE AND F.RECNAME = 'TD_SETID_TBL' AND A.SETID = B.SETID AND A.TD_TREE_ID = B.TD_TREE_ID AND A.CUST_ID = B.CUST_ID AND F.SETID = D.SETID AND A.TD_TREE_ID = D.TD_TREE_ID_CUST AND A.SETID = C.SETID AND A.CUST_ID = C.CUST_ID AND A.SETID = E.SETID AND C.PPRC_PROMO_CD = E.PPRC_PROMO_CD AND E.SETID = G.SETID AND E.PPRC_PROMO_CD = G.PPRC_PROMO_CD

  • Related Language Record for TD_PRO_CUS_S_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETTD_NONVW

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

    Prompt Table: TD_PROM_AUTO_VW

    4 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.
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description