PL_SRC_TMPL_DEL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROBINST	Character(20)	VARCHAR2(20) NOT NULL	Optimization Problem Instance Prompt Table: SP_PRBINS_NONVW
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: PL_PI_BU_IN_VW
3	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: PL_PI_BU_ITM_VW
4	PRIORITY_NBR	Number(3,0)	SMALLINT NOT NULL	Priority
5	PL_OPTION_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Option Type 10=Production 20=Transfer 30=Purchase
6	BOM_CODE	Number(2,0)	SMALLINT NOT NULL	CN# EN800-3.0, anna 09/21 added new field to database
7	RTG_CODE	Number(2,0)	SMALLINT NOT NULL	Routing Code
8	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).
9	BUS_UNIT_SOURCE	Character(5)	VARCHAR2(5) NOT NULL	Source Business Unit
10	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code
11	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
12	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
13	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
14	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer
15	PL_SRC_DEFAULT	Character(1)	VARCHAR2(1) NOT NULL	Sourcing Default Y/N Table Edit Default Value: N
16	QTY_MINIMUM	Number(16,4)	DECIMAL(15,4) NOT NULL	12/27/02 EGS (CN#PL880-1): Added
17	QTY_MAXIMUM	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Maximum Qty
18	PL_UNIT_COST	Signed Number(19,4)	DECIMAL(17,4) NOT NULL	09/27/02 EGS (CN#PL880-1): Changed to 13.4
19	ITMV_PRIORITY_LOC	Character(10)	VARCHAR2(10) NOT NULL	Item Supplier Priority Loc
20	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference