ORD_PRC_ADJ_VW

(SQL View)
 Index Back

Ord Line Price adjustments

This record holds an audit of all price adjustments made to an order line or schedule. Users may access this record to see an audit trail of discounts, surcharges or manual price changes to see how a net unit price has been derived.

SELECT business_unit , order_no , order_int_line_no , sched_line_nbr , prc_sched_nbr , seq_num , eoep_rule_id , eoep_formula_id , eoep_form_break , eoep_date_break , currency_cd , currency_cd_base , eoep_action_type , eoep_adj_method , eoep_adjust_type , eoep_arb_id , eoep_ptd_flg , merch_type , om_adjst_flg , om_adjst_amt , om_adjst_amt_bse , om_amount , om_amount_bse , om_prc_adjamt , om_prc_adjamt_bse , om_prc_amount , om_prc_amount_bse , pricing_uom , pricing_qty , order_flag , price_adjst_reason , price_program , pprc_promo_cd , setid , sequence_nbr , unit_of_measure , qty_ordered , eoep_text_value , eoep_onetime_flg , eoep_tiered_flg , eoep_mepr_flg , eoep_maxqty_uom , eoep_max_quantity , lastupddttm , last_maint_oprid FROM PS_ORD_PRICE_ADJST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BUS_UNIT_TBL_OM

2 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
3 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
4 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
5 PRC_SCHED_NBR Number(6,0) INTEGER NOT NULL Pricing Schedule Number
6 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
7 EOEP_RULE_ID Character(30) VARCHAR2(30) NOT NULL Price Rule ID
8 EOEP_FORMULA_ID Number(10,0) DECIMAL(10) NOT NULL Pricing Formula ID
9 EOEP_FORM_BREAK Character(30) VARCHAR2(30) NOT NULL Formula Break
10 EOEP_DATE_BREAK Character(30) VARCHAR2(30) NOT NULL Date Break
11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
12 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
13 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
14 EOEP_ADJ_METHOD Character(1) VARCHAR2(1) NOT NULL Adjustment Method
1=Cascading
2=Summed
15 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
16 EOEP_ARB_ID Character(10) VARCHAR2(10) NOT NULL Arbitration Plan
17 EOEP_PTD_FLG Character(1) VARCHAR2(1) NOT NULL Period To Date flag
N=No
R=By Rule
Y=By Customer
18 MERCH_TYPE Character(10) VARCHAR2(10) NOT NULL Merchandising Type
19 OM_ADJST_FLG Character(2) VARCHAR2(2) NOT NULL Adjustment Flag
1=Adjustment Percentage
2=Adjustment Amount
3=Replace Price
20 OM_ADJST_AMT Signed Number(19,4) DECIMAL(17,4) NOT NULL Order Adjustment Amount
21 OM_ADJST_AMT_BSE Signed Number(19,4) DECIMAL(17,4) NOT NULL Adjustment Amount (Base)
22 OM_AMOUNT Signed Number(19,4) DECIMAL(17,4) NOT NULL Amount
23 OM_AMOUNT_BSE Signed Number(19,4) DECIMAL(17,4) NOT NULL Amount
24 OM_PRC_ADJAMT Signed Number(19,4) DECIMAL(17,4) NOT NULL Adjust Amount/Percentage/Price
25 OM_PRC_ADJAMT_BSE Signed Number(19,4) DECIMAL(17,4) NOT NULL Adjust Amount/Percentage/Price
26 OM_PRC_AMOUNT Signed Number(19,4) DECIMAL(17,4) NOT NULL Pricing Adjustment Amount
27 OM_PRC_AMOUNT_BSE Signed Number(19,4) DECIMAL(17,4) NOT NULL Pricing Adjustment Amount
28 PRICING_UOM Character(3) VARCHAR2(3) NOT NULL Pricing UOM
29 PRICING_QTY Number(16,4) DECIMAL(15,4) NOT NULL Pricing quantity.
30 ORDER_FLAG Character(1) VARCHAR2(1) NOT NULL Total Order Flag
31 PRICE_ADJST_REASON Character(10) VARCHAR2(10) NOT NULL Price Adjustment Reason
32 PRICE_PROGRAM Character(10) VARCHAR2(10) NOT NULL Date Initials Issue Description 111701 dms F-CJORGENS-11 Add EXCL_PRICE_LBL
33 PPRC_PROMO_CD Character(20) VARCHAR2(20) NOT NULL Price Promotion Code
34 SETID Character(5) VARCHAR2(5) NOT NULL SetID
35 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number
36 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
37 QTY_ORDERED Signed Number(16,4) DECIMAL(14,4) NOT NULL Order Qty
38 EOEP_TEXT_VALUE Character(254) VARCHAR2(254) NOT NULL Text Value
39 EOEP_ONETIME_FLG Character(1) VARCHAR2(1) NOT NULL One-Time Flag
1=No
2=Per Customer
3=Per Rule
40 EOEP_TIERED_FLG Character(1) VARCHAR2(1) NOT NULL Tiered Pricing Flag
N=No
Y=Yes
41 EOEP_MEPR_FLG Character(1) VARCHAR2(1) NOT NULL Mutually Exclusive Pricing Rule
N=No
Y=Yes
42 EOEP_MAXQTY_UOM Character(3) VARCHAR2(3) NOT NULL Max Quantity UOM
43 EOEP_MAX_QUANTITY Number(16,4) DECIMAL(15,4) NOT NULL Max Quantity
44 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.
45 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID