TD_ALLOWANCE_VW

(SQL View)
 Index Back

National Allowances


SELECT DISTINCT D.OPRID , A.SETID , A.PPRC_PROMO_CD , A.DESCR , A.DESCRSHORT FROM PS_PPRC_PROMO_TBL A , PS_TD_ALLOW_MASTER B , PS_TD_TREE_NODE_VW D , PS_SET_CNTRL_REC SC WHERE SC.SETCNTRLVALUE = A.SETID AND SC.RECNAME = 'PROD_ITEM' AND SC.SETID = D.SETID AND A.TD_TREE_ID_PROD = D.TD_TREE_ID AND %EffdtCheck(TD_TREE_HDR TH, D, %CurrentDateIn) AND A.SETID = B.SETID AND A.PPRC_PROMO_CD = B.PPRC_PROMO_CD AND A.PROMO_TYPE = 'A' AND (B.PROMO_GROUP = D.PROMO_GROUP OR B.PRODUCT_ID = D.PRODUCT_ID)

  • Related Language Record: TD_ALLOW_LNG_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

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETTD_NONVW

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

    Default Value: NEXT

    Prompt Table: TD_PROM_AUTO_VW

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description