Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

YEALLOC


                              YEALLOC FILE

                        Year End Tip Allocation

Contains the year-to-date direct and indirect reported tips, tips shortfall,
and shortfall allocation. The information in this file is used to print the
allocated shortfall amount on employee W-2 forms. You can print the
information in this file using TP110 (Year End Shortfall Closing)
or TP210 (Year End Shortfall Report).

UPDATED BY

TP100     TP105

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

YEA-COMPANY            Numeric 4                                 TP100
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.

YEA-PAYROLL-YEAR       Numeric 4                                 TP100
Element: Current PayrolContains the payroll year in which the
                       allocation was taken.

YEA-EMPLOYEE           Numeric 9                                 TP100
Element: Employee      Contains the employee number. Each
                       person employed by the company is
                       assigned a unique number. The system
                       uses the employee number to correlate
                       all information related to that person.

YEA-HM-PROC-LEV        Alpha 5                                   TP100
Element: Process Lev HrContains the process level in which the
                       tips were reported.

YEA-HM-DEPT            Alpha 5                                   TP100
Element: Department    Contains the department in which the
                       tips were reported.

YEA-YTD-RPT-TIPS       Signed 13.2                               TP100
Year-to-date           Contains the year-to-date reported tips.
Reported Tips

YEA-YTD-SHORTFALL      Signed 13.2                               TP100
Year-to-date Tips      Contains the year-to-date tips
Shortfall              shortfall.

YEA-YTD-SF-ALLOC       Signed 13.2                               TP100
Year-to-date           Contains the year-to-date shortfall
Shortfall Alloc        allocation.

YEA-YTD-IND-TIPS       Signed 13.2                               TP100
Element: Ytd Ind Tips  Contains the year-to-date indirect tips.

YEA-CURRENCY-CODE      Alpha 5                                   TP100
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

YEA-CURR-ND            Numeric 1                                 TP100
Account Currency       Represents the number of decimals
Code                   defined for the currency of the object.

                         YEALLOC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

YEASET1   COMPANY                                                TP100   TP105
          PAYROLL-YEAR
          EMPLOYEE
          HM-PROC-LEV
          HM-DEPT

                         YEALLOC FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            YEA-COMPANY         -> PRS-COMPANY
                            Spaces              -> PRS-PROCESS-LEVEL

Department     DEPTCODE     Required
                            When YEA-HM-DEPT != Spaces

                            YEA-COMPANY         -> DPT-COMPANY
                            YEA-HM-PROC-LEV     -> DPT-PROCESS-LEVEL
                            YEA-HM-DEPT         -> DPT-DEPARTMENT

Employee       EMPLOYEE     Required

                            YEA-COMPANY         -> EMP-COMPANY
                            YEA-EMPLOYEE        -> EMP-EMPLOYEE

Process Level  PRSYSTEM     Required

                            YEA-COMPANY         -> PRS-COMPANY
                            YEA-HM-PROC-LEV     -> PRS-PROCESS-LEVEL

                         YEALLOC FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Emp Summ       EMPSUMM      Delete Restricted

                            YEA-COMPANY         -> ESM-COMPANY
                            YEA-PAYROLL-YEAR    -> ESM-PAYROLL-YEAR
                            YEA-EMPLOYEE        -> ESM-EMPLOYEE
                            YEA-HM-PROC-LEV     -> ESM-PROCESS-LEVEL
                            YEA-HM-DEPT         -> ESM-DEPARTMENT
                                                   ESM-SHIFT