View: Employee EFT Banks

RotoID: UP0201
Table: UPEMBK
Protocol: Detail, Ordered revisions
DLL:UPEMBK

Compositions: 1

RotoID Tables Title DLL

UP0014 UPEMPL Employees UPEMPL

Keys: 2

Title Fields

EFT Banks EMPLOYEEBKACCTCODE
EFT Banks by Calculation Type EMPLOYEEEFTCALCTYPBKACCTCODE

Fields: 15

Field Index Type Title Attributes Presentation

EMPLOYEE 1 String*12 Employee E A K R  Mask: %-12N
BKACCTCODE 2 String*6 Employee EFT Bank E A K R  Mask: %-6N
BKACCTDESC 3 String*15 Employee EFT Bank Description E A 
INSTITUTID 4 String*9 Receiving DFI ID E A  Mask: %-9d
ACCTNUM 5 String*18 Account Number E A  Mask: %-17c
TRANSCODE 6 Integer Transaction Code E A X  List:2 entries
22 = 22 - Checking
32 = 32 - Savings
EFTCALCTYP 7 Integer EFT Calculation Type E A  List:3 entries
1 = Fixed Amount
2 = % of Gross Earnings
3 = % of Net Pay
AMTPCT 8 BCD*9.5 Amt/Pct to be deposited E A 
STARTDATE 9 Date Start Date E A 
ENDDATE 10 Date End Date E A 
DCOUNTRY 11 String*3 Destination Country E A  Mask: %-2C
DCURRENCY 12 String*3 Destination Currency E A  Mask: %-3C
BKIDQUALIF 13 Integer Bank ID Qualifier E A  List:3 entries
1 = 01- (NACHA) National Clearing System Number
2 = 02- BIC Bank Identification Number
3 = 03- IBAN- International Bank Account Number
PRENOTE 14 Integer Prenote Status E A  List:4 entries
0 = Not Sent
1 = Pending
2 = Approved
3 = Declined
TRANSGUID 15 String*36 Sync Transaction GUID E A