Table: EFT Run History Details

Table: CPETRN
View: CP0205
Record Length: 333

Flags: A R 

Keys: 3

Title Flags 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: 33

Field Type Title Presentation
EFTRUNSEQ Long EFT Run Sequence
RERUNSEQ Long EFT Rerun Sequence
EMPLOYEE String*12 Employee
TRANSNO Long Unique Key Field
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
LASTNAME String*20 Last Name
FIRSTNAME String*15 First Name
MIDDLENAME String*15 Middle Name
TRNSFRNAME String*30 Bank Transfer Name
REFERENCE String*19 Reference
DISCREDATA String*2 RESERVED - US Only
BKACCTCODE String*6 Employee EFT Bank ID
BKACCTDESC String*15 Employee EFT Bank Description
INSTITUTID String*9 Institution ID
ACCTNUM String*18 Account Number
TRANSCODE String*2 RESERVED - US Only
DEPOSITAMT BCD*10.3 Deposit Amount
ENTRYDATE Date EFT Entry Effective Date
CHECKNUM BCD*5.0 Cheque Number
CASEID String*20 RESERVED - US Only
CASESTATE String*2 RESERVED - US Only
JURISDICTN String*30 RESERVED - US Only
FIPSCODE String*7 RESERVED - US Only
CUSTPARENT String*30 RESERVED - US Only
MEDINSUAVL Boolean RESERVED - US Only
MEDINSUREQ Boolean RESERVED - US Only
ORDERDATE Date RESERVED - US Only
CHECKDATE Date RESERVED - US Only
SSN String*9 RESERVED - US Only
TERMINATED Boolean RESERVED - US Only

This page was generated on 2022-Aug-18

© 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).