UPG_WV_AET (SQL Table)	Index Back
Supplier Portal Upg AE Tmp Rec

UPG_WV_AET

(SQL Table)

Supplier Portal Upg AE Tmp Rec

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).

3 AE_STEP Character(8) VARCHAR2(8) NOT NULL Name

4 AE_SQLROWS Number(10,0) DECIMAL(10) NOT NULL Rows affected by last SQL stmt

5 FLAG Character(1) VARCHAR2(1) NOT NULL Flag
N=No
Y=Yes

6 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
3	AE_STEP	Character(8)	VARCHAR2(8) NOT NULL	Name
4	AE_SQLROWS	Number(10,0)	DECIMAL(10) NOT NULL	Rows affected by last SQL stmt
5	FLAG	Character(1)	VARCHAR2(1) NOT NULL	Flag N=No Y=Yes
6	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp