Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

EMDISTMAST


                            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     PA100
PA102     PA52.1    PA52.3    PA52.4    PA52.5    PR110
PR113     PR120     PR128     PR13.1    PR13.5    PR13.6
PR13.8    PR130     PR131     PR132     PR134     PR136
PR189     PR195     PR223     PR29.1    PR32.2    PR33.2
PR33.3    PR35.1    PR35.2    PR35.3    PR35.4    PR35.5
PR35.6    PR35.8    PR36.1    PR45.1    PR529     PR530
PR560     PR80.1    PR82.1    UK102     UK560     TA147
UK120     PR197     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       The company number represents an
                       established company and is entered on
                       all function codes.

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 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
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

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: Ot Account    Contains the accounting unit for the
                       premium expense distribution override.

DIP-OT-SUB-ACCT        Numeric 4                                 PR23.1  PR23.3
Element: Ot Sub Acct   Contains the subaccount for the premium
                       expense distribution override.

DIP-SH-ACCOUNT         Numeric 6                                 PR23.1  PR23.3
Element: Sh Account    Contains the account number for the
                       shift expense distribution override.

DIP-SH-SUB-ACCT        Numeric 4                                 PR23.1  PR23.3
Element: Sh Sub Acct   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.

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                                                AC541   AC542
          EMPLOYEE                                               BN150   HR11.1
          POSITION                                               HR11.2  HR511
          PAY-CODE                                               HR650   PA02.1
          DED-CODE                                               PA100   PA102
          SEQ-NBR                                                PA115   PA302
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR128   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PR130
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 ...

DIPSET2   COMPANY       Subset                                   AC542   PR195
          EMPLOYEE      Where (EMPLOYEE != Zeroes )              PR197   PR82.1
          PAY-CODE*                                              PR85.1
          DED-CODE*
          SEQ-NBR

DIPSET3   COMPANY       Subset                                   AC542   PR195
          POSITION      Where (EMPLOYEE = Zeroes )               PR197   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