CM_IU_ACCTG_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	REQUEST_ID	Character(10)	VARCHAR2(10) NOT NULL	Request ID
4	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
5	PROCESS_FREQUENCY	Character(1)	VARCHAR2(1) NOT NULL	Process Frequency A=Always Process N=Don't Run O=Process Once
6	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
7	PROCESS_ORIG	Character(1)	VARCHAR2(1) NOT NULL	Process Origin N=Other Source P=Process Scheduler
8	AE_APPL_ID	Character(8)	VARCHAR2(8) NOT NULL	Application
9	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
10	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
11	CM_BOOK	Character(10)	VARCHAR2(10) NOT NULL	Cost Book
12	AS_OF_DATE	Date(10)	DATE	As of Date
13	DT_TIMESTAMP	DateTime(26)	TIMESTAMP	Date Timestamp
14	LINE_WRK_REC	Character(15)	VARCHAR2(15) NOT NULL	Line Work Record
15	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
16	MAX_SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Maximum Sequence Number
17	CM_PARALLEL_OK	Character(1)	VARCHAR2(1) NOT NULL	CM_PARALLEL_OK
18	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
19	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
20	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
21	CHARTFIELD	Character(18)	VARCHAR2(18) NOT NULL	ChartField
22	IU_AFFIL_NAME	Character(18)	VARCHAR2(18) NOT NULL	Affiliate ChartField
23	CM_UPDATE_STATS_DE	Character(1)	VARCHAR2(1) NOT NULL	11/01 mxs