|
|
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 HR00.1 HR01.1 HR02.1 HR511 PA100
PA102 PA52.1 PA52.3 PA52.4 PA52.5 PBIP.1
PR110 PR113 PR120 PR128 PR13.1 PR13.5
PR13.6 PR13.8 PR130 PR131 PR132 PR134
PR136 PR197 PR223 PR29.1 PR32.2 PR33.2
PR33.3 PR35.1 PR35.2 PR35.3 PR35.4 PR35.5
PR35.6 PR35.8 PR35.9 PR36.1 PR45.1 PR529
PR530 PR560 PR82.1 UK102 TA147 TP135
PA182 PR85.1
UPDATED BY
PR23.1 PR23.3 HR11.1 PA02.1 PA115 PA302
PA502
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DIP-COMPANY Numeric 4 PR23.1 PR23.3
Element: Company Hr Identifies 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.
DIP-EMPLOYEE Numeric 9 PR23.1 PR23.3
Element: Employee Valid in the Employee file.
DIP-PAY-CODE Alpha 4 PR23.1 PR23.3
Element: 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
Element: Deduction CodeValid in the Deduction file as a
company-paid deduction (deduction Adjust
Pay field = C).
DIP-SEQ-NBR Numeric 4 PR23.1 PR23.3
Element: Sequence NumbeContains 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
Element: Process Lev HrContains 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
Element: 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
Element: Accounting UniContains 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.
DIP-DST-ACCOUNT Numeric 6 PR23.1 PR23.3
Element: Account Contains the general ledger account to
which the amount is posted.
DIP-DST-SUB-ACCT Numeric 4 PR23.1 PR23.3
Element: Subaccount Contains the general ledger subaccount
to which the amount is posted.
DIP-DIST-COMPANY Numeric 4 PR23.1 PR23.3
Element: 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
Element: Percent Contains the distribution percent.
DIP-JOB-CODE Alpha 9 PR23.1 PR23.3
Element: 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
Element: Account Contains the accounting unit for the
premium expense distribution override.
DIP-OT-SUB-ACCT Numeric 4 PR23.1 PR23.3
Element: Subaccount Contains the subaccount for the premium
expense distribution override.
DIP-SH-ACCOUNT Numeric 6 PR23.1 PR23.3
Element: Account Contains the account number for the
shift expense distribution override.
DIP-SH-SUB-ACCT Numeric 4 PR23.1 PR23.3
Element: Subaccount Contains the subaccount number for the
shift expense distribution override.
DIP-ACTIVITY Alpha 15 PR23.1 PR23.3
Element: 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
Element: Account CategoAccount 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 thru
DIP-POSITION Alpha 12 PR23.1 PR23.3
Element: 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 HR00.1
EMPLOYEE HR01.1 HR02.1
POSITION HR11.1 HR11.2
PAY-CODE HR511 PA02.1
DED-CODE PA100 PA102
SEQ-NBR PA115 PA302
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PBIP.1
PR110 PR113
PR120 PR128
PR13.1 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
...
DIPSET2 COMPANY Subset PA182 PR197
EMPLOYEE Where (EMPLOYEE != Zeroes ) PR82.1 PR85.1
PAY-CODE*
DED-CODE*
SEQ-NBR
DIPSET3 COMPANY Subset PA182 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
|
