OMPB_PRCADJ_VW

(SQL View)
 Index Back

Customer Price Book Adj View

Customer Price Book Adj View

SELECT A.BUSINESS_UNIT , A.OMPB_BOOK_DEFN_ID , A.OMPB_BOOK_ID , A.OMPB_INSTANCE , A.SOLD_TO_CUST_ID , A.PRODUCT_ID , A.UNIT_OF_MEASURE , A.SEQ_NBR , A.OMPB_CHANGE_FLG , A.EOEP_RULE_ID , A.EOEP_FORMULA_ID , A.OMPB_ACTIVE_ROW , %subrec(EOEP_RULEF1_SBR, R) , %subrec(EOEP_FORMF_SBR, F) FROM PS_OMPB_PRC_ADJST A , PS_OMPB_RULE R , PS_OMPB_FORMULA F WHERE %Join(COMMON_KEYS, OMPB_PRC_ADJST A, OMPB_RULE R) AND %Join(COMMON_KEYS, OMPB_RULE R, OMPB_FORMULA F) AND A.EOEP_RULE_ID = R.EOEP_RULE_ID AND A.OMPB_ACTIVE_ROW = R.OMPB_ACTIVE_ROW AND A.EOEP_FORMULA_ID = F.EOEP_FORMULA_ID AND A.OMPB_ACTIVE_ROW = F.OMPB_ACTIVE_ROW

  • Parent record: OMPB_BOOK_VW

    • # 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 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
    6 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    7 PRODUCT_UOM Character(3) VARCHAR2(3) NOT NULL Product Unit of Measure
    8 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    9 OMPB_CHANGE_FLG Character(1) VARCHAR2(1) NOT NULL Change flag
    A=Added
    D=Deleted
    M=Modified
    N=No Change
    10 EOEP_RULE_ID Character(30) VARCHAR2(30) NOT NULL Price Rule ID
    11 EOEP_FORMULA_ID Number(10,0) DECIMAL(10) NOT NULL Pricing Formula ID
    12 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
    13 MERCH_TYPE Character(10) VARCHAR2(10) NOT NULL Merchandising Type

    Prompt Table: %EDITTABLE6

    14 PRICEPGM_FLAG Character(1) VARCHAR2(1) NOT NULL Exclusive Pricing Only
    N=No
    Y=Yes
    15 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

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

    Prompt Table: EOEP_APPCODE_VW

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

    Default Value: N

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

    Default Value: P

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

    Default Value: N

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

    Default Value: N

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

    Default Value: 1

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

    Default Value: 1

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

    Prompt Table: EOEP_ROLL_RL_VW

    28 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

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

    Default Value: N

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

    Default Value: N

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

    Prompt Table: UNITS_TBL

    34 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

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

    Default Value: Y

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

    Default Value: N

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

    Default Value: N

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

    Default Value: N

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

    Prompt Table: EOEP_RNDRL_HDR

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

    Default Value: N

    42 EOEP_CHILD_CDS Character(64) VARCHAR2(64) NOT NULL Child Applications
    43 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

    44 EOEP_ADJST_FLG Character(2) VARCHAR2(2) NOT NULL Adjustment Flag
    01=Amount
    02=Percentage
    03=Price
    04=External Class
    05=Math Expression
    06=Quantity
    07=BOGO Factor
    08=Quantity with Price
    09=BOGO with Price
    10=Quantity Expression
    11=Amount And Math Expression
    12=Percentage And Math Expression
    13=Price And Math Expression
    45 EOEP_NUM_VALUE Signed Number(19,4) DECIMAL(17,4) NOT NULL Numeric Value
    46 EOEP_TEXT_VALUE Character(254) VARCHAR2(254) NOT NULL Text Value
    47 EOEP_DATE_BREAK Character(30) VARCHAR2(30) NOT NULL Date Break
    48 EOEP_FORM_BREAK Character(30) VARCHAR2(30) NOT NULL Formula Break
    49 RT_RATE_INDEX Character(10) VARCHAR2(10) NOT NULL Market Rate Index

    Prompt Table: RT_INDEX_EI_VW

    50 EOEP_SELSMLG_FLG Character(1) VARCHAR2(1) NOT NULL Small or Large
    1=Smaller
    2=Larger
    51 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    52 PRODUCT_ID_PROMO Character(18) VARCHAR2(18) NOT NULL Promotional Product ID

    Prompt Table: PROD_ITEM

    53 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.

    Prompt Table: %EDITTABLE

    54 EOEP_ADJUST_TYPE Character(3) VARCHAR2(3) NOT NULL Adjustment Type Bill-Back or Off-Invoice
    AC=Bill Back
    AMT=Amount
    OI=Off-Invoice
    OVR=Price Override
    PCT=Percent
    55 EOEP_FREEBIE_TYPE Character(4) VARCHAR2(4) NOT NULL Pricing giveaway type.
    LINE=Per Line
    ORD=Per Order
    56 EOEP_MAX_AMOUNT Signed Number(19,4) DECIMAL(17,4) NOT NULL Maximum Amount
    57 EOEP_MIN_AMOUNT Signed Number(19,4) DECIMAL(17,4) NOT NULL Minimum Amount
    58 EOEP_MRGBASE_FLG Character(1) VARCHAR2(1) NOT NULL Margin Base
    1=Cost
    2=Alternate
    59 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Prompt Table: %EDITTABLE2

    60 UOM_PROMO Character(4) VARCHAR2(4) NOT NULL Unit of Measure (promo prod)

    Prompt Table: PROD_UOM_PRC_VW