EMACHDEPST – Employee ACH Account

System
Payroll (PR)
Prefix
EAD
Primary key
COMPANY, EMPLOYEE, ACH-DIST-NBR
Fields
49
Updated by
22 programs
Referenced by
11 programs

EMACHDEPST is the Employee ACH Account table in Lawson Payroll (prefix EAD). It is indexed by COMPANY, EMPLOYEE, ACH-DIST-NBR (EADSET1); alternate indexes: EADSET10, EADSET11, EADSET2, EADSET3, EADSET4, EADSET5, EADSET6, EADSET7 and 2 more. It is related 1:1 to PRSYSTEM, EMPLOYEE and PREMPBANK and 1:M to HRHISTORY. It is updated by BN66.1, HR11.1, PA115, PR12.1, PR12.3, PR140, PR160, PR189 and 14 more and referenced by HR170, HR70.1, HR94.1, PR141, PR155, PR162, PR180, PR212 and 3 more. The table has 49 fields, 11 indexes and 5 documented relations.

About EMACHDEPST

This file contains information about employee Automated Clearing House (ACH) accounts and usage. When net pay is distributed into ACH accounts, the distribution history is recorded in the Employee ACH Distribution file. PR12.1 (ACH Distribution) is the primary program that updates this file. You can define up to nine different accounts for an employee.

Fields (49)

Column = COBOL field name without the EAD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
EAD-COMPANY PK
COMPANY		Numeric 4—BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EAD-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains 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, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EAD-ACH-DIST-NBR PK
ACH_DIST_NBR		Numeric 2Contains the ACH distribution account numbers defined for an employee. You can define up to nine different accounts for an employee.BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EAD-OCCURANCES
OCCURANCES		Numeric 3Contains the total number of times you want the system to take the distribution. If you do not want to regulate the number of times the distribution is taken, leave the Occurrences - Original field blank in PR12.1 (Distribution).BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EAD-REMAIN-OCCUR
REMAIN_OCCUR		Numeric 3Contains the value that indicates the remaining number of times a distribution is to be taken.BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EAD-EBANK-ID
EBANK_ID		Numeric 9Contains the employee's bank DFI (Depository Financial Institution) identification number.BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EAD-EBNK-ACCT-NBR
EBNK_ACCT_NBR		Alpha 17Contains the employee's bank account number where payments are deposited.BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EAD-ACCOUNT-TYPE
ACCOUNT_TYPE		Alpha 1Contains the value that identifies the bank account as a checking or savings account. The account type is identified on the tape created by PR160 (Payment Print) as 23 for checking accounts and 33 for savings accounts.
  • C Checking
  • S Savings
BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EAD-ACH-PRENOTIFY
ACH_PRENOTIFY		Alpha 1Contains the ACH prenotification status between the account and the processing bank. When you define an ACH account, the prenotify status is Not Prenotified. When you run PR160 (Payment Print) to create prenotifications, the status changes to Prenotified. When the bank accepts the tape with the prenotification, you must manually change the status to Accepted. The system does not distribute net pay to an account until the status is Accepted.
  • A Accepted
  • N Not Prenotified
  • P Prenotified
BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EAD-NET-PERCENT
NET_PERCENT		Signed 7.3Contains the percent of the employee's net pay to be deposited into the account. Each account has either a percent or flat amount identified.BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EAD-DEPOSIT-AMT
DEPOSIT_AMT		Signed 13.2Contains the flat amount to be deposited into the account. Each account has either a flat amount or a percent indicated.BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EAD-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)Contains the ACH distribution description.BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EAD-CHECK-DESC
CHECK_DESC		Alpha 8 (Lower Case)Contains the ACH distribution identifier that prints on the payment stub or pay receipt and on reports generated by PR140 (Earnings and Deductions Calculation).BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EAD-BEG-DATE
BEG_DATE		Numeric 8 (yyyymmdd)Contains the effective date deposits can be made to the entered account.BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EAD-END-DATE
END_DATE		Numeric 8 (yyyymmdd)Contains the last date deposits can be made to the entered account.BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EAD-DED-CYCLE
DED_CYCLE		Alpha 1 Occurs 9 Times ×9Contains the value that indicates the payroll cycles in which the system takes the ACH distribution. XBN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EAD-DEFAULT-FLAG
DEFAULT_FLAG		Alpha 1Contains the value that identifies the account as the default account to which the system deposits remaining amounts if you do not specify 100 percent distribution on the Pay form tab on HR11.1 (Employee).
  • Y Default ACH Account
BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EAD-BANK-ROLL-NO
BANK_ROLL_NO		Alpha 20Contains additional bank information needed if an employee's bank is a building society. Informational only. (UK requirement)BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EAD-ACH-DIST-ORDER
ACH_DIST_ORDER		Numeric 2Contains the number that indicates the order that ACH distributions are taken. The ACH distribution record selected as the default will always be the last one processed. If partial auto deposit is selected, the check is where the remaining dollars are distributed to.BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EAD-CA-INST-NBR
CA_INST_NBR		Numeric 4Contains the value that identifies the Canadian institution for the employees direct deposit.BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EAD-CA-TRANSIT-NBR
CA_TRANSIT_NBR		Numeric 5Contains the Canadian transit number for the employees direct deposit.BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EAD-COUNTRY-CODE
COUNTRY_CODE		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance). " " = USA
  • CA Canada
  • US USA
  • UK United Kingdom
  • GB Great Britain
BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EAD-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).—
EAD-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.—
EAD-PENS-SEQ-NBR
PENS_SEQ_NBR		Numeric 4—BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EAD-NON-STD-ENTRY
NON_STD_ENTRY		Numeric 10
  • 1 Split
  • 2 NatWest
  • 3 Co-Op
BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EAD-ORIG-ACCT-NBR
ORIG_ACCT_NBR		Alpha 17—BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EAD-PAYABLE-TO
PAYABLE_TO		Alpha 38 (Lower Case)—BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EAD-PRINT-RCPT
PRINT_RCPT		Alpha 1—BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EAD-DED-CYCLE-GRP
DED_CYCLE_GRP		Derived——
EAD-DED-CYCLE-1
DED_CYCLE_1		Derived——
EAD-DED-CYCLE-2
DED_CYCLE_2		Derived——
EAD-DED-CYCLE-3
DED_CYCLE_3		Derived——
EAD-DED-CYCLE-4
DED_CYCLE_4		Derived——
EAD-DED-CYCLE-5
DED_CYCLE_5		Derived——
EAD-DED-CYCLE-6
DED_CYCLE_6		Derived——
EAD-DED-CYCLE-7
DED_CYCLE_7		Derived——
EAD-DED-CYCLE-8
DED_CYCLE_8		Derived——
EAD-DED-CYCLE-9
DED_CYCLE_9		Derived——
EAD-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EAD-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EAD-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)Contains the user ID of the person who last changed this record.BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EAD-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EAD-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EAD-USER-ID
USER_ID		Alpha 10 (Lower Case)Contains the user ID of the person who last changed this record.BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EAD-OBJ-ID
OBJ_ID		Numeric 12—BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EAD-IAT-ACH
IAT_ACH		Alpha 1N YBN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EAD-IN-MICR-NO
IN_MICR_NO		Numeric 9—BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EAD-IFSC
IFSC		Alpha 11—BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more

Indexes (11)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
EADSET1COMPANY, EMPLOYEE, ACH-DIST-NBRPrimaryBN66.1, HR11.1, HR170, HR70.1, HR94.1, PA115, PR12.1, PR12.3 +22 more (list truncated in source)
EADSET10IN-MICR-NO, COMPANY, EMPLOYEE, ACH-DIST-NBR—
EADSET11IFSC, COMPANY, EMPLOYEE, ACH-DIST-NBRBN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EADSET2COMPANY, EMPLOYEE, DEFAULT-FLAG, ACH-DIST-ORDER, ACH-DIST-NBRKeyChange, SubsetWhere ACH-DIST-ORDER != ZeroesBN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
EADSET3COMPANY, EMPLOYEE, ACH-DIST-NBRKeyChange, SubsetWhere ACH-PRENOTIFY = "N"PR160
EADSET4COMPANY, EMPLOYEE, ACH-DIST-ORDER, ACH-DIST-NBRKeyChange, SubsetWhere ACH-DIST-ORDER != ZeroesBN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EADSET5COMPANY, EMPLOYEE, ACH-DIST-NBRKeyChange, SubsetWhere OCCURANCES != ZeroesBN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
EADSET6COMPANY, EMPLOYEE, COUNTRY-CODE, ACH-DIST-NBRBN66.1, PR12.1, PR12.2, PR12.3, PR140, PR160, PR189, PR195 +13 more
EADSET7COMPANY, EMPLOYEE, PENS-SEQ-NBR, ACH-DIST-NBRKeyChange, SubsetWhere PENS-SEQ-NBR = ZeroesPR12.1
EADSET8COMPANY, EMPLOYEE, PENS-SEQ-NBR, ACH-DIST-NBRKeyChange, SubsetWhere PENS-SEQ-NBR != ZeroesBN66.1, PR140, PR189, PR195, PR229, PR29.1, PR529, PR560 +6 more
EADSET9OBJ-IDSubsetWhere (OBJ-ID != Zeroes)HR94.1

Relations

One to one (4) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredEAD-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequiredEAD-COMPANY → EMP-COMPANY, EAD-EMPLOYEE → EMP-EMPLOYEE
PrempbankcaPREMPBANKRequiredWhen EAD-COUNTRY-CODE = "CA"Zeroes → PEB-EBANK-ID, EAD-CA-INST-NBR → PEB-CA-INST-NBR, EAD-CA-TRANSIT-NBR → PEB-CA-TRANSIT-NBR
PrempbankusPREMPBANKRequiredEAD-EBANK-ID → PEB-EBANK-ID, Zeroes → PEB-CA-INST-NBR, Zeroes → PEB-CA-TRANSIT-NBR

One to many (1) — child tables

RelationTableRulesConditionField map
HrhistoryHRHISTORYValid When (EAD-OBJ-ID != Zeroes)EAD-COMPANY → HRH-COMPANY, EAD-EMPLOYEE → HRH-EMPLOYEE, EAD-OBJ-ID → HRH-OBJ-ID, → HRH-FLD-NBR, → HRH-POS-LEVEL, → HRH-BEG-DATE, → HRH-SEQ-NBR

Programs

Updated by (22)

Referenced by (11)