EOEP_ROLL_RL_VW (SQL View)	Index Back
Roll up rule view Roll up rule view

EOEP_ROLL_RL_VW

(SQL View)

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 SetID
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 20

4 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID 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 20
4	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