Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

EMPACHDIST


                            EMPACHDIST FILE

                       Employee ACH Distribution

The Employee ACH Distribution file contains the employee ACH distribution
account information. When you generate a payment, the system creates a record
in the Employee Payment file record for every employee ACH account to which
pay is distributed. Employee ACH account information is stored in the Employee
ACH Account file. PR140 (Earnings and Deductions Calculation) is the primary
program that updates this file. A record is also created in this file when the
account prenotification is created by PR160 (Payment Print).

REFERENCED BY

ET530     HR170     HR70.1    PR141     PR142     PR155
PR162     PR260     PR261     PR82.1    UK141

UPDATED BY

BN66.1    PR140     PR160     PR189     PR195     PR197
PR300     PR36.1    PR45.1    PR560     PR80.1    PR85.1
PR86.1    PR89.1    UK560

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ACD-COMPANY            Numeric 4                                 BN66.1  PR140
Element: Company Hr                                              PR160   PR189
                                                                 PR195   PR560
                                                                 PR80.1  PR89.1
                                                                 UK560

ACD-EMPLOYEE           Numeric 9                                 BN66.1  PR140
Element: Employee      Contains the employee number. Each        PR160   PR189
                       person employed by the company is         PR195   PR560
                       assigned a unique number. The system      PR80.1  PR89.1
                       uses the employee number to correlate     UK560
                       all of the information related to that
                       person.

ACD-CHECK-ID           Numeric 12                                BN66.1  PR140
Element: Check Id      Contains the payment identification       PR160   PR189
                       number. When you create a payment         PR195   PR560
                       record, the system moves the payment ID   PR80.1  PR85.1
                       to this field to serve as the link        PR86.1  PR89.1
                       between the Employee Payment file record  UK560
                       and the Employee Pay/Hours History file
                       record.

ACD-ACH-DIST-NBR       Numeric 2                                 BN66.1  PR140
Element: Ach Dist Nbr  Contains the value that identifies the    PR160   PR189
                       default distribution account. The         PR195   PR560
                       account that serves as the default        PR80.1  PR89.1
                       distribution account must have 100        UK560
                       percent distribution to allow the system
                       to distribute the total balance of net
                       pay.

ACD-DIST-AMOUNT        Signed 13.2                               BN66.1  PR140
Element: Dist Amount   Contains the amount of pay distributed    PR189   PR195
                       to the account. It is determined using    PR560   PR80.1
                       the Percent of Net and the Deposit        PR85.1  PR89.1
                       Amount fields in the Employee ACH         UK560
                       Account file.

ACD-BANK-ACCT-NBR      Alpha 17                                  BN66.1  PR140
Element: Bnk Acct Nbr  This field is used to retrieve            PR189   PR195
                       information about the account to which    PR560   PR80.1
                       the amounts from this file are posted.    PR89.1  UK560

ACD-PARTIAL-ACH        Alpha 1                                   BN66.1  PR140
Element: Partial Ach   Identifies whether an ACH distribution    PR189   PR195
                       payment is part of a system check.        PR560   PR80.1
                       Y = Yes                                   PR89.1  UK560
                       N = No

ACD-ACH-BANK           Alpha 1                                   BN66.1  PR140
Element: Ach Bank      Identifies whether the bank account       PR189   PR195
                       number for the ACH portion of the         PR560   PR80.1
                       payment is different than from the check  PR89.1  UK560
                       portion of the payment.
                       Y = Yes
                       N = No

ACD-CHECK-NBR          Numeric 8                                 PR160   PR560
Element: Check Nbr     Contains the check number.                PR86.1  UK560

ACD-STATUS             Numeric 1                                 BN66.1  PR140
Element: Status        This field displays the status of the     PR160   PR189
                       transaction.                              PR195   PR197
                       1 = Created                               PR300   PR560
                       2 = Open                                  PR80.1  PR85.1
                       3 = Reconciled                            PR86.1  PR89.1
                       4 = Void                                  UK560
                       6 = Historical
                       7 = Void Reversal

ACD-RECON-DATE         Numeric 8  (yyyymmdd)                     PR197   PR560
Element: Recon Date    Represents the date the transaction       PR85.1  PR86.1
                       cleared the bank or was voided.           UK560
                       Y = System checked has been purged

ACD-RECON-AMOUNT       Signed 13.2                               PR197   PR560
Element: Recon Amount  Contains the employee ACH distribution.   PR85.1  PR86.1
                                                                 UK560

ACD-RECON-PRT-ST       Numeric 1                                 PR560   PR85.1
Element: Recon Prt St                                            UK560

