Table: Employee EFT Banks

Table: UPEMBK
View: UP0201
Record Length: 153

Flags: A R 

Keys: 2

Title Flags Fields

EFT Banks EMPLOYEEBKACCTCODE
EFT Banks by Calculation Type M  EMPLOYEEEFTCALCTYPBKACCTCODE

Fields: 19

Field Type Title Presentation

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