EOEP_ROLL_RL_VW (SQL View)	Index Back
Roll up rule view Price rules - Roll up rule view

EOEP_ROLL_RL_VW

(SQL View)

Roll up rule view

Price rules - Roll up rule view

SELECT SETID , EOEP_RULE_ID , DESCR20 , EOEP_ACTION_TYPE FROM PS_EOEP_RULE WHERE EOEP_ACTION_TYPE = '13'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

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

3 DESCR20 Character(20) VARCHAR2(20) NOT NULL Description

4 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables. Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	EOEP_RULE_ID	Character(30)	VARCHAR2(30) NOT NULL	Price Rule ID
3	DESCR20	Character(20)	VARCHAR2(20) NOT NULL	Description
4	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