EOEP_RULE_INT (SQL Table)	Index Back
Price Rule Inter. Rec. Price Rule Interface Record

EOEP_RULE_INT

(SQL Table)

Price Rule Inter. Rec.

Price Rule Interface Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values

3 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

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

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

6 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description

7 MERCH_TYPE Character(10) VARCHAR2(10) NOT NULL Merchandising Type
Prompt Table: %EDITTABLE6

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

9 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

10 EOEP_APP_CD Character(4) VARCHAR2(4) NOT NULL Transaction Code
Prompt Table: EOEP_APPCODE_VW

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

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

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

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

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

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

17 EOEP_LONG Long Character CLOB Price Rule Definition

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

19 EOEP_ONETIME_FLG Character(1) VARCHAR2(1) NOT NULL One-Time Flag
1=No
2=Per Customer
3=Per Rule
Default Value: 1

20 EOEP_ROLLUP_FLG Character(1) VARCHAR2(1) NOT NULL Rollup By Flag
1=Transaction
2=Line
3=Schedule
4=Rollup Rule
Default Value: 1

21 EOEP_ROLLUP_RULE Character(30) VARCHAR2(30) NOT NULL Rollup Rule ID
Prompt Table: EOEP_ROLL_RL_VW

22 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

23 EOEP_TIERED_FLG Character(1) VARCHAR2(1) NOT NULL Tiered Pricing Flag
N=No
Y=Yes
Default Value: N

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

25 EOEP_MEPR_FLG Character(1) VARCHAR2(1) NOT NULL Mutually Exclusive Pricing Rule
N=No
Y=Yes
Default Value: N

26 EOEP_MAX_QUANTITY Number(16,4) DECIMAL(15,4) NOT NULL Max Quantity

27 EOEP_MAXQTY_UOM Character(3) VARCHAR2(3) NOT NULL Max Quantity UOM
Prompt Table: UNITS_TBL

28 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

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

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

31 EOEP_COSTUSE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates whether to use cost.
N=No
Y=Yes
Default Value: N

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

33 EOEP_ROUND_ID Character(15) VARCHAR2(15) NOT NULL Rounding ID
Prompt Table: EOEP_RNDRL_HDR

34 EOEP_ROUND_FLG Character(1) VARCHAR2(1) NOT NULL Rouding Flag
0=None
1=Net Price
2=Adjustment
3=Both

35 EOEP_UOMROLLUP_FLG Character(1) VARCHAR2(1) NOT NULL Indicate whether the rollup is by UOM
N=No
Y=Yes
Default Value: N

36 PROCESS_OPTION Character(2) VARCHAR2(2) NOT NULL This field is used to represent the process option
B=Flat File/Purge
C=Flat File
P=Purge

37 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

38 REPLACE_FLG Character(1) VARCHAR2(1) NOT NULL Replace flag.

39 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	AUDIT_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted. A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values
3	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
4	EOEP_RULE_ID	Character(30)	VARCHAR2(30) NOT NULL	Price Rule ID
5	DESCR20	Character(20)	VARCHAR2(20) NOT NULL	Description
6	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
7	MERCH_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Merchandising Type Prompt Table: %EDITTABLE6
8	PRICEPGM_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Exclusive Pricing Only N=No Y=Yes
9	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
10	EOEP_APP_CD	Character(4)	VARCHAR2(4) NOT NULL	Transaction Code Prompt Table: EOEP_APPCODE_VW
11	EOEP_ADJ_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Adjustment Method 1=Cascading 2=Summed
12	EOEP_PTD_FLG	Character(1)	VARCHAR2(1) NOT NULL	Period To Date flag N=No R=By Rule Y=By Customer Default Value: N
13	EOEP_RULE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Rule Status D=Deployed I=Inactive P=Pending R=Ready To Test Default Value: P
14	EOEP_STOP_FLG	Character(1)	VARCHAR2(1) NOT NULL	Stop Processing N=No Y=Yes Default Value: N
15	EOEP_TD_PROMO_CD	Character(20)	VARCHAR2(20) NOT NULL	Period to date pricing
16	EOEP_USE_GRC_DAYS	Character(1)	VARCHAR2(1) NOT NULL	Use Grace Days N=No Y=Yes Default Value: N
17	EOEP_LONG	Long Character	CLOB	Price Rule Definition
18	EOEP_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Source of pricing data 1=Enterprise Pricer 2=Promotion Management
19	EOEP_ONETIME_FLG	Character(1)	VARCHAR2(1) NOT NULL	One-Time Flag 1=No 2=Per Customer 3=Per Rule Default Value: 1
20	EOEP_ROLLUP_FLG	Character(1)	VARCHAR2(1) NOT NULL	Rollup By Flag 1=Transaction 2=Line 3=Schedule 4=Rollup Rule Default Value: 1
21	EOEP_ROLLUP_RULE	Character(30)	VARCHAR2(30) NOT NULL	Rollup Rule ID Prompt Table: EOEP_ROLL_RL_VW
22	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
23	EOEP_TIERED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Tiered Pricing Flag N=No Y=Yes Default Value: N
24	EOEP_TIERED_INCRE	Signed Number(19,4)	DECIMAL(17,4) NOT NULL	Numeric Value
25	EOEP_MEPR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Mutually Exclusive Pricing Rule N=No Y=Yes Default Value: N
26	EOEP_MAX_QUANTITY	Number(16,4)	DECIMAL(15,4) NOT NULL	Max Quantity
27	EOEP_MAXQTY_UOM	Character(3)	VARCHAR2(3) NOT NULL	Max Quantity UOM Prompt Table: UNITS_TBL
28	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
29	EOEP_LISTUSE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether to use list price. N=No Y=Yes Default Value: Y
30	EOEP_BAUSE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether to use with buying agreement. N=No Y=Yes Default Value: N
31	EOEP_COSTUSE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether to use cost. N=No Y=Yes Default Value: N
32	EOEP_ALTCSTUSE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether to apply to alternate cost base. N=No Y=Yes Default Value: N
33	EOEP_ROUND_ID	Character(15)	VARCHAR2(15) NOT NULL	Rounding ID Prompt Table: EOEP_RNDRL_HDR
34	EOEP_ROUND_FLG	Character(1)	VARCHAR2(1) NOT NULL	Rouding Flag 0=None 1=Net Price 2=Adjustment 3=Both
35	EOEP_UOMROLLUP_FLG	Character(1)	VARCHAR2(1) NOT NULL	Indicate whether the rollup is by UOM N=No Y=Yes Default Value: N
36	PROCESS_OPTION	Character(2)	VARCHAR2(2) NOT NULL	This field is used to represent the process option B=Flat File/Purge C=Flat File P=Purge
37	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
38	REPLACE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Replace flag.
39	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag
40	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.