View: EFT Run History Details

RotoID: CP0205
Table: CPETRN
Protocol: Detail, Ordered revisions
DLL: CPETRN

Compositions: 1

Title	Fields

EFT Run/Rerun Sequence	EFTRUNSEQ, RERUNSEQ, EMPLOYEE, TRANSNO
EFT Entry Effective Date	EFTRUNSEQ, RERUNSEQ, ENTRYDATE, EMPLOYEE, TRANSNO

Field	Index	Type	Title	Attributes

EFTRUNSEQ	1	Long	EFT Run Sequence	E A K R
RERUNSEQ	2	Long	EFT Rerun Sequence	E A K R
EMPLOYEE	3	String*12	Employee	E A K R
TRANSNO	4	Long	Unique Key Field	E A K R
LASTNAME	5	String*20	Last Name	E A
FIRSTNAME	6	String*15	First Name	E A
MIDDLENAME	7	String*15	Middle Name	E A
TRNSFRNAME	8	String*30	Bank Transfer Name	E A
REFERENCE	9	String*19	Reference	E A
DISCREDATA	10	String*2	RESERVED - US Only	E A
BKACCTCODE	11	String*6	Employee EFT Bank ID	E A
BKACCTDESC	12	String*15	Employee EFT Bank Description	E A
INSTITUTID	13	String*9	Institution ID	E A
ACCTNUM	14	String*18	Account Number	E A
TRANSCODE	15	String*2	RESERVED - US Only	E A
DEPOSITAMT	16	BCD*10.3	Deposit Amount	E A
ENTRYDATE	17	Date	EFT Entry Effective Date	E A
CHECKNUM	18	BCD*5.0	Cheque Number	E A

This page was generated on 2009-Nov-19