OM_PROD_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	SetID
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. MHR=Muti Hourly PER=Percentage SQF=Square Footage
7	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
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	PRODUCT_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Product Group
11	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
12	BUSINESS_UNIT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Business Unit Flag N=All Inventory Business Unit Y=Single Inventory Business Unit Y/N Table Edit Default Value: N
13	PRODUCT_GROUP_FLAG	Character(2)	VARCHAR2(2) NOT NULL	Product Group Y/N Table Edit Default Value: N
14	DATE_SEL_DT	Date(10)	DATE	03/23/2004 SFC Added PROD_COST_EFF_DT label
15	COST_EFFDT	Date(10)	DATE	Effective date for Order Management Cost extract
16	LIST_PRICE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	List Price
17	MFG_SUG_RTL_PRC	Number(16,4)	DECIMAL(15,4) NOT NULL	Manufactures's Suggested Retai
18	UNIT_COST	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Unit Cost
19	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
20	PRIM_PRC_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Primary Pricing Group Flag