HRINTRFACE – No description in the Lawson data dictionary

System
Human Resources (HR)
Prefix
LTI
Primary key
COMPANY, TOPIC, FLD-NBR
Fields
4
Updated by
1 program
Referenced by
5 programs

HRINTRFACE is a Lawson Human Resources table (prefix LTI); no description in the lawson data dictionary. It is indexed by COMPANY, TOPIC, FLD-NBR (LTISET1). It is related 1:1 to PRSYSTEM and HRINTFDICT. It is updated by LT10.1 and referenced by LT101, LT11.1, LT111, LT210 and LT213. The table has 4 fields, 1 index and 2 documented relations.

About HRINTRFACE

No description in the Lawson data dictionary.

Fields (4)

Column = COBOL field name without the LTI- 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
#LTI-COMPANY PK
COMPANY		Numeric 4—LT10.1
#LTI-FLD-NBR PK
FLD_NBR		Numeric 4—LT10.1
#LTI-TOPIC PK
TOPIC		Alpha 3—
  • EMP Employee
  • JOB Job Code
  • POS Position
LT10.1
#LTI-INT-FLAG
INT_FLAG		Alpha 1—
  • X Interfaced
LT10.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.

IndexKeysFlagsConditionUsed in
LTISET1
  1. COMPANY
  2. TOPIC
  3. FLD-NBR
PrimaryLT10.1, LT101, LT11.1, LT111, LT210, LT213

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PRSYSTEMHRINTFDICTHRINTRFACE

One to one (2) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMNot Required
LTI-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
HrintfdictHRINTFDICTNot Required
LTI-FLD-NBR→LTF-FLD-NBR

Programs

Updated by (1)

Referenced by (5)