EDTEMPLATE – No description in the Lawson data dictionary

System
EDI (ED)
Prefix
EP1
Primary key
TLID
Fields
9
Updated by
1 program
Referenced by
2 programs

EDTEMPLATE is a Lawson EDI table (prefix EP1); no description in the lawson data dictionary. It is indexed by TLID (EP1SET1); alternate indexes: EP1SET2. It is updated by ED45.1 and referenced by ED43.1 and ED51.1. The table has 9 fields, 2 indexes and 0 documented relations.

About EDTEMPLATE

No description in the Lawson data dictionary.

Fields (9)

Column = COBOL field name without the EP1- 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
#EP1-TLID PK
TLID		Alpha 9 (Lower Case)—ED45.1
#EP1-TLNAME SET2
TLNAME		Alpha 40 (Lower Case)—ED45.1
#EP1-CLIENT
CLIENT		Alpha 40 (Lower Case)—ED45.1
#EP1-PRODLINE
PRODLINE		Alpha 14—ED45.1
#EP1-VENDOR
VENDOR		Alpha 9 (Right Justified)—ED45.1
#EP1-PURCH-FR-LOC
PURCH_FR_LOC		Alpha 4—ED45.1
#EP1-ACCT-UNIT
ACCT_UNIT		Alpha 15——
#EP1-ACCOUNT
ACCOUNT		Numeric 6——
#EP1-SUB-ACCT
SUB_ACCT		Numeric 4——

Indexes (2)

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
EP1SET1
  1. TLID
PrimaryED43.1, ED45.1, ED51.1
EP1SET2
  1. TLNAME
KeyChangeED43.1, ED45.1

Programs

Updated by (1)

Referenced by (2)