PREMPBANK

This file contains the employee bank information. the bank information may be selected from the Receiving DFI field when adding and employee ACH distribution record in PR12.1 or access PR12.4.
UPDATED BY
PR12.1 PR12.3 PR12.4 PR29.1 PR512 PR529
PR560 PR582 PR712 PR82.1 UK560

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PEB-EBANK-ID
Element: Ebank Id
Numeric 9
Contains the receiving DFI routing number.
PR12.1 PR12.3
PR12.4 PR29.1
PR512 PR529
PR560 PR582
PR712 PR82.1
UK560
PEB-BANK-NAME
Element: Bnk Name
Alpha 30 (Lower Case)
Contains the name of the bank.
PR12.1 PR12.3
PR12.4 PR29.1
PR512 PR529
PR560 PR582
PR712 PR82.1
UK560
PEB-CA-INST-NBR
Element: Ca Inst Nbr
Numeric 4
Contains the value that identifies the Canadian institution for the employees financial institution.
PR12.1 PR12.3
PR12.4 PR29.1
PR512 PR529
PR560 PR582
PR712 PR82.1
UK560
PEB-CA-TRANSIT-NBR
Element: Ca Transit Nbr
Numeric 5
Contains the Canadian transit number for the employees financial institution.
PR12.1 PR12.3
PR12.4 PR29.1
PR512 PR529
PR560 PR582
PR712 PR82.1
UK560
PEB-COUNTRY-CODE
Element: Country Code
Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
PR12.1 PR12.4
PR712
PEB-ADDR1
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
PR12.1 PR12.4
PEB-ADDR2
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
PR12.1 PR12.4
PEB-ADDR3
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
PR12.1 PR12.4
PEB-ADDR4
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
PR12.1 PR12.4
PEB-ZIP
Element: Zip
Alpha 10
This field contains the postal code of the address.
PR12.1 PR12.4


PREMPBANK FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PEBSET1 EBANK-ID
CA-INST-NBR
CA-TRANSIT-NBR
PR12.1 PR12.3
PR12.4 PR29.1
PR512 PR529
PR560 PR582
PR712 PR82.1
UK560
PEBSET2 COUNTRY-CODE
EBANK-ID
CA-INST-NBR
CA-TRANSIT-NBR
PR712


PREMPBANK FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Instctrycd INSTCTRYCD Required
PEB-COUNTRY-CODE->INT-COUNTRY-CODE


File created: Wed Jun 08 20:51:10 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.