OMPB_RULE

(SQL Table)
 Index Back

Customer Price Book Price Rule

Customer Price Book Price Rule

  • Parent record: OMPB_INSTANCE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 OMPB_BOOK_DEFN_ID Character(30) VARCHAR2(30) NOT NULL Customer Price Book Definition ID
    3 OMPB_BOOK_ID Character(30) VARCHAR2(30) NOT NULL Customer Price Book ID
    4 OMPB_INSTANCE Number(10,0) DECIMAL(10) NOT NULL price book instance
    5 EOEP_RULE_ID Character(30) VARCHAR2(30) NOT NULL Price Rule ID
    6 OMPB_ACTIVE_ROW Character(1) VARCHAR2(1) NOT NULL Flag to indicate if the row in the extract table is avtive/valid data. This is not really the same as effective date/status related.
    1=Active Row
    2=Inactive Row
    7 MERCH_TYPE Character(10) VARCHAR2(10) NOT NULL Merchandising Type

    Prompt Table: %EDITTABLE6

    8 PRICEPGM_FLAG Character(1) VARCHAR2(1) NOT NULL Exclusive Pricing Only
    N=No
    Y=Yes
    9 EOEP_ACTION_TYPE Character(2) VARCHAR2(2) NOT NULL Action Type
    1=Discount/Surcharge
    10=CRM Free Period Promotion
    11=CRM Product Add
    12=Pricing Base
    13=Rollup Only Rule
    14=Min/Max Margin
    2=Price Override
    3=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

    10 EOEP_APP_CD Character(4) VARCHAR2(4) NOT NULL Transaction Code

    Prompt Table: EOEP_APPCODE_VW

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

    Default Value: N

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

    Default Value: P

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

    Default Value: N

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

    Default Value: N

    17 EOEP_LONG Long Character CLOB Price Rule Definition
    18 EOEP_SOURCE Character(1) VARCHAR2(1) NOT NULL Source of pricing data
    1=Enterprise Pricer
    2=Promotion Management
    19 EOEP_ONETIME_FLG Character(1) VARCHAR2(1) NOT NULL One-Time Flag
    1=No
    2=Per Customer
    3=Per Rule

    Default Value: 1

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

    Default Value: 1

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

    Prompt Table: EOEP_ROLL_RL_VW

    22 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

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

    Default Value: N

    24 EOEP_TIERED_INCRE Signed Number(19,4) DECIMAL(17,4) NOT NULL Numeric Value
    25 EOEP_MEPR_FLG Character(1) VARCHAR2(1) NOT NULL Mutually Exclusive Pricing Rule
    N=No
    Y=Yes

    Default Value: N

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

    Prompt Table: UNITS_TBL

    28 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

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

    Default Value: Y

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

    Default Value: N

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

    Default Value: N

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

    Default Value: N

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

    Prompt Table: EOEP_RNDRL_HDR

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

    Default Value: N

    36 EOEP_CHILD_CDS Character(64) VARCHAR2(64) NOT NULL Child Applications
    37 EOEP_PRC_MATCH_FLG Character(1) VARCHAR2(1) NOT NULL Indicate what to use to match price break
    B=Base Price
    N=Net Price

    Default Value: B