Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

EMPPICKLST


                            EMPPICKLST FILE

UPDATED BY

ES02.1    HS35.1    HS36.1    HR11.1    PA115

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

EPL-COMPANY            Numeric 4                                 ES02.1  HS35.1
Element: Company       The company number represents an          HS36.1
                       established company and is entered on
                       all function codes.

EPL-EMPLOYEE           Numeric 9                                 ES02.1  HS35.1
Element: Employee      Contains the employee number. Each        HS36.1
                       person employed by the company is
                       assigned a unique number. The system
                       uses the employee number to correlate
                       all of the information related to that
                       person.

EPL-TYPE               Alpha 2                                   ES02.1  HS35.1
Element: Type          This identifies whether this record is    HS36.1
                       created because of a picking
                       transaction, or because of a return.
                       Valid values are:
                           "IS" = Picking transaction.
                           "RR" = Return.
                        ~$1 VENDOR
                       The vendor's identification code.


EPL-SELECT-VALUE       Alpha 30                                  ES02.1  HS35.1
Element: Select Value                                            HS36.1

EPL-DESC               Alpha 30  (Lower Case)                    ES02.1  HS35.1
Element: Description                                             HS36.1

                         EMPPICKLST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

EPLSET1   COMPANY                                                ES02.1  HR11.1
          EMPLOYEE                                               PA115   HS35.1
          TYPE                                                   HS36.1
          SELECT-VALUE

EPLSET2   COMPANY
          TYPE
          EMPLOYEE
          SELECT-VALUE

                         EMPPICKLST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Employee       EMPLOYEE     Required

                            EPL-COMPANY     -> EMP-COMPANY  (EMPSET1)
                            EPL-EMPLOYEE    -> EMP-EMPLOYEE

Prsystem       PRSYSTEM     Required

                            EPL-COMPANY     -> PRS-COMPANY
                            Spaces          -> PRS-PROCESS-LEVEL