View: EFT Run History Details

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

Compositions: 1

RotoID Tables Title DLL
CP0204 CPEREG EFT Run History Header CPEREG

Keys: 3

Title Fields
EFT Run/Rerun Sequence EFTRUNSEQ, RERUNSEQ, EMPLOYEE, TRANSNO
EFT Entry Effective Date EFTRUNSEQ, RERUNSEQ, ENTRYDATE, EMPLOYEE, TRANSNO
EFT Bank Account Code EFTRUNSEQ, RERUNSEQ, ENTRYDATE, EMPLOYEE, BKACCTCODE, TRANSNO

Fields: 29

Field Index Type Title Attributes Presentation
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 
CASEID 19 String*20 RESERVED - US Only E A 
CASESTATE 20 String*2 RESERVED - US Only E A 
JURISDICTN 21 String*30 RESERVED - US Only E A 
FIPSCODE 22 String*7 RESERVED - US Only E A 
CUSTPARENT 23 String*30 RESERVED - US Only E A 
MEDINSUAVL 24 Boolean RESERVED - US Only E A 
MEDINSUREQ 25 Boolean RESERVED - US Only E A 
ORDERDATE 26 Date RESERVED - US Only E A 
CHECKDATE 27 Date RESERVED - US Only E A 
SSN 28 String*9 RESERVED - US Only E A 
TERMINATED 29 Boolean RESERVED - US Only E A 

This page was generated on 2021-Nov-24

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).