OMPB_PRCADJ_INT

(SQL Table)
Index Back

Customer Price Book Adj View

Customer Price Book Adj View

  • Parent record: OMPB_BOOK_INT
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 OMPB_BOOK_DEFN_ID Character(30) VARCHAR2(30) NOT NULL Customer Price Book Definition ID
    4 OMPB_BOOK_ID Character(30) VARCHAR2(30) NOT NULL Customer Price Book ID
    5 OMPB_INSTANCE Number(10,0) DECIMAL(10) NOT NULL price book instance
    6 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
    7 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    8 PRODUCT_UOM Character(3) VARCHAR2(3) NOT NULL Product Unit of Measure
    9 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    10 OMPB_CHANGE_FLG Character(1) VARCHAR2(1) NOT NULL Change flag
    A=Added
    D=Deleted
    M=Modified
    N=No Change
    11 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    12 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    13 EOEP_RULE_ID Character(30) VARCHAR2(30) NOT NULL Price Rule ID
    14 EOEP_FORMULA_ID Number(10,0) DECIMAL(10) NOT NULL Pricing Formula ID
    15 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
    16 OMPB_CHANGE_FLGX Character(30) VARCHAR2(30) NOT NULL Change flag
    17 OMPB_ACTIVE_ROWX Character(30) VARCHAR2(30) NOT NULL field to hold the translated xlat values for OMPB_ACTIVE_ROW
    18 MERCH_TYPE Character(10) VARCHAR2(10) NOT NULL Merchandising Type

    Prompt Table: %EDITTABLE6

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

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

    Prompt Table: EOEP_APPCODE_VW

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

    Default Value: N

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

    Default Value: P

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

    Default Value: N

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

    Default Value: N

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

    Default Value: 1

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

    Default Value: 1

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

    Prompt Table: EOEP_ROLL_RL_VW

    33 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

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

    Default Value: N

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

    Default Value: N

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

    Prompt Table: UNITS_TBL

    39 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

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

    Default Value: Y

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

    Default Value: N

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

    Default Value: N

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

    Default Value: N

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

    Prompt Table: EOEP_RNDRL_HDR

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

    Default Value: N

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

    49 OMPB_ACTION_TYPEX Character(30) VARCHAR2(30) NOT NULL Action Type
    50 OMPB_ADJ_METHODX Character(30) VARCHAR2(30) NOT NULL Adjustment Method
    51 OMPB_PTD_FLGX Character(30) VARCHAR2(30) NOT NULL Period To Date flag
    52 OMPB_RULE_STATUSX Character(30) VARCHAR2(30) NOT NULL Rule Status
    53 OMPB_STOP_FLGX Character(30) VARCHAR2(30) NOT NULL Stop Processing
    54 OMPB_USE_GRC_DAYSX Character(30) VARCHAR2(30) NOT NULL Use Grace Days
    55 OMPB_SOURCEX Character(30) VARCHAR2(30) NOT NULL Source of pricing data
    56 OMPB_ONETIME_FLGX Character(30) VARCHAR2(30) NOT NULL One-Time Flag
    57 OMPB_ROLLUP_FLGX Character(30) VARCHAR2(30) NOT NULL Rollup By Flag
    58 OMPB_PRCBASE_FLGX Character(30) VARCHAR2(30) NOT NULL Pricing Base Flag
    59 OMPB_TIERED_FLGX Character(30) VARCHAR2(30) NOT NULL Tiered Pricing Flag
    60 OMPB_MEPR_FLGX Character(30) VARCHAR2(30) NOT NULL Mutually Exclusive Pricing Rule
    61 OMPB_RULEXCL_FLGX Character(30) VARCHAR2(30) NOT NULL Rule Exclude
    62 OMPB_LISTUSE_FLGX Character(30) VARCHAR2(30) NOT NULL Indicates whether to use list price.
    63 OMPB_BAUSE_FLGX Character(30) VARCHAR2(30) NOT NULL Indicates whether to use with buying agreement.
    64 OMPB_COSTUSE_FLGX Character(30) VARCHAR2(30) NOT NULL Indicates whether to use cost.
    65 OMPB_ALTCSTUSE_FLX Character(30) VARCHAR2(30) NOT NULL Indicates whether to apply to alternate cost base.
    66 OMPB_ROUND_FLGX Character(30) VARCHAR2(30) NOT NULL Rouding Flag
    67 OMPB_UOMROLLUP_FLX Character(30) VARCHAR2(30) NOT NULL Indicate whether the rollup is by UOM
    68 OMPB_PRC_MATCH_FLX Character(30) VARCHAR2(30) NOT NULL Indicate what to use to match price break
    69 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
    70 EOEP_NUM_VALUE Signed Number(19,4) DECIMAL(17,4) NOT NULL Numeric Value
    71 EOEP_TEXT_VALUE Character(254) VARCHAR2(254) NOT NULL Text Value
    72 EOEP_DATE_BREAK Character(30) VARCHAR2(30) NOT NULL Date Break
    73 EOEP_FORM_BREAK Character(30) VARCHAR2(30) NOT NULL Formula Break
    74 RT_RATE_INDEX Character(10) VARCHAR2(10) NOT NULL Market Rate Index

    Prompt Table: RT_INDEX_EI_VW

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

    Prompt Table: CURRENCY_CD_TBL

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

    Prompt Table: PROD_ITEM

    78 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

    79 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
    80 EOEP_FREEBIE_TYPE Character(4) VARCHAR2(4) NOT NULL Pricing giveaway type.
    LINE=Per Line
    ORD=Per Order
    81 EOEP_MAX_AMOUNT Signed Number(19,4) DECIMAL(17,4) NOT NULL Maximum Amount
    82 EOEP_MIN_AMOUNT Signed Number(19,4) DECIMAL(17,4) NOT NULL Minimum Amount
    83 EOEP_MRGBASE_FLG Character(1) VARCHAR2(1) NOT NULL Margin Base
    1=Cost
    2=Alternate
    84 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

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

    Prompt Table: PROD_UOM_PRC_VW

    86 OMPB_ADJST_FLGX Character(30) VARCHAR2(30) NOT NULL Adjustment Flag
    87 OMPB_SELSMLG_FLGX Character(30) VARCHAR2(30) NOT NULL Small or Large
    88 OMPB_ADJUST_TYPEX Character(30) VARCHAR2(30) NOT NULL Adjustment Type Bill-Back or Off-Invoice
    89 OMPB_FREEBIE_TYPEX Character(30) VARCHAR2(30) NOT NULL Pricing giveaway type.
    90 OMPB_MRGBASE_FLGX Character(30) VARCHAR2(30) NOT NULL Margin Base