|
|
EMPACHDIST FILE
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 PR82.1 UK141
UPDATED BY
PR160 PR197 PR300 PR36.1 PR45.1 PR560
PR85.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ACD-COMPANY Numeric 4 PR160 PR560
Element: Company Hr Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
ACD-EMPLOYEE Numeric 9 PR160 PR560
Element: Employee 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.
ACD-CHECK-ID Numeric 12 PR160 PR560
Internal Check ID Contains the payment identification PR85.1
Number 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.
ACD-ACH-DIST-NBR Numeric 2 PR160 PR560
Element: Default ACH 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.
ACD-DIST-AMOUNT Signed 13.2 PR560 PR85.1
Element: Distribution AContains 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.
ACD-BANK-ACCT-NBR Alpha 17 PR560
Element: Bank Account NThe bank-assigned account number
identification to be used for the cash
code.
ACD-PARTIAL-ACH Alpha 1 PR560
Element: Partial Ach Identifies whether an ACH distribution
payment is part of a system check.
Y = Yes
N = No
ACD-ACH-BANK Alpha 1 PR560
Element: ACH Bank 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
ACD-CHECK-NBR Numeric 8 PR160 PR560
Element: Payment NumberContains the check number.
ACD-STATUS Numeric 1 PR160 PR197
Element: Status This field displays the status of the PR300 PR560
transaction. PR85.1
1 = Created
2 = Open
3 = Reconciled
4 = Void
6 = Historical
7 = Void Reversal
ACD-RECON-DATE Numeric 8 (yyyymmdd) PR197 PR560
Reconciliation or Represents the date the transaction PR85.1
Void Date cleared the bank or was voided.
Y = System checked has been purged
ACD-RECON-AMOUNT Signed 13.2 PR197 PR560
Element: Reconciled AmoContains the employee ACH distribution. PR85.1
ACD-RECON-PRT-ST Numeric 1 PR560 PR85.1
Reconciliation
Print Status
ACD-REVERSAL-ID Numeric 12 PR560 PR85.1
Element: Reversal CheckUsed if the ACH record (EMPACHDIST) is
from a partial payment and the
EMPACHDIST is being voided, therefore
creating PRDISTR records.
ACD-CURRENT-FLAG Alpha 1 PR160 PR197
Element: Current Flag Y = Yes PR560 PR85.1
N = No
ACD-CURRENCY-CODE Alpha 5 PR160 PR560
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
ACD-CURR-ND Numeric 1 PR160 PR560
Account Currency Represents the number of decimals
Code defined for the currency of the object.
ACD-EBANK-ID Numeric 9 PR560
Employee ACH The value of EAD-EBANK-ID is moved
Account Bank Id to this field.
ACD-EBNK-ACCT-NBR Alpha 17 PR560
Employee ACH Bank This is the employee's bank account to
Account Nbr which the pay is distributed. The value
of EAD-EBNK-ACCT-NBR is moved to this
field.
ACD-ACCOUNT-TYPE Alpha 1 PR560
Element: Account Type 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
ACD-CA-INST-NBR Numeric 4
Element: Ca Inst Nbr
ACD-CA-TRANSIT-NBR Numeric 5
Element: Ca Transit Nbr
ACD-BANK-ROLL-NO Alpha 20
Element: Bank Roll No
ACD-DRILL-EBANK-ID Derived
Element: Drill Ebank Id
ACD-DRILL-EBANK-AC Derived
Element: Drill Ebank Ac
ACD-DRILL-ACCT-TYP Derived
Element: Drill Acct Typ
EMPACHDIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ACDSET1 COMPANY HR170 HR70.1
EMPLOYEE PR141 PR142
CHECK-ID PR155 PR160
ACH-DIST-NBR PR162 PR197
PR260 PR300
PR36.1 PR45.1
PR560 PR82.1
PR85.1 PR85.2
UK141
ACDSET2 BANK-ACCT-NBR KeyChange, Subset PR155 PR85.1
CHECK-NBR Where PARTIAL-ACH = "Y" PR85.2
COMPANY And ACH-BANK = "Y"
EMPLOYEE
ACH-DIST-NBR
CHECK-ID
ACDSET3 COMPANY Subset PR141 PR142
EMPLOYEE Where STATUS = 4 PR197 PR85.1
CHECK-ID And CURRENT-FLAG = "Y" UK141
ACH-DIST-NBR And PARTIAL-ACH = "Y"
EMPACHDIST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|
