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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 SET2
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 SET2 SET4
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 SET6
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 SET7 SET8
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 SET9
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 SET10
IN_MICR_NO		Numeric 9—BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
#EAD-IFSC SET11
IFSC		Alpha 11—BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more

Indexes (11)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
EADSET1
  1. COMPANY
  2. EMPLOYEE
  3. ACH-DIST-NBR
PrimaryBN66.1, HR11.1, HR170, HR70.1, HR94.1, PA115, PR12.1, PR12.3 +22 more (list truncated in source)
EADSET10
  1. IN-MICR-NO
  2. COMPANY
  3. EMPLOYEE
  4. ACH-DIST-NBR
—
EADSET11
  1. IFSC
  2. COMPANY
  3. EMPLOYEE
  4. ACH-DIST-NBR
BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EADSET2
  1. COMPANY
  2. EMPLOYEE
  3. DEFAULT-FLAG
  4. ACH-DIST-ORDER
  5. ACH-DIST-NBR
KeyChange, SubsetWhere ACH-DIST-ORDER != ZeroesBN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
EADSET3
  1. COMPANY
  2. EMPLOYEE
  3. ACH-DIST-NBR
KeyChange, SubsetWhere ACH-PRENOTIFY = "N"PR160
EADSET4
  1. COMPANY
  2. EMPLOYEE
  3. ACH-DIST-ORDER
  4. ACH-DIST-NBR
KeyChange, SubsetWhere ACH-DIST-ORDER != ZeroesBN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
EADSET5
  1. COMPANY
  2. EMPLOYEE
  3. ACH-DIST-NBR
KeyChange, SubsetWhere OCCURANCES != ZeroesBN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
EADSET6
  1. COMPANY
  2. EMPLOYEE
  3. COUNTRY-CODE
  4. ACH-DIST-NBR
BN66.1, PR12.1, PR12.2, PR12.3, PR140, PR160, PR189, PR195 +13 more
EADSET7
  1. COMPANY
  2. EMPLOYEE
  3. PENS-SEQ-NBR
  4. ACH-DIST-NBR
KeyChange, SubsetWhere PENS-SEQ-NBR = ZeroesPR12.1
EADSET8
  1. COMPANY
  2. EMPLOYEE
  3. PENS-SEQ-NBR
  4. ACH-DIST-NBR
KeyChange, SubsetWhere PENS-SEQ-NBR != ZeroesBN66.1, PR140, PR189, PR195, PR229, PR29.1, PR529, PR560 +6 more
EADSET9
  1. OBJ-ID
SubsetWhere (OBJ-ID != Zeroes)HR94.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PRSYSTEMEMPLOYEEPREMPBANKHRHISTORYEMACHDEPST

One to one (4) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
EAD-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequired
EAD-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
PrempbankusPREMPBANKRequired
EAD-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)