EFT_LAYOUT_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EFT_LAYOUT_CD	Character(10)	VARCHAR2(10) NOT NULL	EFT Layout Code
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
4	LAST_EFT_FILE_ID	Character(4)	VARCHAR2(4) NOT NULL	Last File Number
5	MAX_REMITTANCE_NBR	Number(3,0)	SMALLINT NOT NULL	Maximum Number of Remittances
6	DD_FLG	Character(1)	VARCHAR2(1) NOT NULL	Direct Debit Flag Y/N Table Edit Default Value: N
7	DRAFT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Draft Flag Y/N Table Edit Default Value: N
8	PAY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Payment Flag Y/N Table Edit Default Value: N
9	STD_ID_NUM_QUAL	Character(3)	VARCHAR2(3) NOT NULL	Standard ID Number
10	EFT_FILE_NBR	Character(2)	VARCHAR2(2) NOT NULL	EFT File Number
11	INBOUND_EFT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Inbound EFT File?
12	OUTBOUND_EFT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Outbound EFT File
13	PRENOTE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Prenotification Flag
14	OUTPUT_FILENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of the translated bank statement file after the translation has been run.
15	FILE_EXTENSION	Character(4)	VARCHAR2(4) NOT NULL	File Extension
16	FEDRL_EFT_ACH_IND	Character(1)	VARCHAR2(1) NOT NULL	To indicate if a particular EFT layout is applicable to an Employee vendor or other Vendor classifcation for purposes of editing at voucher save 1=Employee 2=Supplier 3=Both