EDTRDPTNRS – No description in the Lawson data dictionary

System
EDI (ED)
Prefix
TPT
Primary key
EDI-NBR, DATA-SOURCE
Fields
26
Updated by
1 program
Referenced by
0 programs

EDTRDPTNRS is a Lawson EDI table (prefix TPT); no description in the lawson data dictionary. It is indexed by EDI-NBR, DATA-SOURCE (TPTSET1); alternate indexes: TPTSET3. It is related 1:1 to EDCARRIER and 1:M to EDHISTRANS. It is updated by ED10.1. The table has 26 fields, 2 indexes and 2 documented relations.

About EDTRDPTNRS

No description in the Lawson data dictionary.

Fields (26)

Column = COBOL field name without the TPT- 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
#TPT-GROUP-ID
GROUP_ID		Alpha 15 (Lower Case)—ED10.1
#TPT-EDI-NBR PK
EDI_NBR		Alpha 15—ED10.1
#TPT-DIRECTION SET3
DIRECTION		Alpha 1—
  • I In
  • O Out
ED10.1
#TPT-PATH
PATH		Alpha 99 (Lower Case)—ED10.1
#TPT-EDICARRIER
EDICARRIER		Alpha 30 (Lower Case)—ED10.1
#TPT-MAP
MAP		Alpha 99 (Lower Case)—ED10.1
#TPT-TPID
TPID		Alpha 10—ED10.1
#TPT-ISA-ID-QUAL
ISA_ID_QUAL		Alpha 2 (Lower Case)—ED10.1
#TPT-ISA-ID SET3
ISA_ID		Alpha 15 (Lower Case)—ED10.1
#TPT-EXT-ISA-ID-QUA
EXT_ISA_ID_QUA		Alpha 2 (Lower Case)—ED10.1
#TPT-EXT-ISA-ID SET3
EXT_ISA_ID		Alpha 15 (Lower Case)—ED10.1
#TPT-ISA-CONTRL-NBR
ISA_CONTRL_NBR		Numeric 10—ED10.1
#TPT-GS-FUNC-ID
GS_FUNC_ID		Alpha 2 (Lower Case)—ED10.1
#TPT-GS-ID SET3
GS_ID		Alpha 15 (Lower Case)—ED10.1
#TPT-EXT-GS-ID SET3
EXT_GS_ID		Alpha 15 (Lower Case)—ED10.1
#TPT-GS-CONTRL-NBR
GS_CONTRL_NBR		Numeric 10—ED10.1
#TPT-STD-VERSION SET3
STD_VERSION		Alpha 12 (Lower Case)—ED10.1
#TPT-ACK-REQUEST
ACK_REQUEST		Alpha 1—
  • 0 None Requested
  • 1 Ack Requested
ED10.1
#TPT-TYPE
TYPE		Alpha 2—
  • P Production
  • T Test
ED10.1
#TPT-ELM-SEPARATOR
ELM_SEPARATOR		Alpha 1 (Lower Case)—ED10.1
#TPT-COMP-ELM-SEP
COMP_ELM_SEP		Alpha 1 (Lower Case)—ED10.1
#TPT-SEG-TERMINATOR
SEG_TERMINATOR		Alpha 2—ED10.1
#TPT-EDITRANS-TYPE SET3
EDITRANS_TYPE		Alpha 6—ED10.1
#TPT-DATE
DATE		Numeric 8 (yyyymmdd)—ED10.1
#TPT-EDTIME
EDTIME		Numeric 6 (hhmmss)—ED10.1
#TPT-DATA-SOURCE PK
DATA_SOURCE		Alpha 5—ED10.1

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
TPTSET1
  1. EDI-NBR
  2. DATA-SOURCE
PrimaryED10.1
TPTSET3
  1. DIRECTION
  2. ISA-ID
  3. EXT-ISA-ID
  4. GS-ID
  5. EXT-GS-ID
  6. STD-VERSION
  7. EDITRANS-TYPE
KeyChangeED10.1

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
EdcarrierEDCARRIERRequired
TPT-EDICARRIER→CAI-EDICARRIER

One to many (1) — child tables

RelationTableRulesConditionField map
EdhistransEDHISTRANS
TPT-EDI-NBR→HTR-EDI-NBR
—→HTR-TRANS-DATE
—→HTR-SEQ-NUMBER

Programs

Updated by (1)