PV_FW_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	BATCH_SEQ_NUM	Number(15,0)	DECIMAL(15) NOT NULL	Batch Number
5	BATCH_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Prevalidation Batch Type EMIN=eSettlements Invoices
6	TMPLT_ID	Character(10)	VARCHAR2(10) NOT NULL	Template ID
7	DUMMY_FLD	Character(1)	VARCHAR2(1) NOT NULL	TEST DUMMY
8	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
9	SYSTEM_TEMPLATE	Character(1)	VARCHAR2(1) NOT NULL	Used in ChartField Display Template Y=System Maintained
10	SEQNBR	Number(5,0)	INTEGER NOT NULL	Sequence Number
11	FLIST_SEL_INI	Character(30)	VARCHAR2(30) NOT NULL	Field List
12	SQLID_SEL_INI	Character(30)	VARCHAR2(30) NOT NULL	SQL ID for Select Init
13	RULE_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
14	PV_RULE_ID	Character(20)	VARCHAR2(20) NOT NULL	Rule ID
15	SYSTEM_MAINTAINED	Character(1)	VARCHAR2(1) NOT NULL	System Maintained
16	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
17	FLIST_H	Character(30)	VARCHAR2(30) NOT NULL	Field List SQL ID
18	SQLID_H	Character(30)	VARCHAR2(30) NOT NULL	Do When SQL ID
19	FLIST_D	Character(30)	VARCHAR2(30) NOT NULL	Field List SQL ID
20	SQLID_D	Character(30)	VARCHAR2(30) NOT NULL	Do Select SQL ID
21	VALIDATE_BY	Character(4)	VARCHAR2(4) NOT NULL	Validate By AES=By AE Section CLS=By Class SQL=By SQL
22	RECNAME_BAT_EXCEPT	Character(15)	VARCHAR2(15) NOT NULL	Batch Exception Record Name
23	FLIST_S	Character(30)	VARCHAR2(30) NOT NULL	Field List SQL ID
24	SQLID_S	Character(30)	VARCHAR2(30) NOT NULL	SQL ID
25	VALIDATION_CLASS	Character(254)	VARCHAR2(254) NOT NULL	Class
26	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
27	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section