# View: EFT Run History Details

RotoID: UP0205
Table: UPETRN
Protocol: Detail, Ordered revisions
DLL: UPETRN

## Compositions: 1

RotoID | Tables | Title | DLL
--- | --- | --- | ---
UP0204 | UPEREG | EFT Run History Header | UPEREG

## Keys: 2

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

## Fields: 18

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 | Discretionary Data | 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 | Receiving DFI ID | E A |
ACCTNUM | 14 | String*18 | Account Number | E A |
TRANSCODE | 15 | String*2 | Transaction Code | 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 | Check Number | E A |

This page was generated on 2009-Nov-19

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