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

BN150     BN305     ET530     ETI2.1    HR00.1    HR01.1
HR02.1    HR511     LP130     PA100     PA102     PA13.1
PA13.2    PA513     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    PR35.9    PR36.1    PR45.1
PR529     PR530     PR560     PR80.1    PR82.1    UK102
UK560     TA147     PA182     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 Hr

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: Pay 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: Ded 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
Element: Seq Nbr       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
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: Acct Unit     Contains 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: Sub Acct      Contains the general ledger subaccount
                       to which the amount is posted.

DIP-DIST-COMPANY       Numeric 4                                 PR23.1  PR23.3
Element: Company       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-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: Sub Acct      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: 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: Acct 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.

                       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.

DIP-CREATE-DATE        Numeric 8  (yyyymmdd)                     PR23.1  PR23.3
Element: Date Stamp    This field contains the server date
                       (month, date, and year) of the last
                       change to this record.

DIP-CREATE-TIME        Numeric 6  (hhmmss)                       PR23.1  PR23.3
Element: Time Stamp    Contains the server time (hour, minute,
                       and second) when the record was last
                       changed.

DIP-CREATE-USER-ID     Alpha 10  (Lower Case)                    PR23.1  PR23.3
Element: User Id       Contains the user ID of the person who
                       last changed this record.

DIP-DATE-STAMP         Numeric 8  (yyyymmdd)                     PR23.1  PR23.3
Element: Date Stamp    This field contains the server date
                       (month, date, and year) of the last
                       change to this record.

DIP-TIME-STAMP         Numeric 6  (hhmmss)                       PR23.1  PR23.3
Element: Time Stamp    Contains the server time (hour, minute,
                       and second) when the record was last
                       changed.

DIP-USER-ID            Alpha 10  (Lower Case)                    PR23.1  PR23.3
Element: User Id       Contains the user ID of the person who
                       last changed this record.

                         EMDISTMAST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

DIPSET1   COMPANY                                                BN150   BN305
          EMPLOYEE                                               ET530   ETI2.1
          POSITION                                               HR00.1  HR01.1
          PAY-CODE                                               HR02.1  HR11.1
          DED-CODE                                               HR11.2  HR511
          SEQ-NBR                                                LP130   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA302
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR128
                                                                 PR13.1  PR13.5
                                                                 ...

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

DIPSET3   COMPANY       Subset                                   ET530   PA182
          POSITION      Where (EMPLOYEE = Zeroes )               PR195   PR197
          PAY-CODE*                                              PR82.1  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
                            When (DIP-EMPLOYEE != Zeroes )

                            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