# Table: EFT Run History Details

Table: UPETRN
View: UP0205
Record length: 219
Flags: A R

## Keys: 2

Title | Flags | Fields
--- | --- | ---
EFT Run/Rerun Sequence |  | EFTRUNSEQ, RERUNSEQ, EMPLOYEE, TRANSNO
EFT Entry Effective Date |  | EFTRUNSEQ, RERUNSEQ, ENTRYDATE, EMPLOYEE, TRANSNO

## Fields: 22

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 | Discretionary Data |
BKACCTCODE | String*6 | Employee EFT Bank ID |
BKACCTDESC | String*15 | Employee EFT Bank Description |
INSTITUTID | String*9 | Receiving DFI ID |
ACCTNUM | String*18 | Account Number |
TRANSCODE | String*2 | Transaction Code |
DEPOSITAMT | BCD*10.3 | Deposit Amount |
ENTRYDATE | Date | EFT Entry Effective Date |
CHECKNUM | BCD*5.0 | Check Number |

This page was generated on 2008-May-02

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.