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

PR155

PR162

UPDATED BY

BN66.1	HR170	HR70.1	PR140	PR141	PR142
PR160	PR180	PR189	PR195	PR197	PR260
PR261	PR300	PR36.1	PR45.1	PR560	PR582
PR80.1	PR80.4	PR82.1	PR85.1	PR85.2	PR86.1
PR89.1	UK141	UK560

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 UK560
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 UK560
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 UK560
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 UK560
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 UK560
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 UK560
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 UK560
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 UK560
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 UK560
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 UK560
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 UK560
ACD-RECON-AMOUNT Element: Recon Amount	Signed 13.2 Contains the employee ACH distribution.	PR197 PR560 PR85.1 PR86.1 UK560
ACD-RECON-PRT-ST Element: Recon Prt St	Numeric 1	PR560 PR85.1 UK560
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 UK560
ACD-CURRENT-FLAG Element: Current Flag	Alpha 1 Y = Yes N = No	PR160 PR180 PR197 PR560 PR85.1 UK560
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 UK560
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 UK560
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 UK560
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 UK560
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 UK560
ACD-CA-INST-NBR Element: Ca Inst Nbr	Numeric 4	BN66.1 PR140 PR189 PR195 PR80.1 PR80.4 PR89.1
ACD-CA-TRANSIT-NBR Element: Ca Transit Nbr	Numeric 5	BN66.1 PR140 PR189 PR195 PR80.1 PR80.4 PR89.1
ACD-BANK-ROLL-NO Element: Bank Roll No	Alpha 20	BN66.1 PR140 PR189 PR195 PR80.1 PR80.4 PR89.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.