OMBI_DS_STD_VW (SQL View)	Index Back
OMBILL Standard Discount View This view is used to pick up all the standard discounts on a sales order.

OMBI_DS_STD_VW

(SQL View)

OMBILL Standard Discount View

This view is used to pick up all the standard discounts on a sales order.

SELECT a.business_unit , a.intfc_id ,a.intfc_line_num ,1 ,'Std Discount' , 'D' , a.dst_id_dis , a.dst_id_sur , a.bi_currency_cd ,a.base_currency , a.std_discount , 0 , a.net_extended_amt , a.gross_amt , a.list_price , a.unit_amt , a.qty ,'Standard Discount' ,' ' , a.business_unit_OM , A.ORDER_no , '1' , '2' , 500 , a.process_instance FROM PS_OMBI_INTFC_TMP a WHERE a.std_discount <> 0 AND a.cntrct_line_nbr = 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 DST_ID_DIS Character(10) VARCHAR2(10) NOT NULL Discount Distribution Code

8 DST_ID_SUR Character(10) VARCHAR2(10) NOT NULL Surcharge Distribution Code

9 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code

10 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. "

11 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage

12 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

13 NET_EXTENDED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Net Extended Amt

14 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount

15 LIST_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price

16 UNIT_AMT Signed Number(17,4) DECIMAL(15,4) NOT NULL Unit Price

17 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity

18 DESCR Character(30) VARCHAR2(30) NOT NULL Description

19 EOEP_RULE_ID Character(30) VARCHAR2(30) NOT NULL Price Rule ID

20 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit

21 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

22 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

23 EOEP_ADJ_METHOD Character(1) VARCHAR2(1) NOT NULL Adjustment Method
1=Cascading
2=Summed

24 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

25 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

#	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	DST_ID_DIS	Character(10)	VARCHAR2(10) NOT NULL	Discount Distribution Code
8	DST_ID_SUR	Character(10)	VARCHAR2(10) NOT NULL	Surcharge Distribution Code
9	BI_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Billing Currency Code
10	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. "
11	PERCENTAGE	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Percentage
12	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
13	NET_EXTENDED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Net Extended Amt
14	GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Invoice Amount
15	LIST_PRICE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	List Price
16	UNIT_AMT	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Unit Price
17	QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity
18	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
19	EOEP_RULE_ID	Character(30)	VARCHAR2(30) NOT NULL	Price Rule ID
20	BUSINESS_UNIT_OM	Character(5)	VARCHAR2(5) NOT NULL	Order Management Business Unit
21	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
22	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
23	EOEP_ADJ_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Adjustment Method 1=Cascading 2=Summed
24	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
25	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance