PO_POROLLVW_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	RUN_DT	Date(10)	DATE	Run Date
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
6	SEARCH_ID	Character(10)	VARCHAR2(10) NOT NULL	Search ID
7	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer Prompt Table: BUYER_TBL
8	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: VENDOR_PO_VW
9	PO_ID_FROM	Character(10)	VARCHAR2(10) NOT NULL	From PO Prompt Table: PO_HDR_ROLLVW
10	PO_ID_TO	Character(10)	VARCHAR2(10) NOT NULL	PO_ID in a range Prompt Table: PO_HDR_ROLLVW
11	FROM_DATE	Date(10)	DATE	From Date
12	TO_DATE	Date(10)	DATE	To Date
13	ROLL_STAT_N	Character(1)	VARCHAR2(1) NOT NULL	None Default Value: Y
14	ROLL_STAT_P	Character(1)	VARCHAR2(1) NOT NULL	Pending Default Value: Y
15	ROLL_STAT_M	Character(1)	VARCHAR2(1) NOT NULL	Mid Roll
16	ROLL_STAT_R	Character(1)	VARCHAR2(1) NOT NULL	Rolled
17	ROLL_STAT_D	Character(1)	VARCHAR2(1) NOT NULL	Disqualified Y/N Table Edit Default Value: Y
18	ROLL_STAT_H	Character(1)	VARCHAR2(1) NOT NULL	Hold from Rollover
19	WHERE_CLAUSE	Character(254)	VARCHAR2(254) NOT NULL	Where Clause
20	WHERE_CLAUSE1	Character(254)	VARCHAR2(254) NOT NULL	Where Clause
21	WHERE_CF	Long Character	CLOB	CF Where
22	RUN_EXCEP	Character(1)	VARCHAR2(1) NOT NULL	Run Exception Report
23	RUN_EXCEP_ORDER	Character(1)	VARCHAR2(1) NOT NULL	Report Sort Order E=Exception Type P=Purchase Order