EOEP_PLIST_INT (SQL Table)	Index Back
Price List Detail Inter. Rec. Price List Detail Interface Record

EOEP_PLIST_INT

(SQL Table)

Price List Detail Inter. Rec.

Price List Detail 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.
Prompt Table: SP_SETID_NONVW

4 PRICE_LIST_ID Character(10) VARCHAR2(10) NOT NULL Price List ID
Prompt Table: EOEP_PRICE_LIST

5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.
Prompt Table: CURRENCY_CD_TBL

6 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
Prompt Table: PRICSET_PROD_VW

7 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
CS=Case
EA=Each
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Prompt Table: PROD_UOM

8 START_DT Date(10) DATE Start date field to store start date value.
Default Value: %date

9 BREAK_QTY_LOW Number(15,4) DECIMAL(14,4) NOT NULL Low Quantity/Amount

10 PW_FREQUENCY Character(2) VARCHAR2(2) NOT NULL Recurring Frequency
00=Daily
05=Weekly
10=Monthly
15=Quarterly
20=Annually

11 RECURRING_FLG Character(1) VARCHAR2(1) NOT NULL This field indicated if a list price is a regular price or a reccurring price. THe recurring price will also require a frequency.
N=No
Y=Yes

12 BREAK_QTY_HIGH Number(15,4) DECIMAL(14,4) NOT NULL Upper Quantity/Amount

13 END_DATE Date(10) DATE End date field to store an end date.

14 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

15 LIST_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price

16 PRICE_PROTECTED Character(1) VARCHAR2(1) NOT NULL Price Protected
Y/N Table Edit
Default Value: N

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

18 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. Prompt Table: SP_SETID_NONVW
4	PRICE_LIST_ID	Character(10)	VARCHAR2(10) NOT NULL	Price List ID Prompt Table: EOEP_PRICE_LIST
5	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Currency Code value. Prompt Table: CURRENCY_CD_TBL
6	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID Prompt Table: PRICSET_PROD_VW
7	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. CS=Case EA=Each MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: PROD_UOM
8	START_DT	Date(10)	DATE	Start date field to store start date value. Default Value: %date
9	BREAK_QTY_LOW	Number(15,4)	DECIMAL(14,4) NOT NULL	Low Quantity/Amount
10	PW_FREQUENCY	Character(2)	VARCHAR2(2) NOT NULL	Recurring Frequency 00=Daily 05=Weekly 10=Monthly 15=Quarterly 20=Annually
11	RECURRING_FLG	Character(1)	VARCHAR2(1) NOT NULL	This field indicated if a list price is a regular price or a reccurring price. THe recurring price will also require a frequency. N=No Y=Yes
12	BREAK_QTY_HIGH	Number(15,4)	DECIMAL(14,4) NOT NULL	Upper Quantity/Amount
13	END_DATE	Date(10)	DATE	End date field to store an end date.
14	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
15	LIST_PRICE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	List Price
16	PRICE_PROTECTED	Character(1)	VARCHAR2(1) NOT NULL	Price Protected Y/N Table Edit Default Value: N
17	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag
18	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.