EO_FLOINDEFN

(SQL Table)
Index Back

Inbound File Layout Definition

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FILE_ID Character(30) VARCHAR2(30) NOT NULL File Identifier
2 FILE_INBOUND Character(127) VARCHAR2(127) NOT NULL Inbound File
3 INDEX_FILE_FLG Character(1) VARCHAR2(1) NOT NULL Index Flag

Y/N Table Edit

Default Value: N

4 FILE_LAYOUT_ID Character(10) VARCHAR2(10) NOT NULL File Layout ID
5 LUW_PUB_SIZE Number(10,0) DECIMAL(10) NOT NULL LUW Publication Max Size

Default Value: 0

6 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
7 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
8 CREATE_HDR_FLG Character(1) VARCHAR2(1) NOT NULL Create Message Header

Y/N Table Edit

Default Value: Y

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

Y/N Table Edit

Default Value: Y

10 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: I