EOEP_RL_PRC1_VW

(SQL View)
 Index Back

Price Rule Pricing VW no long

This view returns only needed fields for pricing calculation

SELECT SETID , EOEP_RULE_ID , MERCH_TYPE , PRICEPGM_FLAG , EOEP_ACTION_TYPE , EOEP_APP_CD , EOEP_ADJ_METHOD , EOEP_PTD_FLG , EOEP_RULE_STATUS , EOEP_STOP_FLG , EOEP_TD_PROMO_CD , EOEP_USE_GRC_DAYS , EOEP_SOURCE , EOEP_ONETIME_FLG , EOEP_ROLLUP_FLG , EOEP_ROLLUP_RULE , EOEP_PRCBASE_FLG , EOEP_TIERED_FLG , EOEP_TIERED_INCRE , EOEP_MEPR_FLG , EOEP_MAX_QUANTITY , EOEP_MAXQTY_UOM , EOEP_RULEXCL_FLG , EOEP_LISTUSE_FLG , EOEP_BAUSE_FLG , EOEP_COSTUSE_FLG , EOEP_ALTCSTUSE_FLG , EOEP_ROUND_ID , EOEP_ROUND_FLG , EOEP_UOMROLLUP_FLG , EOEP_PRC_MATCH_FLG , %TextIn(' ') FROM PS_EOEP_RULE

# 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 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

Default Value: N

5 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

Default Value: 1

6 EOEP_APP_CD Character(4) VARCHAR2(4) NOT NULL Transaction Code

Prompt Table: EOEP_APPCODE_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

Prompt Table: %EDITTABLE7

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

Default Value: N

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

Default Value: 1

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

Default Value: 1

15 EOEP_ROLLUP_FLG Character(1) VARCHAR2(1) NOT NULL Rollup By Flag
1=Transaction
2=Line
3=Schedule
4=Rollup Rule

Default Value: 1

16 EOEP_ROLLUP_RULE Character(30) VARCHAR2(30) NOT NULL Rollup Rule ID

Prompt Table: EOEP_ROLL_RL_VW

17 EOEP_PRCBASE_FLG Character(1) VARCHAR2(1) NOT NULL Pricing Base Flag
1=List Price
2=Cost
3=Buying Agreement
4=Alternate Cost

Default Value: 1

18 EOEP_TIERED_FLG Character(1) VARCHAR2(1) NOT NULL Tiered Pricing Flag
N=No
Y=Yes

Default Value: N

19 EOEP_TIERED_INCRE Signed Number(19,4) DECIMAL(17,4) NOT NULL Numeric Value

Default Value: 1

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

Default Value: N

21 EOEP_MAX_QUANTITY Number(16,4) DECIMAL(15,4) NOT NULL Max Quantity
22 EOEP_MAXQTY_UOM Character(3) VARCHAR2(3) NOT NULL Max Quantity UOM

Prompt Table: UNITS_TBL

23 EOEP_RULEXCL_FLG Character(1) VARCHAR2(1) NOT NULL Rule Exclude
1=None
2=KVI Products
3=NDP Products
4=KVI & NDP Products

Default Value: 1

24 EOEP_LISTUSE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates whether to use list price.
N=No
Y=Yes

Default Value: Y

25 EOEP_BAUSE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates whether to use with buying agreement.
N=No
Y=Yes

Default Value: N

26 EOEP_COSTUSE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates whether to use cost.
N=No
Y=Yes

Default Value: N

27 EOEP_ALTCSTUSE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates whether to apply to alternate cost base.
N=No
Y=Yes

Default Value: N

28 EOEP_ROUND_ID Character(15) VARCHAR2(15) NOT NULL Rounding ID

Prompt Table: EOEP_RNDRL_HDR

29 EOEP_ROUND_FLG Character(1) VARCHAR2(1) NOT NULL Rouding Flag
0=None
1=Net Price
2=Adjustment
3=Both
30 EOEP_UOMROLLUP_FLG Character(1) VARCHAR2(1) NOT NULL Indicate whether the rollup is by UOM
N=No
Y=Yes

Default Value: N

31 EOEP_PRC_MATCH_FLG Character(1) VARCHAR2(1) NOT NULL Indicate what to use to match price break
B=Base Price
N=Net Price
32 EOEP_LONG Long Character CLOB Price Rule Definition