EOEP_RULELIST_V (SQL View)	Index Back
Price Rules with price lists This view returns Price Rules that have at least one price list attached to them. The sub-query is necessary because the field EOEP_LONG cannot be included in a "SELECT DISTINCT" statement where EOEP_RULE and EOEP_RULLST_LNK are joined.

EOEP_RULELIST_V

(SQL View)

Price Rules with price lists

This view returns Price Rules that have at least one price list attached to them. The sub-query is necessary because the field EOEP_LONG cannot be included in a "SELECT DISTINCT" statement where EOEP_RULE and EOEP_RULLST_LNK are joined.

SELECT R.SETID , R.EOEP_RULE_ID , R.MERCH_TYPE , R.PRICEPGM_FLAG , R.EOEP_ACTION_TYPE , R.EOEP_APP_CD , R.EOEP_ADJ_METHOD , R.EOEP_PTD_FLG , R.EOEP_RULE_STATUS , R.EOEP_STOP_FLG , R.EOEP_TD_PROMO_CD , R.EOEP_USE_GRC_DAYS , R.EOEP_LONG , R.EOEP_SOURCE , R.DTTIME_ADDED , R.LASTUPDDTTM , R.LAST_MAINT_OPRID FROM PS_EOEP_RULE R WHERE EXISTS ( SELECT 'X' FROM PS_EOEP_RULLST_LNK LNK WHERE LNK.SETID = R.SETID AND LNK.EOEP_RULE_ID = R.EOEP_RULE_ID)

# 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 MERCH_TYPE Character(10) VARCHAR2(10) NOT NULL Merchandising Type
Prompt Table: %EDITTABLE6

4 PRICEPGM_FLAG Character(1) VARCHAR2(1) NOT NULL Exclusive Pricing Only
N=No
Y=Yes

5 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
Default Value: 1

6 EOEP_APP_CD Character(4) VARCHAR2(4) NOT NULL Transaction Code
Prompt Table: EOEP_APPCD_VW

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

8 EOEP_PTD_FLG Character(1) VARCHAR2(1) NOT NULL Period To Date flag
N=No
R=By Rule
Y=By Customer
Default Value: N

9 EOEP_RULE_STATUS Character(1) VARCHAR2(1) NOT NULL Rule Status
D=Deployed
I=Inactive
P=Pending
R=Ready To Test
Default Value: P

10 EOEP_STOP_FLG Character(1) VARCHAR2(1) NOT NULL Stop Processing
N=No
Y=Yes
Default Value: N

11 EOEP_TD_PROMO_CD Character(20) VARCHAR2(20) NOT NULL Period to date pricing

12 EOEP_USE_GRC_DAYS Character(1) VARCHAR2(1) NOT NULL Use Grace Days
N=No
Y=Yes
Default Value: N

13 EOEP_LONG Long Character CLOB Price Rule Definition

14 EOEP_SOURCE Character(1) VARCHAR2(1) NOT NULL Source of pricing data
1=Enterprise Pricer
2=Promotion Management

15 DTTIME_ADDED DateTime(26) TIMESTAMP Date Time Added

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

17 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL This field determines the last user or operator that last changed this item.

#	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	MERCH_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Merchandising Type Prompt Table: %EDITTABLE6
4	PRICEPGM_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Exclusive Pricing Only N=No Y=Yes
5	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 Default Value: 1
6	EOEP_APP_CD	Character(4)	VARCHAR2(4) NOT NULL	Transaction Code Prompt Table: EOEP_APPCD_VW
7	EOEP_ADJ_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Adjustment Method 1=Cascading 2=Summed
8	EOEP_PTD_FLG	Character(1)	VARCHAR2(1) NOT NULL	Period To Date flag N=No R=By Rule Y=By Customer Default Value: N
9	EOEP_RULE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Rule Status D=Deployed I=Inactive P=Pending R=Ready To Test Default Value: P
10	EOEP_STOP_FLG	Character(1)	VARCHAR2(1) NOT NULL	Stop Processing N=No Y=Yes Default Value: N
11	EOEP_TD_PROMO_CD	Character(20)	VARCHAR2(20) NOT NULL	Period to date pricing
12	EOEP_USE_GRC_DAYS	Character(1)	VARCHAR2(1) NOT NULL	Use Grace Days N=No Y=Yes Default Value: N
13	EOEP_LONG	Long Character	CLOB	Price Rule Definition
14	EOEP_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Source of pricing data 1=Enterprise Pricer 2=Promotion Management
15	DTTIME_ADDED	DateTime(26)	TIMESTAMP	Date Time Added
16	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.
17	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	This field determines the last user or operator that last changed this item.