PC_SUM_PR_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	REQUEST_NBR	Number(4,0)	SMALLINT NOT NULL	Request Number
3	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
4	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
6	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
7	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
8	DATE_RANGE_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Date Option A=Accounting Date E=All T=Transaction Date
9	FROM_DATE	Date(10)	DATE	From Date
10	THRU_DATE	Date(10)	DATE	Through Date
11	ANALYSIS_GROUP	Character(5)	VARCHAR2(5) NOT NULL	Analysis Group
12	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type
13	RECNAME_SOURCE	Character(15)	VARCHAR2(15) NOT NULL	Source Recname
14	RECNAME_TARGET	Character(15)	VARCHAR2(15) NOT NULL	Target Recname
15	AN_TYPE_PO_REQ	Character(3)	VARCHAR2(3) NOT NULL	Requisitions
16	AN_TYPE_PO_PO	Character(3)	VARCHAR2(3) NOT NULL	Purchase Orders
17	AE_EXISTS	Character(1)	VARCHAR2(1) NOT NULL	Exists
18	SUMM_FLAG	Character(1)	VARCHAR2(1) NOT NULL	View Options D=Show Detail Ledger Entries S=Sum By Ledger Set
19	ROWCOUNT1	Number(12,0)	DECIMAL(12) NOT NULL	Row Count
20	DATE_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Date Option A=As of Date R=Range T=Today
21	DATE_FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	"(Generic field that crosses multiple products; in Treasury
22	NET_ZERO	Character(1)	VARCHAR2(1) NOT NULL	Zero net amount
23	WHERE_CLAUSE_LONG	Long Character(4000)	CLOB	Where Clause