EOEP_FRANGE_INT (SQL Table)	Index Back
Pricing Formula Range Int. Rec Pricing Formula Range Interface Record

EOEP_FRANGE_INT

(SQL Table)

Pricing Formula Range Int. Rec

Pricing Formula Range 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
Prompt Table: EOEP_RULE

5 EOEP_RANGE_ID Number(10,0) DECIMAL(10) NOT NULL Range ID

6 PRICE_TYPE Character(2) VARCHAR2(2) NOT NULL Pricing type
P=Extended Price
Q=Quantity
V=Volume
W=Weight

7 EOEP_MIN_AMOUNT Signed Number(19,4) DECIMAL(17,4) NOT NULL Minimum Amount

8 EOEP_MAX_AMOUNT Signed Number(19,4) DECIMAL(17,4) NOT NULL Maximum Amount

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

10 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 Prompt Table: EOEP_RULE
5	EOEP_RANGE_ID	Number(10,0)	DECIMAL(10) NOT NULL	Range ID
6	PRICE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Pricing type P=Extended Price Q=Quantity V=Volume W=Weight
7	EOEP_MIN_AMOUNT	Signed Number(19,4)	DECIMAL(17,4) NOT NULL	Minimum Amount
8	EOEP_MAX_AMOUNT	Signed Number(19,4)	DECIMAL(17,4) NOT NULL	Maximum Amount
9	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag
10	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.