PL_SRC_PROD_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUMGOP_NONVW
2	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
3	BOM_CODE	Number(2,0)	SMALLINT NOT NULL	CN# EN800-3.0, anna 09/21 added new field to database
4	RTG_CODE	Number(2,0)	SMALLINT NOT NULL	Routing Code
5	SEL	Character(1)	VARCHAR2(1) NOT NULL	Apply Selected Y/N Table Edit
6	PL_ROW_EXIST	Character(1)	VARCHAR2(1) NOT NULL	Row Exist Y/N Table Edit
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
8	PL_UNIT_COST	Signed Number(19,4)	DECIMAL(17,4) NOT NULL	09/27/02 EGS (CN#PL880-1): Changed to 13.4
9	PRIORITY_NBR	Number(3,0)	SMALLINT NOT NULL	Priority
10	MG_ASSOCIATED_BOM	Character(18)	VARCHAR2(18) NOT NULL	04/99 LAJ CN#EN800.6.0 Necessary for new CPG functionality. It stores the assembly item that is the primary method for producing secondary co-products. This field defaults to the assembly item (itself).
11	MFG_MIN_ORDER	Number(12,4)	DECIMAL(11,4) NOT NULL	CN#PL800-18.0 MACN 11/02/99 - Changed short description from Minimum Order to Min Order Qty. jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4 KPN 08/23/02: Added label PL_MIN_ORDER
12	MFG_MAX_ORDER	Number(12,4)	DECIMAL(11,4) NOT NULL	jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4 KPN 08/23/02: Added label PL_MAX_ORDER
13	MFG_ORDER_MULTIPLE	Number(12,4)	DECIMAL(11,4) NOT NULL	jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4
14	PL_OPTION_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Option Type 10=Production 20=Transfer 30=Purchase