EOEP_LIST_COST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
3	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
4	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
5	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
6	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
7	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Currency Code value.
8	CM_METHOD	Character(2)	VARCHAR2(2) NOT NULL	8/20/02 lee: added xlate 9 for retroactive perp average 01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements 0=Non Cost 1=Actual Cost 6=Perpetual Weighted Average 7=Periodic Weighted Average 8=Value at Current Standard 9=Retroactive Perpetual Average
9	CONFIG_CODE	Character(50)	VARCHAR2(50) NOT NULL	Product Configurator
10	PRICE_LIST_ID	Character(10)	VARCHAR2(10) NOT NULL	Price List ID Prompt Table: EOEP_PRLSTID_VW
11	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
12	BREAK_QTY_LOW	Number(15,4)	DECIMAL(14,4) NOT NULL	Low Quantity/Amount Default Value: 0
13	BREAK_QTY_HIGH	Number(15,4)	DECIMAL(14,4) NOT NULL	Upper Quantity/Amount
14	TO_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	To Currency
15	UNIT_COST	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Unit Cost
16	COST_EFFDT	Date(10)	DATE	Effective date for Order Management Cost extract
17	LIST_PRICE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	List Price
18	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
19	END_DATE	Date(10)	DATE	End date field to store an end date.
20	PRICE_PROTECTED	Character(1)	VARCHAR2(1) NOT NULL	Price Protected
21	DATE_SEL_DT	Date(10)	DATE	03/23/2004 SFC Added PROD_COST_EFF_DT label
22	PRICE_LIST_ID_FLG	Character(1)	VARCHAR2(1) NOT NULL	Price List ID flag for the pricing engine. N=All Price Lists Y=Single Price List Default Value: N
23	CURRENCY_PLST_FLG	Character(1)	VARCHAR2(1) NOT NULL	03/23/2004 SFC Deleted SELECTCURRENCYCODE Modified XLAT N=All Currencies Y=Single Currency Code Default Value: N