OMBI_DS_VW

(SQL View)
 Index Back

OM Bill Percent Disc/Sur Vw

OMBILL uses this view to determine what Discount and Surcharge percentages for the Order Schedule should passed to billing and the invoice.

SELECT a.business_unit , a.intfc_id , a.intfc_line_num , b.seq_num + 1 , 'PRICEADJST' , 'D' , a.bi_currency_cd , a.base_currency , b.om_adjst_amt , b.om_adjst_amt , b.om_amount , b.om_adjst_amt , 'Order Price Adjustment' , b.eoep_rule_id , b.eoep_action_type , b.eoep_adj_method , b.eoep_adjust_type , a.dst_id_dis , a.dst_id_sur , a.GROSS_extended_AMT , a.gross_amt , a.qty , a.business_unit_om , a.order_no , a.order_int_line_no , a.sched_line_nbr , b.seq_num , a.product_id , a.product_kit_id , a.vat_kit_pct , a.process_instance , a.add_dttm , a.last_update_dttm , b.pprc_promo_cd , b.merch_type FROM PS_OMBI_INTFC_TMP a , ps_ord_price_adjst b WHERE a.business_unit_om = b.business_unit AND a.order_no = b.order_no AND a.order_int_line_no = b.order_int_line_no AND a.sched_line_nbr = b.sched_line_nbr AND B.ORDER_INT_LINE_NO <> 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 INTFC_ID Number(8,0) INTEGER NOT NULL Interface ID
3 INTFC_LINE_NUM Number(8,0) INTEGER NOT NULL Interface Line Number
4 DISC_SUR_LVL Number(2,0) SMALLINT NOT NULL Discount/Surcharge Level
5 DISC_SUR_ID Character(15) VARCHAR2(15) NOT NULL Identifier
6 DISC_SUR_INDICATOR Character(1) VARCHAR2(1) NOT NULL Discount/Surcharge
D=Discount
I=Installment Surcharge
S=Surcharge
7 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code
8 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
9 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
10 OM_ADJST_AMT Signed Number(19,4) DECIMAL(17,4) NOT NULL Order Adjustment Amount
11 OM_AMOUNT Signed Number(19,4) DECIMAL(17,4) NOT NULL Amount
12 PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL This is price per unit for calculating the service charge.
13 DESCR Character(30) VARCHAR2(30) NOT NULL Description
14 EOEP_RULE_ID Character(30) VARCHAR2(30) NOT NULL Price Rule ID
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
16 EOEP_ADJ_METHOD Character(1) VARCHAR2(1) NOT NULL Adjustment Method
1=Cascading
2=Summed
17 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
18 DST_ID_DIS Character(10) VARCHAR2(10) NOT NULL Discount Distribution Code
19 DST_ID_SUR Character(10) VARCHAR2(10) NOT NULL Surcharge Distribution Code
20 GROSS_EXTENDED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Extended
21 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
22 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
23 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
24 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
25 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
26 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
27 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
28 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
29 PRODUCT_KIT_ID Character(18) VARCHAR2(18) NOT NULL Product Kit Number
30 VAT_KIT_PCT Number(3,0) SMALLINT NOT NULL % of Kit Value for VAT
31 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
32 ADD_DTTM DateTime(26) TIMESTAMP Date Time Added
33 LAST_UPDATE_DTTM 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.
34 PPRC_PROMO_CD Character(20) VARCHAR2(20) NOT NULL Price Promotion Code
35 MERCH_TYPE Character(10) VARCHAR2(10) NOT NULL Merchandising Type