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

HR170	HR70.1	PR141	PR142	PR155	PR162
PR260	PR261	PR582	PR82.1	PR170

UPDATED BY

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

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
ACD-COMPANY Element: Company Hr	Numeric 4	BN66.1 PR140 PR160 PR189 PR195 PR560 PR80.1 PR80.4 PR89.1 PRAT.1
ACD-EMPLOYEE Element: 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 PR89.1 PRAT.1
ACD-CHECK-ID Element: 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 PR85.1 PR86.1 PR89.1 PRAT.1
ACD-ACH-DIST-NBR Element: 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 PR89.1 PRAT.1
ACD-DIST-AMOUNT Element: 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 PR89.1 PRAT.1
ACD-BANK-ACCT-NBR Element: Bnk 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 PRAT.1
ACD-PARTIAL-ACH Element: 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 PRAT.1
ACD-ACH-BANK Element: 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 PRAT.1
ACD-CHECK-NBR Element: Check Nbr	Numeric 8 Contains the check number.	BN66.1 PR140 PR160 PR180 PR189 PR195 PR560 PR80.1 PR80.4 PR86.1 PR89.1 PRAT.1
ACD-STATUS Element: 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 PR560 PR80.1 PR80.4 PR85.1 PR86.1 PR89.1 PRAT.1
ACD-RECON-DATE Element: 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 Element: Recon Amount	Signed 13.2 Contains the employee ACH distribution.	PR197 PR560 PR85.1 PR86.1
ACD-RECON-PRT-ST Element: Recon Prt St	Numeric 1	PR560 PR85.1
ACD-REVERSAL-ID Element: 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 Element: Current Flag	Alpha 1 Y = Yes N = No	PR160 PR180 PR197 PR560 PR85.1
ACD-CURRENCY-CODE Element: 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 PR89.1 PRAT.1
ACD-CURR-ND Element: Acct 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 PR89.1 PRAT.1
ACD-EBANK-ID Element: 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 PRAT.1
ACD-EBNK-ACCT-NBR Element: 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 PRAT.1
ACD-ACCOUNT-TYPE Element: 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 PRAT.1
ACD-CA-INST-NBR Element: Ca Inst Nbr	Numeric 4	BN66.1 PR140 PR189 PR195 PR80.1 PR80.4 PR89.1 PRAT.1
ACD-CA-TRANSIT-NBR Element: Ca Transit Nbr	Numeric 5	BN66.1 PR140 PR189 PR195 PR80.1 PR80.4 PR89.1 PRAT.1
ACD-BANK-ROLL-NO Element: Bank Roll No	Alpha 20	BN66.1 PR140 PR189 PR195 PR80.1 PR80.4 PR89.1 PRAT.1
ACD-DRILL-EBANK-ID Element: Drill Ebank Id	Derived
ACD-DRILL-EBANK-AC Element: Drill Ebank Ac	Derived
ACD-DRILL-ACCT-TYP Element: Drill Acct Typ	Derived

EMPACHDIST FILE INDEX

EMPACHDIST FILE RELATIONS

ONE TO ONE RELATIONS

All trademarks and registered trademarks are the property of their respective owners.