PL_PURCHASE_DEL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROBINST	Character(20)	VARCHAR2(20) NOT NULL	Optimization Problem Instance
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_PLNPOITEM_VW
4	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID Prompt Table: PL_PURCHOPT1_VW
5	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: PL_PLNPOVDR_VW
6	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location Prompt Table: PL_PURCHOPT3_VW
7	LEAD_TIME	Number(3,0)	SMALLINT NOT NULL	Lead Time Days
8	PUR_MIN_ORDER	Number(16,4)	DECIMAL(15,4) NOT NULL	CN#PL800-18.0 MACN 11/02/99 - Changed short description from Minimum Ord Qty 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 PUR_MIN_ORDER2
9	PUR_MAX_ORDER	Number(16,4)	DECIMAL(15,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 PUR_MAX_ORDER2
10	PUR_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
11	PURCHASE_YIELD	Number(5,1)	DECIMAL(4,1) NOT NULL	Purchase Yield
12	PL_UNIT_COST	Signed Number(19,4)	DECIMAL(17,4) NOT NULL	09/27/02 EGS (CN#PL880-1): Changed to 13.4
13	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference