Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            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
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
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
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
Select Value                                                     HS36.1

EPL-DESC             Alpha 30  (Lower Case)                      ES02.1  HS35.1
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