EOEP_RL_SRCH_VW

(SQL View)
 Index Back

Price Rule Search View

This view is used for the customized search page and doesn't return any rows. It is used just as a derived record but it was created so that it could possibly be used in a grid later.

SELECT a.setid , a.eoep_rule_id , a.descr20 , a.eoep_action_type , a.eoep_adj_method , 'SO' , a.eoep_rule_status , a.eoep_stop_flg , a.eoep_use_grc_days , a.eoep_ptd_flg , a.eoep_td_promo_cd , a.merch_type , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' ,a.eoep_recur_flg FROM PS_EOEP_RULE a WHERE 1 = 2

# 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 EOEP_DESCR20 Character(20) VARCHAR2(20) NOT NULL Power Price description field
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

Prompt Table: EOEP_ACTVAL_VW

5 EOEP_ADJ_METHOD Character(1) VARCHAR2(1) NOT NULL Adjustment Method
1=Cascading
2=Summed
6 EOEP_APP_CD Character(4) VARCHAR2(4) NOT NULL Transaction Code

Prompt Table: EOEP_APPCODE_VW

7 EOEP_RULE_STATUS Character(1) VARCHAR2(1) NOT NULL Rule Status
D=Deployed
I=Inactive
P=Pending
R=Ready To Test
8 EOEP_STOP_FLG Character(1) VARCHAR2(1) NOT NULL Stop Processing
N=No
Y=Yes
9 EOEP_USE_GRC_DAYS Character(1) VARCHAR2(1) NOT NULL Use Grace Days
N=No
Y=Yes
10 EOEP_PTD_FLG Character(1) VARCHAR2(1) NOT NULL Period To Date flag
N=No
R=By Rule
Y=By Customer
11 EOEP_TD_PROMO_CD Character(20) VARCHAR2(20) NOT NULL Period to date pricing

Prompt Table: %EDITTABLE7

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

Prompt Table: %EDITTABLE6

13 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: EOEP_FLDNAM1_VW

14 EOEP_CHAR Character(254) VARCHAR2(254) NOT NULL Long field
15 EOEP_SRCH_COND01 Character(4) VARCHAR2(4) NOT NULL Criteria used to build query/sql where conditions.
<=<
<==<=
<>=not =
===
>=>
>==>=
BEG=begins with
CON=contains
IN=in
16 EOEP_SRCH_COND02 Character(4) VARCHAR2(4) NOT NULL Criteria used to build query/sql where conditions.
<=<
<==<=
<>=<>
===
>=>
>==>=
BEG=begins with
CON=contains
IN=in
17 EOEP_SRCH_COND03 Character(4) VARCHAR2(4) NOT NULL Criteria used to build query/sql where conditions.
<=<
<==<=
<>=<>
===
>=>
>==>=
BEG=begins with
CON=contains
IN=in
18 EOEP_SRCH_COND04 Character(4) VARCHAR2(4) NOT NULL Criteria used to build query/sql where conditions.
<=<
<==<=
<>=<>
===
>=>
>==>=
BEG=begins with
CON=contains
IN=in
19 EOEP_SRCH_COND05 Character(4) VARCHAR2(4) NOT NULL Criteria used to build query/sql where conditions.
<=<
<==<=
<>=<>
===
>=>
>==>=
BEG=begins with
CON=contains
IN=in
20 EOEP_SRCH_COND06 Character(4) VARCHAR2(4) NOT NULL Criteria used to build query/sql where conditions.
<=<
<==<=
<>=<>
===
>=>
>==>=
BEG=begins with
CON=contains
IN=in
21 EOEP_SRCH_COND07 Character(4) VARCHAR2(4) NOT NULL Criteria used to build query/sql where conditions.
<=<
<==<=
<>=<>
===
>=>
>==>=
BEG=begins with
CON=contains
IN=in
22 EOEP_SRCH_COND08 Character(4) VARCHAR2(4) NOT NULL Criteria used to build query/sql where conditions.
<=<
<==<=
<>=<>
===
>=>
>==>=
BEG=begins with
CON=contains
IN=in
23 EOEP_SRCH_COND09 Character(4) VARCHAR2(4) NOT NULL Criteria used to build query/sql where conditions.
<=<
<==<=
<>=<>
===
>=>
>==>=
BEG=begins with
CON=contains
IN=in
24 EOEP_SRCH_COND10 Character(4) VARCHAR2(4) NOT NULL Criteria used to build query/sql where conditions.
<=<
<==<=
<>=<>
===
>=>
>==>=
BEG=begins with
CON=contains
IN=in
25 EOEP_SRCH_COND11 Character(4) VARCHAR2(4) NOT NULL Criteria used to build query/sql where conditions.
<=<
<==<=
<>=<>
===
>=>
>==>=
BEG=begins with
CON=contains
IN=in
26 EOEP_SRCH_COND12 Character(4) VARCHAR2(4) NOT NULL Criteria used to build query/sql where conditions.
<=<
<==<=
<>=<>
===
>=>
>==>=
BEG=begins with
CON=contains
IN=in
27 EOEP_SRCH_COND13 Character(4) VARCHAR2(4) NOT NULL Criteria used to build query/sql where conditions.
<=<
<==<=
<>=<>
===
>=>
>==>=
BEG=begins with
CON=contains
IN=in
28 EOEP_SRCH_COND14 Character(4) VARCHAR2(4) NOT NULL Criteria used to build query/sql where conditions.
<=<
<==<=
<>=<>
===
>=>
>==>=
BEG=begins with
CON=contains
IN=in
29 EOEP_RECUR_FLG Character(1) VARCHAR2(1) NOT NULL Recurring price flag.
N=No
Y=Yes