EM_SUP_1099_AET

(SQL Table)
Index Back

Run Control for eS Proposals

Run control for deleteing expired and cancelled proposals

# 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 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 WHERE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Where Clause
7 EM_VENDOR_PROC Character(1) VARCHAR2(1) NOT NULL Supplier Processing
A=All
S=Specify
8 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
9 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
10 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
11 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
12 ERROR_MESSAGE Character(254) VARCHAR2(254) NOT NULL For Standard Journal (SJE)
13 EM_REPORT_PROC Character(1) VARCHAR2(1) NOT NULL Report Processing
B=Delete and Generate Report
D=Delete Report Only
R=Report Only
14 URL_1 Character(254) VARCHAR2(254) NOT NULL URL #1
15 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year