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 SetID
Prompt Table: SP_SETID_NONVW

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

5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
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.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Prompt Table: PROD_UOM

8 START_DT Date(10) DATE Start Date
Default Value: %date

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

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

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

12 RECURRING_FLG Character(1) VARCHAR2(1) NOT NULL Recurring Flag
N=No
Y=Yes

13 END_DATE Date(10) DATE 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	SetID Prompt Table: SP_SETID_NONVW
4	PRICE_LIST_ID	Character(10)	VARCHAR2(10) NOT NULL	Price List ID Prompt Table: EOEP_PRLSTID_VW
5	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code 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. MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: PROD_UOM
8	START_DT	Date(10)	DATE	Start Date Default Value: %date
9	BREAK_QTY_LOW	Number(15,4)	DECIMAL(14,4) NOT NULL	Low Quantity/Amount
10	BREAK_QTY_HIGH	Number(15,4)	DECIMAL(14,4) NOT NULL	Upper Quantity/Amount
11	PW_FREQUENCY	Character(2)	VARCHAR2(2) NOT NULL	Recurring Frequency 00=Daily 05=Weekly 10=Monthly 15=Quarterly 20=Annually
12	RECURRING_FLG	Character(1)	VARCHAR2(1) NOT NULL	Recurring Flag N=No Y=Yes
13	END_DATE	Date(10)	DATE	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.