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
BN66.1 PR12.1 PR12.3 PR12.4 PR140 PR160
PR189 PR195 PR29.1 PR36.1 PR36.4 PR45.1
PR512 PR529 PR560 PR582 PR712 PR80.1
PR80.4 PR82.1 PR89.1 PRAT.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PEB-EBANK-ID
Element: Ebank Id
Numeric 9
Contains the receiving DFI routing number.
BN66.1 PR12.1
PR12.3 PR12.4
PR140 PR160
PR189 PR195
PR29.1 PR36.1
PR36.4 PR45.1
PR512 PR529
PR560 PR582
PR712 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
PEB-BANK-NAME
Element: Bnk Name
Alpha 30 (Lower Case)
Contains the name of the bank.
BN66.1 PR12.1
PR12.3 PR12.4
PR140 PR160
PR189 PR195
PR29.1 PR36.1
PR36.4 PR45.1
PR512 PR529
PR560 PR582
PR712 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
PEB-CA-INST-NBR
Element: Ca Inst Nbr
Numeric 4
Contains the value that identifies the Canadian institution for the employees financial institution.
BN66.1 PR12.1
PR12.3 PR12.4
PR140 PR160
PR189 PR195
PR29.1 PR36.1
PR36.4 PR45.1
PR512 PR529
PR560 PR582
PR712 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
PEB-CA-TRANSIT-NBR
Element: Ca Transit Nbr
Numeric 5
Contains the Canadian transit number for the employees financial institution.
BN66.1 PR12.1
PR12.3 PR12.4
PR140 PR160
PR189 PR195
PR29.1 PR36.1
PR36.4 PR45.1
PR512 PR529
PR560 PR582
PR712 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
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).
BN66.1 PR12.1
PR12.3 PR12.4
PR140 PR160
PR189 PR195
PR29.1 PR36.1
PR36.4 PR45.1
PR512 PR529
PR560 PR582
PR712 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
PEB-ADDR1
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
BN66.1 PR12.1
PR12.3 PR12.4
PR140 PR160
PR189 PR195
PR29.1 PR36.1
PR36.4 PR45.1
PR512 PR529
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
PRAT.1
PEB-ADDR2
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
BN66.1 PR12.1
PR12.3 PR12.4
PR140 PR160
PR189 PR195
PR29.1 PR36.1
PR36.4 PR45.1
PR512 PR529
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
PRAT.1
PEB-ADDR3
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
BN66.1 PR12.1
PR12.3 PR12.4
PR140 PR160
PR189 PR195
PR29.1 PR36.1
PR36.4 PR45.1
PR512 PR529
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
PRAT.1
PEB-ADDR4
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
BN66.1 PR12.1
PR12.3 PR12.4
PR140 PR160
PR189 PR195
PR29.1 PR36.1
PR36.4 PR45.1
PR512 PR529
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
PRAT.1
PEB-ZIP
Element: Zip
Alpha 10
This field contains the postal code of the address.
BN66.1 PR12.1
PR12.3 PR12.4
PR140 PR160
PR189 PR195
PR29.1 PR36.1
PR36.4 PR45.1
PR512 PR529
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
PRAT.1
PEB-IN-MICR-NO
Element: Micr No
Numeric 9
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
PEB-IFSC
Element: Ifs Code
Alpha 11
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1


PREMPBANK FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PEBSET1 EBANK-ID
CA-INST-NBR
CA-TRANSIT-NBR
BN66.1 PR12.1
PR12.3 PR12.4
PR140 PR160
PR189 PR195
PR29.1 PR36.1
PR36.4 PR45.1
PR512 PR529
PR560 PR582
PR712 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
PEBSET2 COUNTRY-CODE
EBANK-ID
CA-INST-NBR
CA-TRANSIT-NBR
PR712
PEBSET3 IN-MICR-NO
EBANK-ID
CA-INST-NBR
CA-TRANSIT-NBR
PEBSET4 IFSC
EBANK-ID
CA-INST-NBR
CA-TRANSIT-NBR
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
PEBSET5 EBANK-ID*
CA-INST-NBR
CA-TRANSIT-NBR
Subset
WhereCOUNTRY-CODE ="IN"
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1


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: Thu Jun 09 02:30:33 2016

Home
Contact Us



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