RO_ADJ_LINE_VW (SQL View)	Index Back
Line Adjustments View used to load and display the line adjustments.

RO_ADJ_LINE_VW

(SQL View)

Line Adjustments

View used to load and display the line adjustments.

SELECT a.capture_id , a.uid20 , %subrec(ro_prcadj_sbr, a) , %subrec(rb_audit_sbr, a) FROM PS_RO_PRICE_ADJST a WHERE uid20 <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CAPTURE_ID Character(20) VARCHAR2(20) NOT NULL Field use to store the capture ID in order capture.

2 UID20 Character(20) VARCHAR2(20) NOT NULL This field is for UID of 20 characters long.

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

4 ADJUSTMENT_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Adjustment Percent

5 EOEP_FORM_BREAK Character(30) VARCHAR2(30) NOT NULL Formula Break

6 EOEP_DATE_BREAK Character(30) VARCHAR2(30) NOT NULL Date Break

7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.

8 PRICE_OVERRIDE Signed Number(16,4) DECIMAL(14,4) NOT NULL Price Override

9 PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL This is price per unit for calculating the service charge.

10 PRICE_TYPE Character(2) VARCHAR2(2) NOT NULL Pricing type
P=Extended Price
Q=Quantity
V=Volume
W=Weight

11 EOEP_ACTION_TYPE Character(2) VARCHAR2(2) NOT NULL Action Type
1=Discount/Surcharge
10=Free Period Promotion
11=Product Add
12=Price Base
13=Rollup Only Rule
14=Min/Max Margin
15=Recurring Discount/Surcharge
2=Price Override
3=Giveaway / 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

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

13 EOEP_ADJST_AMT Signed Number(19,4) DECIMAL(17,4) NOT NULL Adjustment Amount

14 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

15 EOEP_ADJUSTMENT Signed Number(19,4) DECIMAL(17,4) NOT NULL Adjustment

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

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

18 EOEP_CHAR Character(254) VARCHAR2(254) NOT NULL Long field

19 RECUR_FLAG Character(1) VARCHAR2(1) NOT NULL Identifies if a revenue flow is one of a set of recurring.
N=Non-Recuring Revenue
Y=Recurring Revenue
Default Value: N

20 EOEP_RECURRENCE Number(2,0) SMALLINT NOT NULL Recurrence of Discount, etc

21 PPRC_RECUR_FREQ Character(2) VARCHAR2(2) NOT NULL Field used to store the recurring frequency.
00=Daily
05=Weekly
10=Monthly
15=Quarterly
20=Annually

22 RECUR_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Recurring Price

23 PRORATE_FLAG Character(1) VARCHAR2(1) NOT NULL Proration flag - indicates if order adjustments are prorated to the lines
0=Do Not Prorate Adjustments
1=Prorate Order Adjustments

24 EOEP_TEXT_VALUE Character(254) VARCHAR2(254) NOT NULL Text Value

25 EOEP_ONETIME_FLG Character(1) VARCHAR2(1) NOT NULL One-Time Flag
1=No
2=Per Customer
3=Per Rule

26 EOEP_MEPR_FLG Character(1) VARCHAR2(1) NOT NULL Mutually Exclusive Pricing Rule
N=No
Y=Yes

27 PRICE_ADJST_REASON Character(10) VARCHAR2(10) NOT NULL Price Adjustment Reason

28 MERCH_TYPE Character(10) VARCHAR2(10) NOT NULL Merchandising Type

29 RO_ADJST_AMT Signed Number(19,4) DECIMAL(17,4) NOT NULL Price adjustment amount, percent or override

30 RO_ADJST_FLG Character(1) VARCHAR2(1) NOT NULL Price adjustments flag.
1=Percent
2=Amount
3=Override

31 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

32 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

33 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

34 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

35 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

36 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAPTURE_ID	Character(20)	VARCHAR2(20) NOT NULL	Field use to store the capture ID in order capture.
2	UID20	Character(20)	VARCHAR2(20) NOT NULL	This field is for UID of 20 characters long.
3	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
4	ADJUSTMENT_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Adjustment Percent
5	EOEP_FORM_BREAK	Character(30)	VARCHAR2(30) NOT NULL	Formula Break
6	EOEP_DATE_BREAK	Character(30)	VARCHAR2(30) NOT NULL	Date Break
7	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Currency Code value.
8	PRICE_OVERRIDE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Price Override
9	PRICE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	This is price per unit for calculating the service charge.
10	PRICE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Pricing type P=Extended Price Q=Quantity V=Volume W=Weight
11	EOEP_ACTION_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Action Type 1=Discount/Surcharge 10=Free Period Promotion 11=Product Add 12=Price Base 13=Rollup Only Rule 14=Min/Max Margin 15=Recurring Discount/Surcharge 2=Price Override 3=Giveaway / 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
12	EOEP_ADJ_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Adjustment Method 1=Cascading 2=Summed
13	EOEP_ADJST_AMT	Signed Number(19,4)	DECIMAL(17,4) NOT NULL	Adjustment Amount
14	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
15	EOEP_ADJUSTMENT	Signed Number(19,4)	DECIMAL(17,4) NOT NULL	Adjustment
16	EOEP_FORMULA_ID	Number(10,0)	DECIMAL(10) NOT NULL	Pricing Formula ID
17	EOEP_RULE_ID	Character(30)	VARCHAR2(30) NOT NULL	Price Rule ID
18	EOEP_CHAR	Character(254)	VARCHAR2(254) NOT NULL	Long field
19	RECUR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Identifies if a revenue flow is one of a set of recurring. N=Non-Recuring Revenue Y=Recurring Revenue Default Value: N
20	EOEP_RECURRENCE	Number(2,0)	SMALLINT NOT NULL	Recurrence of Discount, etc
21	PPRC_RECUR_FREQ	Character(2)	VARCHAR2(2) NOT NULL	Field used to store the recurring frequency. 00=Daily 05=Weekly 10=Monthly 15=Quarterly 20=Annually
22	RECUR_PRICE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Recurring Price
23	PRORATE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Proration flag - indicates if order adjustments are prorated to the lines 0=Do Not Prorate Adjustments 1=Prorate Order Adjustments
24	EOEP_TEXT_VALUE	Character(254)	VARCHAR2(254) NOT NULL	Text Value
25	EOEP_ONETIME_FLG	Character(1)	VARCHAR2(1) NOT NULL	One-Time Flag 1=No 2=Per Customer 3=Per Rule
26	EOEP_MEPR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Mutually Exclusive Pricing Rule N=No Y=Yes
27	PRICE_ADJST_REASON	Character(10)	VARCHAR2(10) NOT NULL	Price Adjustment Reason
28	MERCH_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Merchandising Type
29	RO_ADJST_AMT	Signed Number(19,4)	DECIMAL(17,4) NOT NULL	Price adjustment amount, percent or override
30	RO_ADJST_FLG	Character(1)	VARCHAR2(1) NOT NULL	Price adjustments flag. 1=Percent 2=Amount 3=Override
31	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
32	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
33	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
34	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
35	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
36	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time