ETEMPVEN – No description in the Lawson data dictionary

System
ET (ET)
Prefix
ETV
Primary key
EMPVEN-COMPANY, EMPVEN-EMP, EMPVEN-APCMPNY, EMPVEN-VENDOR
Fields
7
Updated by
0 programs
Referenced by
0 programs

ETEMPVEN is a Lawson ET table (prefix ETV); no description in the lawson data dictionary. It is indexed by EMPVEN-COMPANY, EMPVEN-EMP, EMPVEN-APCMPNY, EMPVEN-VENDOR (ETVSET1); alternate indexes: ETVSET2 and ETVSET3. The table has 7 fields, 3 indexes and 0 documented relations.

About ETEMPVEN

No description in the Lawson data dictionary.

Fields (7)

Column = COBOL field name without the ETV- 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 / columnTypeDescription & valuesUpdated by
#ETV-EMPVEN-COMPANY PK
EMPVEN_COMPANY		Numeric 4Identifies 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.—
#ETV-EMPVEN-EMP PK
EMPVEN_EMP		Numeric 9Contains 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.—
#ETV-EMPVEN-APCMPNY PK
EMPVEN_APCMPNY		Numeric 4Identifies 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.—
#ETV-EMPVEN-VENDOR PK
EMPVEN_VENDOR		Alpha 10——
#ETV-EMPVEN-PROCLVL
EMPVEN_PROCLVL		Alpha 5This field contains the process level, which is the reporting hierarchy below company.—
#ETV-EMPVEN-PAYVEND
EMPVEN_PAYVEND		Alpha 10——
#ETV-EMPVEN-VEN-GRP SET3
EMPVEN_VEN_GRP		Alpha 4A vendor group represents a group of vendors that can be shared by one or more companies.—

Indexes (3)

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.

IndexKeysFlagsConditionUsed in
ETVSET1
  1. EMPVEN-COMPANY
  2. EMPVEN-EMP
  3. EMPVEN-APCMPNY
  4. EMPVEN-VENDOR
Primary—
ETVSET2
  1. EMPVEN-APCMPNY
  2. EMPVEN-VENDOR
  3. EMPVEN-COMPANY
  4. EMPVEN-EMP
KeyChangeAP170
ETVSET3
  1. EMPVEN-VEN-GRP
  2. EMPVEN-VENDOR
  3. EMPVEN-APCMPNY
  4. EMPVEN-COMPANY
  5. EMPVEN-EMP
—

Programs

No Lawson programs are documented as updating or referencing this table.