BI_OMPRC_ADJ_VW(SQL View) |
Index Back |
|---|---|
Billing-OM price adjustment Vw |
| SELECT BUSINESS_UNIT , ORDER_NO , ORDER_INT_LINE_NO , SCHED_LINE_NBR , PRC_SCHED_NBR , SEQ_NUM , EOEP_RULE_ID , EOEP_ACTION_TYPE , EOEP_ADJ_METHOD , OM_ADJST_FLG , OM_ADJST_AMT , OM_ADJST_AMT_BSE , OM_AMOUNT , OM_AMOUNT_BSE , CURRENCY_CD , CURRENCY_CD_BASE , EOEP_DATE_BREAK , EOEP_FORM_BREAK 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 |
| 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_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 |
| 9 | EOEP_ADJ_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Adjustment Method
1=Cascading 2=Summed |
| 10 | OM_ADJST_FLG | Character(2) | VARCHAR2(2) NOT NULL |
Adjustment Flag
1=Adjustment Percentage 2=Adjustment Amount 3=Replace Price |
| 11 | OM_ADJST_AMT | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | Order Adjustment Amount |
| 12 | OM_ADJST_AMT_BSE | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | Adjustment Amount (Base) |
| 13 | OM_AMOUNT | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | Amount |
| 14 | OM_AMOUNT_BSE | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | Amount |
| 15 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 16 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |
| 17 | EOEP_DATE_BREAK | Character(30) | VARCHAR2(30) NOT NULL | Date Break |
| 18 | EOEP_FORM_BREAK | Character(30) | VARCHAR2(30) NOT NULL | Formula Break |