PSA_PROJ_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	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
5	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
6	OPPORTUNITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Opportunity ID
7	SCENARIO_ID	Character(4)	VARCHAR2(4) NOT NULL	A unique key identifier that allows a treasury to classify distinct revaluation events as varying and divergent ca
8	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
9	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
10	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
11	ACTIVITY_ID_2	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
12	EST_CHARGE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Estimated Charge Type E=Expense T=Time
13	EST_AMOUNT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Estimated Amount Type B=Billable Estimate C=Cost Estimate
14	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
15	SEQ_NBR2	Number(15,0)	DECIMAL(15) NOT NULL	Used as a key to SHIP_INV_TMP in addition to the DEMAND_PHYS_INV.
16	LAST_SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Last Sequence number in list Default Value: 0
17	ROW_COUNT	Number(8,0)	INTEGER NOT NULL	Number to Purge
18	LAST_ACTIVITY_ID	Number(8,0)	INTEGER NOT NULL	Last Actvity ID