FA_INBOUND_AET

(SQL Table)
Index Back

Publish AE Cache Record

# 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 RUNCNTLID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 FILE_ID Character(30) VARCHAR2(30) NOT NULL File Identifier
5 ECINDRIVEROPT Character(1) VARCHAR2(1) NOT NULL Inbound EC Driver Run Option
F=Single File
I=Single Instance
L=File List Driven
6 FILE_INBOUND Character(127) VARCHAR2(127) NOT NULL Inbound File
7 INDEX_FILE_FLG Character(1) VARCHAR2(1) NOT NULL Index Flag
8 FILE_LAYOUT_ID Character(10) VARCHAR2(10) NOT NULL File Layout ID
9 LUW_PUB_SIZE Number(10,0) DECIMAL(10) NOT NULL LUW Publication Max Size
10 FLDDEFNNAME Character(30) VARCHAR2(30) NOT NULL Definition Name (see PSFLDDEFN).
11 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
12 TEMP_FLD Character(1) VARCHAR2(1) NOT NULL Temporary Field for App Engine
13 END_TRANS_FLG Character(1) VARCHAR2(1) NOT NULL End of Transaction Flag
14 FATAL_ERROR Character(1) VARCHAR2(1) NOT NULL Fatal Error
15 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
A=Always Process
N=Don't Run
O=Process Once
16 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
17 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
18 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
19 CREATE_HDR_FLG Character(1) VARCHAR2(1) NOT NULL Create Message Header

Y/N Table Edit

Default Value: Y

20 CREATE_TRL_FLG Character(1) VARCHAR2(1) NOT NULL Create Message Trailer

Y/N Table Edit

Default Value: Y

21 TG5_NUM Character(5) VARCHAR2(5) NOT NULL TG Number