EOEP_RULE_VW

(SQL View)
 Index Back

Price Rule View

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

SELECT SETID , eoep_RULE_ID , DESCR20 , DESCR100 , MERCH_TYPE , PRICEPGM_FLAG , eoep_ACTION_TYPE , eoep_ADJ_METHOD , eoep_APP_CD , eoep_PTD_FLG , eoep_RULE_STATUS , eoep_STOP_FLG , eoep_TD_PROMO_CD , eoep_USE_GRC_DAYS , eoep_LONG , EOEP_SOURCE , DTTIME_ADDED , LASTUPDDTTM , LAST_MAINT_OPRID FROM PS_EOEP_RULE

  • Related Language Record: EOEP_RULE_VW_LG

    • # 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

    Prompt Table: EOEP_EPPRSQ_VW

    3 DESCR20 Character(20) VARCHAR2(20) NOT NULL Description 20
    4 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    5 MERCH_TYPE Character(10) VARCHAR2(10) NOT NULL Merchandising Type
    6 PRICEPGM_FLAG Character(1) VARCHAR2(1) NOT NULL Exclusive Pricing Only
    N=No
    Y=Yes
    7 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

    Default Value: 1

    8 EOEP_ADJ_METHOD Character(1) VARCHAR2(1) NOT NULL Adjustment Method
    1=Cascading
    2=Summed
    9 EOEP_APP_CD Character(4) VARCHAR2(4) NOT NULL Transaction Code

    Prompt Table: EOEP_APP_CODE

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

    Y/N Table Edit

    Default Value: N

    11 EOEP_RULE_STATUS Character(1) VARCHAR2(1) NOT NULL Rule Status
    D=Deployed
    I=Inactive
    P=Pending
    R=Ready To Test

    Default Value: I

    12 EOEP_STOP_FLG Character(1) VARCHAR2(1) NOT NULL Stop Processing
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    13 EOEP_TD_PROMO_CD Character(20) VARCHAR2(20) NOT NULL Period to date pricing
    14 EOEP_USE_GRC_DAYS Character(1) VARCHAR2(1) NOT NULL Use Grace Days
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    15 EOEP_LONG Long Character CLOB Price Rule Definition
    16 EOEP_SOURCE Character(1) VARCHAR2(1) NOT NULL Source of pricing data
    1=Enterprise Pricer
    2=Promotion Management
    17 DTTIME_ADDED DateTime(26) TIMESTAMP Date Time Added
    18 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    19 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL This field determines the last user or operator that last changed this item.