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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#ACD-COMPANY PKCOMPANY | Numeric 4 | — | BN66.1, PR140, PR160, PR189, PR195, PR560, PR80.1, PR80.4 +2 more |
#ACD-EMPLOYEE PKEMPLOYEE | 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 PKCHECK_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 PKACH_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-AMOUNTDIST_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 SET2BANK_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-ACHPARTIAL_ACH | Alpha 1 | Identifies whether an ACH distribution payment is part of a system check.
| BN66.1, PR140, PR189, PR195, PR560, PR80.1, PR80.4, PR89.1 +1 more |
#ACD-ACH-BANKACH_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.
| BN66.1, PR140, PR189, PR195, PR560, PR80.1, PR80.4, PR89.1 +1 more |
#ACD-CHECK-NBR SET2CHECK_NBR | Numeric 8 | Contains the check number. | BN66.1, PR140, PR160, PR180, PR189, PR195, PR560, PR80.1 +4 more |
#ACD-STATUSSTATUS | Numeric 1 | This field displays the status of the transaction.
| BN66.1, PR140, PR160, PR180, PR189, PR195, PR197, PR300 +7 more |
#ACD-RECON-DATERECON_DATE | Numeric 8 (yyyymmdd) | Represents the date the transaction cleared the bank or was voided.
| PR197, PR560, PR85.1, PR86.1 |
#ACD-RECON-AMOUNTRECON_AMOUNT | Signed 13.2 | Contains the employee ACH distribution. | PR197, PR560, PR85.1, PR86.1 |
#ACD-RECON-PRT-STRECON_PRT_ST | Numeric 1 | — | PR560, PR85.1 |
#ACD-REVERSAL-IDREVERSAL_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-FLAGCURRENT_FLAG | Alpha 1 | —
| PR160, PR180, PR197, PR560, PR85.1 |
#ACD-CURRENCY-CODECURRENCY_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-NDCURR_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-IDEBANK_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-NBREBNK_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-TYPEACCOUNT_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.
| BN66.1, PR140, PR189, PR195, PR560, PR80.1, PR80.4, PR89.1 +1 more |
#ACD-CA-INST-NBRCA_INST_NBR | Numeric 4 | — | BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1 |
#ACD-CA-TRANSIT-NBRCA_TRANSIT_NBR | Numeric 5 | — | BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1 |
#ACD-BANK-ROLL-NOBANK_ROLL_NO | Alpha 20 | — | BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1 |
#ACD-DRILL-EBANK-IDDRILL_EBANK_ID | Derived | — | — |
#ACD-DRILL-EBANK-ACDRILL_EBANK_AC | Derived | — | — |
#ACD-DRILL-ACCT-TYPDRILL_ACCT_TYP | Derived | — | — |
Indexes (3)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
ACDSET1 |
| Primary | BN66.1, HR170, HR70.1, PR140, PR141, PR142, PR155, PR160 +21 more | |
ACDSET2 |
| KeyChange, Subset | Where PARTIAL-ACH = "Y" And ACH-BANK = "Y" | PR155, PR170, PR85.1, PR85.2 |
ACDSET3 |
| 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 | Condition | Field map | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Company | PRSYSTEM | Required |
| ||||||||||
| Emp Ach Depst | EMACHDEPST | Required |
| ||||||||||
| Employee | EMPLOYEE | Required |
|
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