EMDISTMAST – Emp Acct Distribution Override

System
Payroll (PR)
Prefix
DIP
Primary key
COMPANY, EMPLOYEE, POSITION, PAY-CODE, DED-CODE, SEQ-NBR
Fields
26
Updated by
14 programs
Referenced by
68 programs

EMDISTMAST is the Emp Acct Distribution Override table in Lawson Payroll (prefix DIP). It is indexed by COMPANY, EMPLOYEE, POSITION, PAY-CODE, DED-CODE, SEQ-NBR (DIPSET1); alternate indexes: DIPSET2 and DIPSET3. It is related 1:1 to ACACCTCAT, ACACTIVITY, PRSYSTEM, DEDCODE, DEPTCODE, GLSYSTEM, EMPLOYEE, GLMASTER and 2 more. It is updated by HR00.1, HR01.1, HR02.1, HR11.1, LT101, LT111, PA02.1, PA115 and 6 more and referenced by BN150, BN305, EXI2.1, EXI4.1, HR28.1, HR511, LP130, PA100 and 60 more. The table has 26 fields, 3 indexes and 13 documented relations.

About EMDISTMAST

This file contains information for overriding, by percent, the normal distribution of wages and company-paid deduction expenses by pay code, company-paid deduction, or employee. The system uses the records to determine the scheme for creating General Ledger Transaction File and Employee Payment Distribution file records when you close the payroll cycle. Records can include pay codes or deductions. If you do not enter either a pay code or a deduction, the override distribution is referred to as an employee override distribution and the distribution of wages and company-paid deduction expenses follows the same pattern. PR23.1 (Payroll Distribution) is the primary program that updates this file. PR199 (Payroll Close) and PR150 (Distribution Edit) are the primary programs that reference this file for calculating distributions.

Fields (26)

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

Field / columnTypeDescription & valuesUpdated by
DIP-COMPANY PK
COMPANY		Numeric 4—PR23.1, PR23.3
DIP-EMPLOYEE PK
EMPLOYEE		Numeric 9Valid in the Employee file.PR23.1, PR23.3
DIP-PAY-CODE PK
PAY_CODE		Alpha 4Contains the pay code. A pay code is a user-defined code that identifies a kind of pay.PR23.1, PR23.3
DIP-DED-CODE PK
DED_CODE		Alpha 4Valid in the Deduction file as a company-paid deduction (deduction Adjust
  • Pay field C).
PR23.1, PR23.3
DIP-SEQ-NBR PK
SEQ_NBR		Numeric 4Contains the distribution sequence number. The value in this field is automatically sequenced based on the last employee distribution sequence number.PR23.1, PR23.3
DIP-PROCESS-LEVEL
PROCESS_LEVEL		Alpha 5Contains the process level. The system uses this field when creating Employee Payment Distribution file records. The system does not use this field when creating General Ledger Transaction File records.PR23.1, PR23.3
DIP-DEPARTMENT
DEPARTMENT		Alpha 5Contains the department. The system uses this field when creating Employee Payment Distribution file records. The system does not use this field when creating General Ledger Transaction File records.PR23.1, PR23.3
DIP-DST-ACCT-UNIT
DST_ACCT_UNIT		Alpha 15Contains the accounting unit to which the amount is posted. The accounting unit in this field together with the account and subaccount must be valid in the General Ledger Account file.PR23.1, PR23.3
DIP-DST-ACCOUNT
DST_ACCOUNT		Numeric 6Contains the general ledger account to which the amount is posted.PR23.1, PR23.3
DIP-DST-SUB-ACCT
DST_SUB_ACCT		Numeric 4Contains the general ledger subaccount to which the amount is posted.PR23.1, PR23.3
DIP-DIST-COMPANY
DIST_COMPANY		Numeric 4Identifies 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.PR23.1, PR23.3
DIP-PERCENT
PERCENT		Signed 7.3Contains the distribution percent.PR23.1, PR23.3
DIP-JOB-CODE
JOB_CODE		Alpha 9Contains the job code the system uses when creating the Employee Payment Distribution file record. The system does not use this field when creating GL Transactions file records.PR23.1, PR23.3
DIP-OT-ACCOUNT
OT_ACCOUNT		Numeric 6Contains the accounting unit for the premium expense distribution override.PR23.1, PR23.3
DIP-OT-SUB-ACCT
OT_SUB_ACCT		Numeric 4Contains the subaccount for the premium expense distribution override.PR23.1, PR23.3
DIP-SH-ACCOUNT
SH_ACCOUNT		Numeric 6Contains the account number for the shift expense distribution override.PR23.1, PR23.3
DIP-SH-SUB-ACCT
SH_SUB_ACCT		Numeric 4Contains the subaccount number for the shift expense distribution override.PR23.1, PR23.3
DIP-ACTIVITY
ACTIVITY		Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.PR23.1, PR23.3
DIP-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thruPR23.1, PR23.3
DIP-POSITION PK
POSITION		Alpha 12Contains the user-defined code that represents a position in the company.PR23.1, PR23.3
DIP-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.PR23.1, PR23.3
DIP-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.PR23.1, PR23.3
DIP-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)Contains the user ID of the person who last changed this record.PR23.1, PR23.3
DIP-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.PR23.1, PR23.3
DIP-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.PR23.1, PR23.3
DIP-USER-ID
USER_ID		Alpha 10 (Lower Case)Contains the user ID of the person who last changed this record.PR23.1, PR23.3

