CNAO_OVERAL_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	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
6	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
7	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
8	LEDGER_CODE	Character(10)	VARCHAR2(10) NOT NULL	Ledger Code
9	PERIOD_FROM	Number(3,0)	SMALLINT NOT NULL	From Period
10	PERIOD_TO	Number(3,0)	SMALLINT NOT NULL	To Period
11	CURRENTPERIOD	Number(3,0)	SMALLINT NOT NULL	Current Period
12	LASTPERIOD	Number(3,0)	SMALLINT NOT NULL	Last Period
13	ORDERNO	Number(5,0)	INTEGER NOT NULL	Sort Order
14	ORDERNO1	Number(5,0)	INTEGER NOT NULL	Sort Order
15	CSFL_RPT_ID	Character(20)	VARCHAR2(20) NOT NULL	Cash Flow Report ID
16	GL_FLG	Character(1)	VARCHAR2(1) NOT NULL	General Ledger N=Not Selected Y=Selected
17	GL_JNL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Journals N=Not Selected Y=Selected
18	GL_PRD_AMT_BAL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Amount and Balance by Period N=Not Selected Y=Selected
19	GL_JNL_CSFL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Journal of Cash Flow Item N=Not Selected Y=Selected
20	GL_CSFL_RPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Cash Flow Statement N=Not Selected Y=Selected
21	AP_AR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Accounts Payable & Receivable N=Not Selected Y=Selected
22	FA_FLG	Character(1)	VARCHAR2(1) NOT NULL	F&A Flag
23	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
24	STATUS_JRNL	Character(1)	VARCHAR2(1) NOT NULL	Status of Journal Process
25	STATUS_BAL	Character(1)	VARCHAR2(1) NOT NULL	Status of Balance Process
26	FLAG1	Character(1)	VARCHAR2(1) NOT NULL	Flag1
27	FLAG2	Character(1)	VARCHAR2(1) NOT NULL	Flag2
28	DUMMY_FIELD	Character(1)	VARCHAR2(1) NOT NULL	Dummy Field for Hiding Groups