EMPACHDIST

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ACDSET1 COMPANY
EMPLOYEE
CHECK-ID
ACH-DIST-NBR
BN66.1 HR170
HR70.1 PR140
PR141 PR142
PR155 PR160
PR162 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
ACDSET2 BANK-ACCT-NBR
CHECK-NBR
COMPANY
EMPLOYEE
ACH-DIST-NBR
CHECK-ID
KeyChange, Subset
WherePARTIAL-ACH ="Y"
AndACH-BANK ="Y"
PR155 PR85.1
PR85.2
ACDSET3 COMPANY
EMPLOYEE
CHECK-ID
ACH-DIST-NBR
Subset
WhereSTATUS =4
AndCURRENT-FLAG ="Y"
AndPARTIAL-ACH ="Y"
BN66.1 PR140
PR141 PR142
PR189 PR195
PR197 PR80.1
PR80.4 PR85.1
PR89.1 UK141


EMPACHDIST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:27:06 2016

Home
Contact Us



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