EOEP_RLSRCH_VW

(SQL View)
 Index Back

Price Rule (excl. prc lst only

A price rule is the combination of a Price Condition and a Price Formula. This is the entity that the pricing manager creates.

SELECT a.setid , a.eoep_rule_id , a.eoep_app_cd , a.eoep_rule_status , a.descr20 , a.eoep_action_type , a.eoep_adj_method , a.eoep_stop_flg , a.eoep_use_grc_days , a.eoep_ptd_flg , a.eoep_td_promo_cd , a.merch_type FROM PS_EOEP_RULE a WHERE a.eoep_action_type NOT IN ('8','99')

  • Related Language Record: EOEP_RLSRCH_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 EOEP_RULE_ID Character(30) VARCHAR2(30) NOT NULL Price Rule ID
    3 EOEP_APP_CD Character(4) VARCHAR2(4) NOT NULL Transaction Code

    Prompt Table: EOEP_APPCODE_VW

    4 EOEP_RULE_STATUS Character(1) VARCHAR2(1) NOT NULL Rule Status
    D=Deployed
    I=Inactive
    P=Pending
    R=Ready To Test
    5 EOEP_DESCR20 Character(20) VARCHAR2(20) NOT NULL Power Price description field
    6 EOEP_ACTION_TYPE Character(2) VARCHAR2(2) NOT NULL Action Type
    1=Discount/Surcharge
    10=Free Period Promotion
    11=Product Add
    12=Price Base
    13=Rollup Only Rule
    14=Min/Max Margin
    15=Recurring Discount/Surcharge
    2=Price Override
    3=Giveaway / Product Add
    4=Total Order Discount/Surcharge
    5=Min/Max Target Price
    6=Min/Max Target Discount
    7=Min/Max Target Surcharge
    8=Related Busines Objects
    9=Price List Only Condition
    99=Standard Discount

    Prompt Table: EOEP_ACTVAL_VW

    7 EOEP_ADJ_METHOD Character(1) VARCHAR2(1) NOT NULL Adjustment Method
    1=Cascading
    2=Summed
    8 EOEP_STOP_FLG Character(1) VARCHAR2(1) NOT NULL Stop Processing
    N=No
    Y=Yes

    Default Value: N

    9 EOEP_USE_GRC_DAYS Character(1) VARCHAR2(1) NOT NULL Use Grace Days
    N=No
    Y=Yes

    Default Value: N

    10 EOEP_PTD_FLG Character(1) VARCHAR2(1) NOT NULL Period To Date flag
    N=No
    R=By Rule
    Y=By Customer

    Default Value: N

    11 EOEP_TD_PROMO_CD Character(20) VARCHAR2(20) NOT NULL Period to date pricing

    Prompt Table: %EDITTABLE7

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

    Prompt Table: %EDITTABLE6