Indexes (3)

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

IndexKeysFlagsConditionUsed in
DIPSET1COMPANY, EMPLOYEE, POSITION, PAY-CODE, DED-CODE, SEQ-NBRPrimaryBN150, BN305, HR00.1, HR01.1, HR02.1, HR11.1, HR11.2, HR11.4 +22 more (list truncated in source)
DIPSET2COMPANY, EMPLOYEE, PAY-CODE*, DED-CODE*, SEQ-NBRSubsetWhere (EMPLOYEE != Zeroes)PA182, PR195, PR197, PR582, PR82.1, PR85.1
DIPSET3COMPANY, POSITION, PAY-CODE*, DED-CODE*, SEQ-NBRSubsetWhere (EMPLOYEE = Zeroes)PA182, PR195, PR197, PR323, PR582, PR82.1, PR85.1

Relations

One to one (13) — lookups and parents

RelationTableRulesConditionField map
Acct CategoryACACCTCATRequiredWhen DIP-ACCT-CATEGORY != SpacesDIP-ACCT-CATEGORY → AAX-ACCT-CATEGORY
ActivityACACTIVITYRequiredWhen DIP-ACTIVITY != SpacesDIP-ACTIVITY → ACV-ACTIVITY
CompanyPRSYSTEMRequiredDIP-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
Deduction CodeDEDCODERequiredWhen DIP-DED-CODE != SpacesDIP-COMPANY → DDC-COMPANY, DIP-DED-CODE → DDC-DED-CODE
DepartmentDEPTCODERequiredWhen DIP-DEPARTMENT != SpacesDIP-COMPANY → DPT-COMPANY, DIP-PROCESS-LEVEL → DPT-PROCESS-LEVEL, DIP-DEPARTMENT → DPT-DEPARTMENT
Dist CompanyGLSYSTEMRequiredWhen DIP-DIST-COMPANY != ZeroesDIP-DIST-COMPANY → GLS-COMPANY
EmployeeEMPLOYEERequiredWhen (DIP-EMPLOYEE != Zeroes)DIP-COMPANY → EMP-COMPANY, DIP-EMPLOYEE → EMP-EMPLOYEE
Gl Acct NbrGLMASTERRequiredDIP-DIST-COMPANY → GLM-COMPANY, DIP-DST-ACCT-UNIT → GLM-ACCT-UNIT, DIP-DST-ACCOUNT → GLM-ACCOUNT, DIP-DST-SUB-ACCT → GLM-SUB-ACCOUNT
Job CodeJOBCODERequiredWhen DIP-JOB-CODE != SpacesDIP-COMPANY → JBC-COMPANY, DIP-JOB-CODE → JBC-JOB-CODE
Ot AccountGLMASTERRequiredWhen DIP-OT-ACCOUNT != ZeroesDIP-DIST-COMPANY → GLM-COMPANY, DIP-DST-ACCT-UNIT → GLM-ACCT-UNIT, DIP-OT-ACCOUNT → GLM-ACCOUNT, DIP-OT-SUB-ACCT → GLM-SUB-ACCOUNT
Pay CodePRPAYCODERequiredWhen DIP-PAY-CODE != SpacesDIP-COMPANY → PCD-COMPANY, DIP-PAY-CODE → PCD-PAY-CODE, Spaces → PCD-PROCESS-LEVEL, Spaces → PCD-JOB-CODE
Process LevelPRSYSTEMRequiredWhen DIP-PROCESS-LEVEL != SpacesDIP-COMPANY → PRS-COMPANY, DIP-PROCESS-LEVEL → PRS-PROCESS-LEVEL
Sh AccountGLMASTERRequiredWhen DIP-SH-ACCOUNT != ZeroesDIP-DIST-COMPANY → GLM-COMPANY, DIP-DST-ACCT-UNIT → GLM-ACCT-UNIT, DIP-SH-ACCOUNT → GLM-ACCOUNT, DIP-SH-SUB-ACCT → GLM-SUB-ACCOUNT

Programs

Updated by (14)

Referenced by (68)