EOEP_RULE

(SQL Table)
 Index Back

Price Rule

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

  • Related Language Record: EOEP_RULE_LNG

    • # 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 DESCR20 Character(20) VARCHAR2(20) NOT NULL Description
    4 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    5 EOEP_APP_CD Character(4) VARCHAR2(4) NOT NULL Transaction Code

    Default Value: OC

    Prompt Table: EOEP_APPCODE_VW

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

    Prompt Table: %EDITTABLE6

    7 PRICEPGM_FLAG Character(1) VARCHAR2(1) NOT NULL Exclusive Pricing Only
    N=No
    Y=Yes

    Default Value: N

    8 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

    9 EOEP_RECUR_FLG Character(1) VARCHAR2(1) NOT NULL Recurring price flag.
    N=No
    Y=Yes

    Default Value: N

    10 EOEP_ADJ_METHOD Character(1) VARCHAR2(1) NOT NULL Adjustment Method
    1=Cascading
    2=Summed
    11 EOEP_PTD_FLG Character(1) VARCHAR2(1) NOT NULL Period To Date flag
    N=No
    R=By Rule
    Y=By Customer

    Default Value: N

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

    Default Value: P

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

    Default Value: N

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

    Prompt Table: %EDITTABLE7

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

    Default Value: N

    16 EOEP_LONG Long Character CLOB Price Rule Definition
    17 EOEP_SOURCE Character(1) VARCHAR2(1) NOT NULL Source of pricing data
    1=Enterprise Pricer
    2=Promotion Management

    Default Value: 1

    18 EOEP_ONETIME_FLG Character(1) VARCHAR2(1) NOT NULL One-Time Flag
    1=No
    2=Per Customer
    3=Per Rule

    Default Value: 1

    19 EOEP_ROLLUP_FLG Character(1) VARCHAR2(1) NOT NULL Rollup By Flag
    1=Transaction
    2=Line
    3=Schedule
    4=Rollup Rule

    Default Value: 1

    20 EOEP_ROLLUP_RULE Character(30) VARCHAR2(30) NOT NULL Rollup Rule ID

    Prompt Table: EOEP_ROLL_RL_VW

    21 EOEP_PRCBASE_FLG Character(1) VARCHAR2(1) NOT NULL Pricing Base Flag
    1=List Price
    2=Cost
    3=Buying Agreement
    4=Alternate Cost

    Default Value: 1

    22 EOEP_TIERED_FLG Character(1) VARCHAR2(1) NOT NULL Tiered Pricing Flag
    N=No
    Y=Yes

    Default Value: N

    23 EOEP_TIERED_INCRE Signed Number(19,4) DECIMAL(17,4) NOT NULL Numeric Value

    Default Value: 1

    24 EOEP_MEPR_FLG Character(1) VARCHAR2(1) NOT NULL Mutually Exclusive Pricing Rule
    N=No
    Y=Yes

    Default Value: N

    25 EOEP_MAX_QUANTITY Number(16,4) DECIMAL(15,4) NOT NULL Max Quantity
    26 EOEP_MAXQTY_UOM Character(3) VARCHAR2(3) NOT NULL Max Quantity UOM

    Prompt Table: UNITS_TBL

    27 EOEP_RULEXCL_FLG Character(1) VARCHAR2(1) NOT NULL Rule Exclude
    1=None
    2=KVI Products
    3=NDP Products
    4=KVI & NDP Products

    Default Value: 1

    28 EOEP_LISTUSE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates whether to use list price.
    N=No
    Y=Yes

    Default Value: Y

    29 EOEP_BAUSE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates whether to use with buying agreement.
    N=No
    Y=Yes

    Default Value: N

    30 EOEP_COSTUSE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates whether to use cost.
    N=No
    Y=Yes

    Default Value: N

    31 EOEP_ALTCSTUSE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates whether to apply to alternate cost base.
    N=No
    Y=Yes

    Default Value: N

    32 EOEP_ROUND_ID Character(15) VARCHAR2(15) NOT NULL Rounding ID

    Prompt Table: EOEP_RNDRL_HDR

    33 EOEP_ROUND_FLG Character(1) VARCHAR2(1) NOT NULL Rouding Flag
    0=None
    1=Net Price
    2=Adjustment
    3=Both
    34 EOEP_UOMROLLUP_FLG Character(1) VARCHAR2(1) NOT NULL Indicate whether the rollup is by UOM
    N=No
    Y=Yes

    Default Value: N

    35 DTTIME_ADDED DateTime(26) TIMESTAMP Date Time Added
    36 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.
    37 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL This field determines the last user or operator that last changed this item.