EDHISTRANS – No description in the Lawson data dictionary

System
EDI (ED)
Prefix
HTR
Primary key
EDI-NBR, TRANS-DATE, SEQ-NUMBER
Fields
18
Updated by
1 program
Referenced by
2 programs

EDHISTRANS is a Lawson EDI table (prefix HTR); no description in the lawson data dictionary. It is indexed by EDI-NBR, TRANS-DATE, SEQ-NUMBER (HTRSET1); alternate indexes: HTRSET2, HTRSET3 and HTRSET4. It is related 1:1 to EDCARRIER. It is updated by ED310 and referenced by ED05.1 and ED90.1. The table has 18 fields, 4 indexes and 1 documented relation.

About EDHISTRANS

No description in the Lawson data dictionary.

Fields (18)

Column = COBOL field name without the HTR- 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
#HTR-EDI-NBR PK
EDI_NBR		Alpha 15——
#HTR-EDICARRIER
EDICARRIER		Alpha 30 (Lower Case)——
#HTR-TRANS-DATE PK
TRANS_DATE		Numeric 8 (yyyymmdd)——
#HTR-SEQ-NUMBER PK
SEQ_NUMBER		Numeric 6——
#HTR-EDITRANS-TYPE
EDITRANS_TYPE		Alpha 6——
#HTR-DIRECTION
DIRECTION		Alpha 1—
  • I Inbound
  • O Outbound
—
#HTR-APP-VALUE SET4
APP_VALUE		Alpha 60 (Lower Case)——
#HTR-ISA-CONTRL-NBR
ISA_CONTRL_NBR		Numeric 10——
#HTR-GS-CONTRL-NBR
GS_CONTRL_NBR		Numeric 10——
#HTR-ST-CONTRL-NBR
ST_CONTRL_NBR		Numeric 10——
#HTR-PATH
PATH		Alpha 99 (Lower Case)——
#HTR-ACK-EXPECTED
ACK_EXPECTED		Alpha 1—
  • N No
  • Y Yes
—
#HTR-ACK-DATE
ACK_DATE		Numeric 8 (yyyymmdd)——
#HTR-HST-STATUS
HST_STATUS		Alpha 1—
  • W Waiting
  • A Accepted
  • R Rejected
—
#HTR-DATE
DATE		Numeric 8 (yyyymmdd)——
#HTR-EDTIME
EDTIME		Numeric 6 (hhmmss)——
#HTR-COMMSTAT
COMMSTAT		Alpha 40——
#HTR-CONNECTION-ID
CONNECTION_ID		Alpha 14 (Lower Case)——

Indexes (4)

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
HTRSET1
  1. EDI-NBR
  2. TRANS-DATE
  3. SEQ-NUMBER
PrimaryED05.1, ED90.1
HTRSET2
  1. TRANS-DATE ↓
  2. EDI-NBR
  3. SEQ-NUMBER
KeyChange, DuplicatesED310
HTRSET3
  1. TRANS-DATE
  2. EDI-NBR
  3. SEQ-NUMBER
ED90.1
HTRSET4
  1. APP-VALUE
  2. EDI-NBR
  3. TRANS-DATE
  4. SEQ-NUMBER
ED90.1

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
EdcarrierEDCARRIERRequired
HTR-EDICARRIER→CAI-EDICARRIER

Programs

Updated by (1)

Referenced by (2)