EMPPICKLST – No description in the Lawson data dictionary
- System
- Human Resources (HR)
- Prefix
EPL- Primary key
COMPANY,EMPLOYEE,TYPE,SELECT-VALUE- Fields
- 5
- Updated by
- 5 programs
- Referenced by
- 0 programs
EMPPICKLST is a Lawson Human Resources table (prefix EPL); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, TYPE, SELECT-VALUE (EPLSET1). It is related 1:1 to EMPLOYEE and PRSYSTEM. It is updated by ES02.1, HR11.1, HS35.1, HS36.1 and PA115. The table has 5 fields, 1 index and 2 documented relations.
About EMPPICKLST
No description in the Lawson data dictionary.
Fields (5)
Column = COBOL field name without the EPL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#EPL-COMPANY PKCOMPANY | Numeric 4 | — | ES02.1, HS35.1, HS36.1 |
#EPL-EMPLOYEE PKEMPLOYEE | Numeric 9 | 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. | ES02.1, HS35.1, HS36.1 |
#EPL-TYPE PKTYPE | Alpha 2 | 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. | ES02.1, HS35.1, HS36.1 |
#EPL-SELECT-VALUE PKSELECT_VALUE | Alpha 30 | — | ES02.1, HS35.1, HS36.1 |
#EPL-DESCDESC | Alpha 30 (Lower Case) | This field displays the description. | ES02.1, HS35.1, HS36.1 |
Indexes (1)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
EPLSET1 |
| Primary | ES02.1, HR11.1, PA115, HS35.1, HS36.1 |