EMPPICKLST FILE

                           Employee Picklist

UPDATED BY

ES02.1    HS35.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

EPL-EMPLOYEE         Numeric 9                                   ES02.1  HS35.1
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 of the information related to that
                     person.

EPL-TYPE             Alpha 2                                     ES02.1  HS35.1
Type                 This identifies whether this record is
                     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

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

                         EMPPICKLST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

EPLSET1   COMPANY                                                ES02.1  HS35.1
          EMPLOYEE
          TYPE
          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