GM_FA_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	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
6	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
7	FROM_DATE	Date(10)	DATE	From Date
8	THRU_DATE	Date(10)	DATE	Through Date
9	BUPRJACT_OPTION	Character(1)	VARCHAR2(1) NOT NULL	BU/Proj/Act Option A=Selected BU / Proj / Activity B=Selected Business Unit E=All P=Selected BU / Project
10	DATE_RANGE_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Date Option A=Accounting Date E=All T=Transaction Date
11	REQUEST_NBR	Number(4,0)	SMALLINT NOT NULL	Request Number
12	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
13	BUSINESS_UNIT_WRK	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
14	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
15	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
16	COMBO_EDIT_TMPL	Character(10)	VARCHAR2(10) NOT NULL	Record Template
17	BCM_REQ_NUM	Number(4,0)	SMALLINT NOT NULL	Budget Checking Request Number
18	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
19	LINE_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Sequence
20	ASSOC_DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Associated Department
21	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
22	RESOURCE_ID	Character(40)	VARCHAR2(40) NOT NULL	Transaction ID
23	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
24	SEL_CF_LIST	Character(100)	VARCHAR2(100) NOT NULL	Represents the listing of general ledger chartfields that can included as a chartfield substitution rule when co
25	SEL_CF2_LIST	Character(100)	VARCHAR2(100) NOT NULL	Represents the listing of general ledger chartfields that can included as a chartfield substitution rule when c
26	FA_FLG	Character(1)	VARCHAR2(1) NOT NULL	F&A Flag
27	EXCEPT_ACCT_DT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Exception Accounting Date
28	COST_SHARE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Cost Sharing Flag
29	COMMITMENT_CNTL	Character(1)	VARCHAR2(1) NOT NULL	Enable Commitment Control
30	FA_BCM_REV_OFFSET	Character(1)	VARCHAR2(1) NOT NULL	Revenue Offset
31	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type
32	ROW_COUNT	Number(8,0)	INTEGER NOT NULL	Number to Purge
33	LAST_RESOURCE_ID	Number(20,0)	DECIMAL(20) NOT NULL	Last Transaction ID
34	FIELDNUM	Number(4,0)	SMALLINT NOT NULL	Field Number
35	POST_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	POSTING SEQUENCE NUMBER
36	WHERE_LONG	Long Character	CLOB	Where Clause