EMDISTMAST FILE
Emp Acct Distribution Override
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.
REFERENCED BY
AC541 AC542 BN150 HR511 HR650 PR128
PR13.1 PR13.5 PR13.6 PR13.8 PR131 PR132
PR134 PR136 PR195 PR223 PR32.2 PR33.2
PR33.3 PR35.1 PR35.2 PR35.3 PR35.4 PR35.5
PR35.6 PR35.8 PR36.1 PR530 PR82.1 UK102
UK120 PR197 PR85.1
UPDATED BY
PR23.1 PR23.3 PA302 PA502
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DIP-COMPANY Numeric 4 PR23.1 PR23.3
Company The company number represents an
established company and is entered on
all function codes.
DIP-EMPLOYEE Numeric 9 PR23.1 PR23.3
Employee Valid in the Employee file.
DIP-PAY-CODE Alpha 4 PR23.1 PR23.3
Payment Code Contains the pay code. A pay code is a
user-defined code that identifies a kind
of pay.
DIP-DED-CODE Alpha 4 PR23.1 PR23.3
Deduction Code Valid in the Deduction file as a
company-paid deduction (deduction Adjust
Pay field = C).
DIP-SEQ-NBR Numeric 4 PR23.1 PR23.3
Sequence Number Contains the distribution sequence
number. The value in this field is
automatically sequenced based on the
last employee distribution sequence
number.
DIP-PROCESS-LEVEL Alpha 5 PR23.1 PR23.3
Process Level Contains 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.
DIP-DEPARTMENT Alpha 5 PR23.1 PR23.3
Department Contains 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.
DIP-DST-ACCT-UNIT Alpha 15 PR23.1 PR23.3
Distribution Contains the accounting unit to which
Accounting Unit 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.
DIP-DST-ACCOUNT Numeric 6 PR23.1 PR23.3
Distribution Contains the general ledger account to
Account Number which the amount is posted.
DIP-DST-SUB-ACCT Numeric 4 PR23.1 PR23.3
Distribution Contains the general ledger subaccount
Subaccount Number to which the amount is posted.
DIP-DIST-COMPANY Numeric 4 PR23.1 PR23.3
Distribution Company The company number used for posting the
transaction. A valid intercompany
relationship must be defined in the
Lawson General Ledger system.
DIP-PERCENT Signed 7.3 PR23.1 PR23.3
Percent Contains the distribution percent.
DIP-JOB-CODE Alpha 9 PR23.1 PR23.3
Job Code Contains 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.
DIP-OT-ACCOUNT Numeric 6 PR23.1 PR23.3
Ot Account Contains the accounting unit for the
premium expense distribution override.
DIP-OT-SUB-ACCT Numeric 4 PR23.1 PR23.3
Ot Sub Acct Contains the subaccount for the premium
expense distribution override.
DIP-SH-ACCOUNT Numeric 6 PR23.1 PR23.3
Sh Account Contains the account number for the
shift expense distribution override.
DIP-SH-SUB-ACCT Numeric 4 PR23.1 PR23.3
Sh Sub Acct Contains the subaccount number for the
shift expense distribution override.
DIP-ACTIVITY Alpha 15 PR23.1 PR23.3
Activity Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
DIP-ACCT-CATEGORY Alpha 5 PR23.1 PR23.3
Account Category Account 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.
DIP-POSITION Alpha 12 PR23.1 PR23.3
Position Contains the user-defined code that
represents a position in the company.
EMDISTMAST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DIPSET1 COMPANY AC541 AC542
EMPLOYEE BN150 HR511
POSITION HR650 PA302
PAY-CODE PA502 PR128
DED-CODE PR13.1 PR13.5
SEQ-NBR PR13.6 PR13.8
PR131 PR132
PR134 PR136
PR195 PR223
PR23.1 PR23.2
PR23.3 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
...
DIPSET2 COMPANY Subset PR195 PR197
EMPLOYEE Where (EMPLOYEE != Zeroes ) PR82.1 PR85.1
PAY-CODE*
DED-CODE*
SEQ-NBR
DIPSET3 COMPANY Subset PR195 PR197
POSITION Where (EMPLOYEE = Zeroes ) PR82.1 PR85.1
PAY-CODE*
DED-CODE*
SEQ-NBR
EMDISTMAST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acct Category ACACCTCAT Required
When DIP-ACCT-CATEGORY != Spaces
DIP-ACCT-CATEGORY -> AAX-ACCT-CATEGORY
Activity ACACTIVITY Required
When DIP-ACTIVITY != Spaces
DIP-ACTIVITY -> ACV-ACTIVITY
Company PRSYSTEM Required
DIP-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Deduction Code DEDCODE Required
When DIP-DED-CODE != Spaces
DIP-COMPANY -> DDC-COMPANY
DIP-DED-CODE -> DDC-DED-CODE
Department DEPTCODE Required
When DIP-DEPARTMENT != Spaces
DIP-COMPANY -> DPT-COMPANY
DIP-PROCESS-LEVEL -> DPT-PROCESS-LEVEL
DIP-DEPARTMENT -> DPT-DEPARTMENT
Dist Company GLSYSTEM Required
When DIP-DIST-COMPANY != Zeroes
DIP-DIST-COMPANY -> GLS-COMPANY
Employee EMPLOYEE Required
DIP-COMPANY -> EMP-COMPANY
DIP-EMPLOYEE -> EMP-EMPLOYEE
Gl Acct Nbr GLMASTER Required
DIP-DIST-COMPANY -> GLM-COMPANY
DIP-DST-ACCT-UNIT -> GLM-ACCT-UNIT
DIP-DST-ACCOUNT -> GLM-ACCOUNT
DIP-DST-SUB-ACCT -> GLM-SUB-ACCOUNT
Job Code JOBCODE Required
When DIP-JOB-CODE != Spaces
DIP-COMPANY -> JBC-COMPANY
DIP-JOB-CODE -> JBC-JOB-CODE
Ot Account GLMASTER Required
When DIP-OT-ACCOUNT != Zeroes
DIP-DIST-COMPANY -> GLM-COMPANY
DIP-DST-ACCT-UNIT -> GLM-ACCT-UNIT
DIP-OT-ACCOUNT -> GLM-ACCOUNT
DIP-OT-SUB-ACCT -> GLM-SUB-ACCOUNT
Pay Code PRPAYCODE Required
When DIP-PAY-CODE != Spaces
DIP-COMPANY -> PCD-COMPANY
DIP-PAY-CODE -> PCD-PAY-CODE
Spaces -> PCD-PROCESS-LEVEL
Spaces -> PCD-JOB-CODE
Process Level PRSYSTEM Required
When DIP-PROCESS-LEVEL != Spaces
DIP-COMPANY -> PRS-COMPANY
DIP-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
Sh Account GLMASTER Required
When DIP-SH-ACCOUNT != Zeroes
DIP-DIST-COMPANY -> GLM-COMPANY
DIP-DST-ACCT-UNIT -> GLM-ACCT-UNIT
DIP-SH-ACCOUNT -> GLM-ACCOUNT
DIP-SH-SUB-ACCT -> GLM-SUB-ACCOUNT
|
