|
|
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
BN150 PR128 PR131 PR132 PR134 PR136
PR137 PR140 PR150 PR195 PR199 PR223
PR32.1 PR32.2 PR33.1 PR33.2 PR33.3 PR35.1
PR35.2 PR35.3 PR35.4 PR35.5 PR35.6 PR35.8
PR36.1 PR37.1 PR45.1 PR530 PR80.1 PR82.1
PR85.1 UK102 UK330 UK120
UPDATED BY
PR23.1 PR23.3 HR11.1 PA02.1 PA115 PA302
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. Activities and
cost object activities are used
synonymously in the Activity Management
system. Direct costs are posted to
activities, and indirect costs are
allocated to activities based on
activity drivers.
Activities are grouped or organized by
activity levels. There are two kinds of
activities: "posting allowed" and
"summary only." Use posting level
activities to budget and maintain all
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
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 BN150 HR11.1
EMPLOYEE PA02.1 PA115
POSITION PA302 PR128
PAY-CODE PR131 PR132
DED-CODE PR134 PR136
SEQ-NBR PR137 PR140
PR150 PR195
PR199 PR223
PR23.1 PR23.2
PR23.3 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
...
DIPSET2 COMPANY Subset PR150 PR195
EMPLOYEE Where (EMPLOYEE != Zeroes ) PR199 PR82.1
PAY-CODE* PR85.1
DED-CODE*
SEQ-NBR
DIPSET3 COMPANY Subset PR150 PR195
POSITION Where (EMPLOYEE = Zeroes ) PR199 PR82.1
PAY-CODE* PR85.1
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
|