PO_BUY_LIST_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
2	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
3	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
4	ITM_SETID	Character(5)	VARCHAR2(5) NOT NULL	Item SetID
5	SCHED_GROUP_CD	Character(6)	VARCHAR2(6) NOT NULL	04/01/02 SCC CN#WV900-1.0: Supplier Collaboration - New Field
6	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
7	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
8	DATETIME_COLLAB	DateTime(26)	TIMESTAMP	02/2001 cel WV-802-1.0. Datetime of when the line was approved by the supplier.
9	COLLAB_SCH_STATUS	Character(2)	VARCHAR2(2) NOT NULL	02/2001 cel WV-802-1.0 - Status of the supplier schedule 01=New 10=Current 20=Dispatched 30=Supplier Approved 40=Previous 50=History
10	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
11	INCLUDE_PO	Character(1)	VARCHAR2(1) NOT NULL	Include PO Data N=No Y=Yes
12	DAYOFTHEWEEK	Character(2)	VARCHAR2(2) NOT NULL	Day of the Week 1=Sunday 2=Monday 3=Tuesday 4=Wednesday 5=Thursday 6=Friday 7=Saturday Default Value: 1
13	UNIT_MEASURE_STD	Character(3)	VARCHAR2(3) NOT NULL	Standard Unit of Measure
14	DATETIME_CREATE	DateTime(26)	TIMESTAMP	02/2001 cel WV-802-1.0.
15	DATETIME_DISPATCH	DateTime(26)	TIMESTAMP	02/2001 cel WV-802-1.0
16	SCHEDULE_START_DT	Date(10)	DATE	02/2001 cel WV-802-1.0
17	SCHEDULE_END_DT	Date(10)	DATE	02/2001 cel WV-802-1.0
18	UNIT_MEASURE_VNDR	Character(3)	VARCHAR2(3) NOT NULL	Vendor Unit of Measure
19	CATEGORY_CD	Character(18)	VARCHAR2(18) NOT NULL	Category Code
20	PO_SCHED_PRIORITY	Character(2)	VARCHAR2(2) NOT NULL	Schedule Priority 10=High 20=Medium 30=Low
21	DATETIME_APPLY	DateTime(26)	TIMESTAMP	08/27/01 SCC CN#WV840-1.0: Supplier Collaboration - New Field
22	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
23	BUYER_ID_SEL	Character(30)	VARCHAR2(30) NOT NULL	Buyer