EMPACHDIST – Employee ACH Distribution

System: Payroll (PR)
Prefix: ACD
Primary key: COMPANY, EMPLOYEE, CHECK-ID, ACH-DIST-NBR
Fields: 26
Updated by: 18 programs
Referenced by: 11 programs

EMPACHDIST is the Employee ACH Distribution table in Lawson Payroll (prefix ACD). It is indexed by COMPANY, EMPLOYEE, CHECK-ID, ACH-DIST-NBR (ACDSET1); alternate indexes: ACDSET2 and ACDSET3. It is related 1:1 to PRSYSTEM, EMACHDEPST and EMPLOYEE. It is updated by BN66.1, PR140, PR160, PR180, PR189, PR195, PR197, PR300 and 10 more and referenced by HR170, HR70.1, PR141, PR142, PR155, PR162, PR170, PR260 and 3 more. The table has 26 fields, 3 indexes and 3 documented relations.

About EMPACHDIST

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).

Fields (26)

Column = COBOL field name without the ACD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`ACD-COMPANY` PK COMPANY	Numeric 4	—	BN66.1, PR140, PR160, PR189, PR195, PR560, PR80.1, PR80.4 +2 more
`ACD-EMPLOYEE` PK EMPLOYEE	Numeric 9	Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.	BN66.1, PR140, PR160, PR189, PR195, PR560, PR80.1, PR80.4 +2 more
`ACD-CHECK-ID` PK CHECK_ID	Numeric 12	Contains the payment identification number. When you create a payment record, the system moves the payment ID to this field to serve as the link between the Employee Payment file record and the Employee Pay/Hours History file record.	BN66.1, PR140, PR160, PR189, PR195, PR560, PR80.1, PR80.4 +4 more
`ACD-ACH-DIST-NBR` PK ACH_DIST_NBR	Numeric 2	Contains the value that identifies the default distribution account. The account that serves as the default distribution account must have 100 percent distribution to allow the system to distribute the total balance of net pay.	BN66.1, PR140, PR160, PR189, PR195, PR560, PR80.1, PR80.4 +2 more
`ACD-DIST-AMOUNT` DIST_AMOUNT	Signed 13.2	Contains the amount of pay distributed to the account. It is determined using the Percent of Net and the Deposit Amount fields in the Employee ACH Account file.	BN66.1, PR140, PR189, PR195, PR560, PR80.1, PR80.4, PR85.1 +2 more
`ACD-BANK-ACCT-NBR` BANK_ACCT_NBR	Alpha 17	This field is used to retrieve information about the account to which the amounts from this file are posted.	BN66.1, PR140, PR189, PR195, PR560, PR80.1, PR80.4, PR89.1 +1 more
`ACD-PARTIAL-ACH` PARTIAL_ACH	Alpha 1	Identifies whether an ACH distribution payment is part of a system check. `Y` Yes `N` No	BN66.1, PR140, PR189, PR195, PR560, PR80.1, PR80.4, PR89.1 +1 more
`ACD-ACH-BANK` ACH_BANK	Alpha 1	Identifies whether the bank account number for the ACH portion of the payment is different than from the check portion of the payment. `Y` Yes `N` No	BN66.1, PR140, PR189, PR195, PR560, PR80.1, PR80.4, PR89.1 +1 more
`ACD-CHECK-NBR` CHECK_NBR	Numeric 8	Contains the check number.	BN66.1, PR140, PR160, PR180, PR189, PR195, PR560, PR80.1 +4 more
`ACD-STATUS` STATUS	Numeric 1	This field displays the status of the transaction. `1` Created `2` Open `3` Reconciled `4` Void `6` Historical `7` Void Reversal	BN66.1, PR140, PR160, PR180, PR189, PR195, PR197, PR300 +7 more
`ACD-RECON-DATE` RECON_DATE	Numeric 8 (yyyymmdd)	Represents the date the transaction cleared the bank or was voided. `Y` System checked has been purged	PR197, PR560, PR85.1, PR86.1
`ACD-RECON-AMOUNT` RECON_AMOUNT	Signed 13.2	Contains the employee ACH distribution.	PR197, PR560, PR85.1, PR86.1
`ACD-RECON-PRT-ST` RECON_PRT_ST	Numeric 1	—	PR560, PR85.1
`ACD-REVERSAL-ID` REVERSAL_ID	Numeric 12	Used if the ACH record (EMPACHDIST) is from a partial payment and the EMPACHDIST is being voided, therefore creating PRDISTR records.	PR560, PR85.1
`ACD-CURRENT-FLAG` CURRENT_FLAG	Alpha 1	— `Y` Yes `N` No	PR160, PR180, PR197, PR560, PR85.1
`ACD-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	This field contains the company base currency code established in Company (GL10.1 ).	BN66.1, PR140, PR160, PR189, PR195, PR560, PR80.1, PR80.4 +2 more
`ACD-CURR-ND` CURR_ND	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	BN66.1, PR140, PR160, PR189, PR195, PR560, PR80.1, PR80.4 +2 more
`ACD-EBANK-ID` EBANK_ID	Numeric 9	The value of EAD-EBANK-ID is moved to this field.	BN66.1, PR140, PR189, PR195, PR560, PR80.1, PR80.4, PR89.1 +1 more
`ACD-EBNK-ACCT-NBR` EBNK_ACCT_NBR	Alpha 17	This is the employee's bank account to which the pay is distributed. The value of EAD-EBNK-ACCT-NBR is moved to this field.	BN66.1, PR140, PR189, PR195, PR560, PR80.1, PR80.4, PR89.1 +1 more
`ACD-ACCOUNT-TYPE` ACCOUNT_TYPE	Alpha 1	The value of the EAD-ACCOUNT-TYPE is moved to this field. The type of account is identified on the ACH tape created by PR160 (Check Print) as "23" for checking accounts and "33" for savings accounts. `C` Checking `S` Savings	BN66.1, PR140, PR189, PR195, PR560, PR80.1, PR80.4, PR89.1 +1 more
`ACD-CA-INST-NBR` CA_INST_NBR	Numeric 4	—	BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
`ACD-CA-TRANSIT-NBR` CA_TRANSIT_NBR	Numeric 5	—	BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
`ACD-BANK-ROLL-NO` BANK_ROLL_NO	Alpha 20	—	BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
`ACD-DRILL-EBANK-ID` DRILL_EBANK_ID	Derived	—	—
`ACD-DRILL-EBANK-AC` DRILL_EBANK_AC	Derived	—	—
`ACD-DRILL-ACCT-TYP` DRILL_ACCT_TYP	Derived	—	—

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`ACDSET1`	`COMPANY`, `EMPLOYEE`, `CHECK-ID`, `ACH-DIST-NBR`	Primary		BN66.1, HR170, HR70.1, PR140, PR141, PR142, PR155, PR160 +21 more
`ACDSET2`	`BANK-ACCT-NBR`, `CHECK-NBR`, `COMPANY`, `EMPLOYEE`, `ACH-DIST-NBR`, `CHECK-ID`	KeyChange, Subset	Where PARTIAL-ACH = "Y" And ACH-BANK = "Y"	PR155, PR170, PR85.1, PR85.2
`ACDSET3`	`COMPANY`, `EMPLOYEE`, `CHECK-ID`, `ACH-DIST-NBR`	Subset	Where STATUS = 4 And CURRENT-FLAG = "Y" And PARTIAL-ACH = "Y"	BN66.1, PR140, PR141, PR142, PR189, PR195, PR197, PR80.1 +4 more

Relations

One to one (3) — lookups and parents

Relation	Table	Rules	Field map
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`

Programs

Updated by (18)

BN66.1 Estimated Pay Calculation
PR140 Earnings and Deductions Calculation
PR160 Payment Print
PR180 Manual Payment Print
PR189 Gross Up Calculation
PR195 Accrual Program
PR197 Payroll Close
PR300 History Purge
PR36.1 Time Record Entry
PR36.4 Manual Time Record Maintenance
PR45.1 Error Processing
PR560 Payroll History Load CSV
PR80.1 Manual Check
PR80.4 Manual Payment
PR85.1 Bank Account Reconciliation
PR86.1 Payment Replacement
PR89.1 Payment Modeling
PRAT.1 Alltax connection test

Referenced by (11)

HR170 Human Resource Writer Report Request
HR70.1 Human Resource Writer Inquiry
PR141 Payroll Register
PR142 Consolidated Payroll Register
PR155 Bank Reconciliation
PR162 Payment Register
PR170 Positive Pay File Creation
PR260 Payment Detail Listing
PR261 Payment Detail Listing By Report Entity
PR582 Mass Adjustment Load
PR82.1 Adjustment