ACD-REVERSAL-ID        Numeric 12                                PR560   PR85.1
Element: Reversal Id   Used if the ACH record (EMPACHDIST) is    UK560
                       from a partial payment and the
                       EMPACHDIST is being voided, therefore
                       creating PRDISTR records.

ACD-CURRENT-FLAG       Alpha 1                                   PR160   PR197
Element: Current Flag  Y = Yes                                   PR560   PR85.1
                       N = No                                    UK560

ACD-CURRENCY-CODE      Alpha 5                                   BN66.1  PR140
Element: Currency Code This field contains the company base      PR160   PR189
                       currency code established in Company      PR195   PR560
                       (GL10.1 ).                                PR80.1  PR89.1
                                                                 UK560

ACD-CURR-ND            Numeric 1                                 BN66.1  PR140
Element: Acct Nd       The number of decimals assigned to a      PR160   PR189
                       particular account as determined by the   PR195   PR560
                       account currency.                         PR80.1  PR89.1
                                                                 UK560

ACD-EBANK-ID           Numeric 9                                 BN66.1  PR140
Element: Ebank Id      The value of EAD-EBANK-ID is moved        PR189   PR195
                       to this field.                            PR560   PR80.1
                                                                 PR89.1  UK560

ACD-EBNK-ACCT-NBR      Alpha 17                                  BN66.1  PR140
Element: Ebnk Acct Nbr This is the employee's bank account to    PR189   PR195
                       which the pay is distributed. The value   PR560   PR80.1
                       of EAD-EBNK-ACCT-NBR is moved to this     PR89.1  UK560
                       field.

ACD-ACCOUNT-TYPE       Alpha 1                                   BN66.1  PR140
Element: Account Type  The value of the EAD-ACCOUNT-TYPE is      PR189   PR195
                       moved to this field.  The type of         PR560   PR80.1
                       account is identified on the ACH tape     PR89.1  UK560
                       created by PR160 (Check Print) as "23"
                       for checking  accounts and "33" for
                       savings accounts.
                       C = Checking
                       S = Savings

ACD-CA-INST-NBR        Numeric 4                                 BN66.1  PR140
Element: Ca Inst Nbr                                             PR189   PR195
                                                                 PR80.1  PR89.1

ACD-CA-TRANSIT-NBR     Numeric 5                                 BN66.1  PR140
Element: Ca Transit Nbr                                          PR189   PR195
                                                                 PR80.1  PR89.1

ACD-BANK-ROLL-NO       Alpha 20                                  BN66.1  PR140
Element: Bank Roll No                                            PR189   PR195
                                                                 PR80.1  PR89.1

ACD-DRILL-EBANK-ID     Derived
Element: Drill Ebank Id

ACD-DRILL-EBANK-AC     Derived
Element: Drill Ebank Ac

ACD-DRILL-ACCT-TYP     Derived
Element: Drill Acct Typ

                         EMPACHDIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ACDSET1   COMPANY                                                BN66.1  ET530
          EMPLOYEE                                               HR170   HR70.1
          CHECK-ID                                               PR140   PR141
          ACH-DIST-NBR                                           PR142   PR155
                                                                 PR160   PR162
                                                                 PR189   PR195
                                                                 PR197   PR260
                                                                 PR261   PR300
                                                                 PR36.1  PR45.1
                                                                 PR560   PR80.1
                                                                 PR82.1  PR85.1
                                                                 PR85.2  PR86.1
                                                                 PR89.1  UK141
                                                                 UK560

ACDSET2   BANK-ACCT-NBR KeyChange, Subset                        PR155   PR85.1
          CHECK-NBR     Where PARTIAL-ACH = "Y"                  PR85.2
          COMPANY       And   ACH-BANK    = "Y"
          EMPLOYEE
          ACH-DIST-NBR
          CHECK-ID

ACDSET3   COMPANY       Subset                                   BN66.1  PR140
          EMPLOYEE      Where STATUS       = 4                   PR141   PR142
          CHECK-ID      And   CURRENT-FLAG = "Y"                 PR189   PR195
          ACH-DIST-NBR  And   PARTIAL-ACH  = "Y"                 PR197   PR80.1
                                                                 PR85.1  PR89.1
                                                                 UK141

                         EMPACHDIST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            ACD-COMPANY         -> PRS-COMPANY
                            Spaces              -> PRS-PROCESS-LEVEL

Emp Ach Depst  EMACHDEPST   Required

                            ACD-COMPANY         -> EAD-COMPANY
                            ACD-EMPLOYEE        -> EAD-EMPLOYEE
                            ACD-ACH-DIST-NBR    -> EAD-ACH-DIST-NBR

Employee       EMPLOYEE     Required

                            ACD-COMPANY         -> EMP-COMPANY
                            ACD-EMPLOYEE        -> EMP-EMPLOYEE