PREMPBANK FILE
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 PR712 PR82.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PEB-EBANK-ID Numeric 9 PR12.1 PR12.3
Employee ACH Contains the receiving DFI routing PR12.4 PR29.1
Account Bank Id number. PR512 PR529
PR560 PR712
PR82.1
PEB-BANK-NAME Alpha 30 (Lower Case) PR12.1 PR12.3
Element: Bnk Name Contains the name of the bank. PR12.4 PR29.1
PR512 PR529
PR560 PR712
PR82.1
PEB-CA-INST-NBR Numeric 4 PR12.1 PR12.3
Element: Ca Inst Nbr Contains the value that identifies the PR12.4 PR29.1
Canadian institution for the employees PR512 PR529
financial institution. PR560 PR712
PR82.1
PEB-CA-TRANSIT-NBR Numeric 5 PR12.1 PR12.3
Element: Ca Transit NbrContains the Canadian transit number for PR12.4 PR29.1
the employees financial institution. PR512 PR529
PR560 PR712
PR82.1
PEB-COUNTRY-CODE Alpha 2 PR12.1 PR12.4
Element: Country Code The country code. Required for VAT and PR712
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
PEB-ADDR1 Alpha 30 (Lower Case) PR12.1 PR12.4
Element: Address 1 This field contains the first line of
address information.
PEB-ADDR2 Alpha 30 (Lower Case) PR12.1 PR12.4
Element: Address 1 This field contains the second line of
address information.
PEB-ADDR3 Alpha 30 (Lower Case) PR12.1 PR12.4
Element: Address 1 This field contains the third line of
address information.
PEB-ADDR4 Alpha 30 (Lower Case) PR12.1 PR12.4
Element: Address 1 This field contains the fourth line of
address information.
PEB-ZIP Alpha 10 PR12.1 PR12.4
Element: Postal Code This field contains the postal code of
the address.
PREMPBANK FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PEBSET1 EBANK-ID PR12.1 PR12.3
CA-INST-NBR PR12.4 PR29.1
CA-TRANSIT-NBR PR512 PR529
PR560 PR712
PR82.1
PEBSET2 COUNTRY-CODE PR712
EBANK-ID
CA-INST-NBR
CA-TRANSIT-NBR
PREMPBANK FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Instctrycd INSTCTRYCD Required
PEB-COUNTRY-CODE -> INT-COUNTRY-CODE
|
