Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BANKACCT


                             BANKACCT FILE

                              Bank Account

Contains information about bank accounts. PR01.1 (Bank Account) is the
primary program that updates this file. Note that company is not part of the
key, thus bank accounts can be used by more than one company.

REFERENCED BY

HBAC.1    HR200     HR201     PR155     PR162     PR165
PR180     PR201     PR281     PR300     PR82.1    PR85.1

UPDATED BY

HR00.1    HR01.1    PBIP.1    PR01.1    PR160     PR197
PR712

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BAC-BNK-ACCT-NBR       Alpha 17                                  HR00.1  HR01.1
Element: Bank Account NContains the bank account from which      PBIP.1  PR01.1
                       payroll payments are drawn.               PR197

BAC-BANK-ID            Numeric 9                                 HR00.1  HR01.1
Bank Identification    Contains the ID number assigned to the    PBIP.1  PR01.1
Number                 bank by the                               PR197
                       Federal Reserve.

BAC-BANK-NAME          Alpha 30  (Lower Case)                    HR00.1  HR01.1
Element: Bnk Name      Contains the bank name.                   PBIP.1  PR01.1
                                                                 PR197

BAC-SEND-PT-ID         Numeric 9                                 HR00.1  HR01.1
Element: Sending Bank IContains the ID assigned by the Federal   PBIP.1  PR01.1
                       Reserve to the bank that processes the    PR197
                       ACH tape.

BAC-SEND-PT-NAME       Alpha 30  (Lower Case)                    HR00.1  HR01.1
Element: Sending Bank NContains the name of the sending DFI      PBIP.1  PR01.1
                       bank.                                     PR197

BAC-ACH-OPTION         Alpha 1                                   HR00.1  HR01.1
Element: ACH Option    Contains the value that indicates if      PBIP.1  PR01.1
                       the bank account allows ACH payments to   PR197
                       be made.
                       N = No ACH allowed
                       Y = ACH allowed

BAC-CHECK-OPTION       Numeric 1                                 HR00.1  HR01.1
Element: Payment FormatContains the value that determines        PBIP.1  PR01.1
                       which payment format is printed by PR160  PR197   PR712
                       (Payment Print).
                       0 = Over/Under Limited YTD
                       1 = Over/Under Stub On Top
                       2 = Over/Under Stub On Bottom
                       3 = Side/Side No TA Balances
                       4 = Side/Side TA Balances
                       5 = Side/Side Heat Sealed
                       8 = Laser Print File
                       9 = Over/Under Mailer

BAC-RECEIPT-OPTION     Numeric 1                                 HR00.1  HR01.1
Element: Receipt OptionContains the value that determines the    PBIP.1  PR01.1
                       format for the ACH receipt.               PR197   PR712
                       0 = Over/Under Limited YTD
                       1 = Over/Under Stub On Top
                       2 = Over/Under Stub On Bottom
                       3 = Side/Side No TA Balances
                       4 = Side/Side TA Balances
                       5 = Side/Side Heat Sealed
                       8 = Laser Print File
                       9 = Over/Under Mailer

BAC-PRENOTE-OPTION     Alpha 1                                   HR00.1  HR01.1
Element: Prenote OptionContains the value that indicates         PBIP.1  PR01.1
                       whether or not to create prenotes.        PR197
                       N = No
                       Y = Yes

BAC-COUNTRY-CODE       Alpha 2                                   HR00.1  HR01.1
Element: Country Code  The country code.  Required for VAT and   PBIP.1  PR01.1
                       intrastat reporting.  Must be defined in  PR197
                        IN01.1 (Country Maintenance).

BAC-DEST-DATA-CTRE     Numeric 5                                 HR00.1  HR01.1
Element: Dest Data CtreContains the value that defines the data  PBIP.1  PR01.1
                       centre bank and location.                 PR197

BAC-INST-ID-RET        Numeric 9                                 HR00.1  HR01.1
Element: Inst Id Ret   Used to identify the institutional ID     PBIP.1  PR01.1
                       for the account where returned items are  PR197
                       directed.

                       Format is: abbbccccc
                       a = 0 constant zero
                       bbb = institution number
                       ccccc = branch transit number.

BAC-RET-ACCT-NBR       Alpha 12  (Lower Case)                    HR00.1  HR01.1
Element: Ret Acct Nbr  Contains the account where returned       PBIP.1  PR01.1
                       items are directed.                       PR197

BAC-CLIENT-NBR         Alpha 10  (Lower Case)                    HR00.1  HR01.1
Element: Client Nbr    Identifying ID for the client. Assigned   PBIP.1  PR01.1
                       by the bank or bank and client.           PR197

BAC-FILE-CRT-NBR       Numeric 4                                 PR160
Element: File Crt Nbr   Contains the value which identifies the
                       ACSS/Direct Deposit file as unique from
                       the last file created. Incremented by
                       one each time a file is created. When it
                       reaches 9999, it starts over at 0001.

BAC-DEST-DATA-NAME     Alpha 30  (Lower Case)                    HR00.1  HR01.1
Element: Dest Data NameContains the name of the Destination      PBIP.1  PR01.1
                       Data Centre.                              PR197

BAC-INST-RET-NAME      Alpha 30  (Lower Case)                    HR00.1  HR01.1
Element: Inst Ret Name Contains the name of the  institution     PBIP.1  PR01.1
                       for returns.                              PR197

                         BANKACCT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BACSET1   BNK-ACCT-NBR                                           HBAC.1  HR00.1
                                                                 HR01.1  HR200
                                                                 HR201   PBIP.1
                                                                 PR01.1  PR01.2
                                                                 PR155   PR160
                                                                 PR162   PR165
                                                                 PR180   PR197
                                                                 PR201   PR281
                                                                 PR300   PR712
                                                                 PR82.1  PR85.1

BACSET2   COUNTRY-CODE                                           PR01.1  PR201
          BNK-ACCT-NBR                                           PR712

                         BANKACCT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Bankcode       BANKFILE     Delete Restricted

                            BAC-BNK-ACCT-NBR    -> BFL-BNK-ACCT-NBR
                                                   BFL-COMPANY
                                                   BFL-BANK-CODE

Checks         PRCHECK      Delete Restricted

                            BAC-BNK-ACCT-NBR    -> PCH-BNK-ACCT-NBR
                                                   PCH-PRINT-TYPE
                                                   PCH-CHECK-NBR
                                                   PCH-CHECK-ID