PO_SPDBYCAT_WS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer
2	REPORT_ENTITY	Character(5)	VARCHAR2(5) NOT NULL	Reporting Entity ID
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	ITM_SETID	Character(5)	VARCHAR2(5) NOT NULL	Item SetID
5	CATEGORY_ID	Character(5)	VARCHAR2(5) NOT NULL	Category ID
6	CATEGORY_CD	Character(18)	VARCHAR2(18) NOT NULL	Category Code
7	CATEGORY_DESCR	Character(60)	VARCHAR2(60) NOT NULL	Category Description
8	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: SRM_DB_ODPO_ITS
9	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
10	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
11	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: %EDITTABLE3
12	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location Prompt Table: VNDR_LOC_VW1
13	FUTURE_SPEND	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
14	HISTORICAL_SPEND	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
15	TOTAL_SPENDING	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Spending Amount
16	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code