GL_IA_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	BO_REQUEST_ID	Character(10)	VARCHAR2(10) NOT NULL	Financial Structure Request ID
5	BO_REQ_DTL_NO	Number(3,0)	SMALLINT NOT NULL	Financial Structure Request Detail ID
6	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
7	FIELDNAME1	Character(18)	VARCHAR2(18) NOT NULL	Field Name 1
8	FIELDVALUE1	Character(30)	VARCHAR2(30) NOT NULL	Field Value
9	EFFDT	Date(10)	DATE	Effective Date
10	EFFDT_OLD	Date(10)	DATE	Old Effective Date
11	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
12	EFF_STATUS_OLD	Character(1)	VARCHAR2(1) NOT NULL	Old Effective Status A=Active I=Inactive
13	BO_REQ_FLD_ACT	Character(1)	VARCHAR2(1) NOT NULL	Financial Structure Request Type A=Add B=Add + Tree T=Tree Only U=Update V=Update + Tree
14	BO_REQ_TREE_IMPACT	Character(1)	VARCHAR2(1) NOT NULL	Business Object Request Tree Only Flag
15	PROCESS_FREQUENCY	Character(1)	VARCHAR2(1) NOT NULL	Process Frequency A=Always Process N=Don't Run O=Process Once
16	PROCESS_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Process Status A=Active C=Successfully Completed E=Completed With Errors N=Not Yet Processed P=Processing Now X=No Success
17	PROCESS_ORIG	Character(1)	VARCHAR2(1) NOT NULL	Process Origin N=Other Source P=Process Scheduler
18	AE_APPSTATUS	Number(1,0)	SMALLINT NOT NULL	AE Application Warning Status
19	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
20	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
21	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
22	STRING_TEXT1	Character(100)	VARCHAR2(100) NOT NULL	String Text