OM_SOPRCADJ_VW (SQL View)	Index Back
SO Price Adjustments SO Price Adjustments

OM_SOPRCADJ_VW

(SQL View)

SO Price Adjustments

SELECT DISTINCT A.BUSINESS_UNIT , A.ORDER_NO , A.ORDER_INT_LINE_NO , A.SCHED_LINE_NBR , A.PRC_SCHED_NBR , ' ' , A.SETID , A.EOEP_RULE_ID , A.EOEP_FORMULA_ID , A.OM_ADJST_FLG , A.OM_PRC_ADJAMT , A.OM_PRC_AMOUNT , A.PRICING_UOM , A.PRICING_QTY , A.EOEP_MAX_QUANTITY , A.EOEP_MAXQTY_UOM , A.CURRENCY_CD , S.SOLD_TO_CUST_ID , A.LASTUPDDTTM FROM PS_ORD_PRICE_ADJST A , PS_ORD_SCH_ARCH S WHERE (A.ORDER_FLAG NOT IN ('Y','L') OR (A.ORDER_INT_LINE_NO = 0 AND A.SCHED_LINE_NBR = 0 AND A.PRC_SCHED_NBR = 0) ) AND A.BUSINESS_UNIT = S.BUSINESS_UNIT AND A.ORDER_NO = S.ORDER_NO

# 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 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID

7 SETID Character(5) VARCHAR2(5) NOT NULL SetID

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

9 EOEP_FORMULA_ID Number(10,0) DECIMAL(10) NOT NULL Pricing Formula ID

10 OM_ADJST_FLG Character(2) VARCHAR2(2) NOT NULL Adjustment Flag
1=Adjustment Percentage
2=Adjustment Amount
3=Replace Price

11 OM_PRC_ADJAMT Signed Number(19,4) DECIMAL(17,4) NOT NULL Adjust Amount/Percentage/Price

12 OM_PRC_AMOUNT Signed Number(19,4) DECIMAL(17,4) NOT NULL Pricing Adjustment Amount

13 PRICING_UOM Character(3) VARCHAR2(3) NOT NULL Pricing UOM

14 PRICING_QTY Number(16,4) DECIMAL(15,4) NOT NULL Pricing quantity.

15 EOEP_MAX_QUANTITY Number(16,4) DECIMAL(15,4) NOT NULL Max Quantity

16 EOEP_MAXQTY_UOM Character(3) VARCHAR2(3) NOT NULL Max Quantity UOM

17 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

18 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

19 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.

#	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	DELIVERY_ID	Character(10)	VARCHAR2(10) NOT NULL	Delivery ID
7	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
8	EOEP_RULE_ID	Character(30)	VARCHAR2(30) NOT NULL	Price Rule ID
9	EOEP_FORMULA_ID	Number(10,0)	DECIMAL(10) NOT NULL	Pricing Formula ID
10	OM_ADJST_FLG	Character(2)	VARCHAR2(2) NOT NULL	Adjustment Flag 1=Adjustment Percentage 2=Adjustment Amount 3=Replace Price
11	OM_PRC_ADJAMT	Signed Number(19,4)	DECIMAL(17,4) NOT NULL	Adjust Amount/Percentage/Price
12	OM_PRC_AMOUNT	Signed Number(19,4)	DECIMAL(17,4) NOT NULL	Pricing Adjustment Amount
13	PRICING_UOM	Character(3)	VARCHAR2(3) NOT NULL	Pricing UOM
14	PRICING_QTY	Number(16,4)	DECIMAL(15,4) NOT NULL	Pricing quantity.
15	EOEP_MAX_QUANTITY	Number(16,4)	DECIMAL(15,4) NOT NULL	Max Quantity
16	EOEP_MAXQTY_UOM	Character(3)	VARCHAR2(3) NOT NULL	Max Quantity UOM
17	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
18	SOLD_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Sold To Customer
19	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.