Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PREMPBANK


                             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    UK560

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  UK560

PEB-BANK-NAME          Alpha 30  (Lower Case)                    PR12.1  PR12.3
Element: Name          Contains the name of the bank.            PR12.4  PR29.1
                                                                 PR512   PR529
                                                                 PR560   PR712
                                                                 PR82.1  UK560

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  UK560

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  UK560

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

PEB-ADDR3              Alpha 30  (Lower Case)                    PR12.1  PR12.4
Element: Address 1

PEB-ADDR4              Alpha 30  (Lower Case)                    PR12.1  PR12.4
Element: Address 1

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  UK560

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