PO_LN_SRCH_RSLT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
3	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
4	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
5	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer
6	CATEGORY_CD	Character(18)	VARCHAR2(18) NOT NULL	Category Code
7	CATEGORY_ID	Character(5)	VARCHAR2(5) NOT NULL	Category ID
8	CATEGORY_SETID	Character(5)	VARCHAR2(5) NOT NULL	Category SetID
9	CNTRCT_ID	Character(25)	VARCHAR2(25) NOT NULL	Buying Agreement ID
10	DESCR254_MIXED	Character(254)	VARCHAR2(254) NOT NULL	Description
11	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
12	ITM_ID_VNDR	Character(50)	VARCHAR2(50) NOT NULL	Vendor Item ID
13	CANCEL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Cancel Status A=Active C=Closed D=Denied H=Hold O=Open P=Pending Approval X=Canceled
14	CURR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Current Status A=Approved C=Closed D=Denied H=Hold O=Open P=Pending X=Canceled
15	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
16	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
17	MFG_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer ID
18	MFG_ITM_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer's Item ID
19	UPN_TYPE_CD	Character(4)	VARCHAR2(4) NOT NULL	Universal Product Number Format Type
20	UPN_ID	Character(20)	VARCHAR2(20) NOT NULL	Universal Product Number
21	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
22	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
23	VENDOR_NAME_SHORT	Character(14)	VARCHAR2(14) NOT NULL	Short Vendor Name
24	VNDR_CATALOG_ID	Character(20)	VARCHAR2(20) NOT NULL	Vendor's Catalog Number