PO_ER_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	BUSINESS_UNIT_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Business Unit Option A=All Business Units V=Specific Business Unit
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
6	IBU_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Inventory Business Unit Option A=All Inventory Buiness Unit V=Specific Inventory BU
7	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
8	PO_ID_OPTN	Character(1)	VARCHAR2(1) NOT NULL	PO ID Option A=All R=Range V=Value
9	PO_ID_FROM	Character(10)	VARCHAR2(10) NOT NULL	From/To
10	PO_ID_TO	Character(10)	VARCHAR2(10) NOT NULL	PO_ID in a range
11	PO_DT_OPTN	Character(1)	VARCHAR2(1) NOT NULL	PO Date Option A=All R=Range S=Some V=Value
12	PO_DT_FROM	Date(10)	DATE	From/To
13	PO_DT_TO	Date(10)	DATE	Purchase Order Date
14	INCLUDE_PUBLISHED	Character(1)	VARCHAR2(1) NOT NULL	Include Published
15	PO_STATUS	Character(2)	VARCHAR2(2) NOT NULL	PO Status A=Approved C=Complete D=Dispatched DA=Denied I=Initial LD=Line Denied O=Open PA=Pending Approval/Approved PX=Pending Cancel X=Canceled
16	WHERE_CLAUSE	Character(254)	VARCHAR2(254) NOT NULL	Where Clause