EOEP_PLHDR_INT (SQL Table)	Index Back
Price List Header Inter. Rec. Price List Header Interface Record

EOEP_PLHDR_INT

(SQL Table)

Price List Header Inter. Rec.

Price List Header 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 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 This field stores the Currency Code value.
Prompt Table: CURRENCY_CD_TBL

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description

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

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

9 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

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

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

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

13 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	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	This field stores the Currency Code value. Prompt Table: CURRENCY_CD_TBL
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
8	EOEP_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Source of pricing data 1=Enterprise Pricer 2=Promotion Management
9	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
10	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
11	REPLACE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Replace flag.
12	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag
13	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.