GM_RTRO_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	RESOURCE_ID	Character(40)	VARCHAR2(40) NOT NULL	Transaction ID
8	POST_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	POSTING SEQUENCE NUMBER
9	FROM_DT	Date(10)	DATE	From Date
10	THRU_DATE	Date(10)	DATE	Through Date
11	DATE_RANGE_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Date Option A=Accounting Date E=All T=Transaction Date
12	REQUEST_NBR	Number(4,0)	SMALLINT NOT NULL	Request Number
13	BUSINESS_UNIT_AWD	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
14	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
15	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
16	GM_ACCTG_DT_OPT	Character(1)	VARCHAR2(1) NOT NULL	Accounting Date Option S=System Date U=Specify Date
17	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
18	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
19	GM_FA_APPROVAL	Character(1)	VARCHAR2(1) NOT NULL	Requires Retroactive F&A Approval A=Approved N=No Y=Yes
20	PURGE_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Purge History without Archive
21	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
22	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
23	GM_APPROVAL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Grants Approval Status A=Approved D=Delete
24	AE_APPSTATUS	Number(1,0)	SMALLINT NOT NULL	AE Application Warning Status
25	SOURCE_TABLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	Source Table Name
26	TABLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	Table Name
27	YES	Character(1)	VARCHAR2(1) NOT NULL
28	FA_FLG	Character(1)	VARCHAR2(1) NOT NULL	F&A Flag
29	ROW_COUNT	Number(8,0)	INTEGER NOT NULL	Number to Purge
30	WORK_CNT1	Number(10,0)	DECIMAL(10) NOT NULL	Work Count 1
31	LAST_RESOURCE_ID	Number(20,0)	DECIMAL(20) NOT NULL	Last Transaction ID
32	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type
33	WHERE_CLAUSE_LONG	Long Character(4000)	CLOB	Where Clause