C3DTLRET – No description in the Lawson data dictionary

System
C3 (C3)
Prefix
C3D
Primary key
COMPANY, TRANS-TYPE, RECORD-TYPE, VENDOR, INVOICE, PO-NUMBER, PO-LINE-NUMBER
Fields
38
Updated by
2 programs
Referenced by
2 programs

C3DTLRET is a Lawson C3 table (prefix C3D); no description in the lawson data dictionary. It is indexed by COMPANY, TRANS-TYPE, RECORD-TYPE, VENDOR, INVOICE, PO-NUMBER, PO-LINE-NUMBER (C3DSET1). It is related 1:1 to MAINVDTL. It is updated by PO30.1 and WH32.1 and referenced by API1.1 and POI3.1. The table has 38 fields, 1 index and 1 documented relation.

About C3DTLRET

No description in the Lawson data dictionary.

Fields (38)

Column = COBOL field name without the C3D- 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
#C3D-COMPANY PK
COMPANY		Numeric 4—PO30.1, WH32.1
#C3D-TRANS-TYPE PK
TRANS_TYPE		Alpha 2—PO30.1, WH32.1
#C3D-RECORD-TYPE PK
RECORD_TYPE		Alpha 2—PO30.1, WH32.1
#C3D-VENDOR PK
VENDOR		Alpha 9 (Right Justified)—PO30.1, WH32.1
#C3D-INVOICE PK
INVOICE		Alpha 22—PO30.1, WH32.1
#C3D-SUFFIX
SUFFIX		Numeric 3—PO30.1, WH32.1
#C3D-PO-NUMBER PK
PO_NUMBER		Alpha 14 (Right Justified)—PO30.1, WH32.1
#C3D-PO-RELEASE
PO_RELEASE		Numeric 4—PO30.1, WH32.1
#C3D-PO-CODE
PO_CODE		Alpha 4—PO30.1, WH32.1
#C3D-PO-LINE-NUMBER PK
PO_LINE_NUMBER		Numeric 6—PO30.1, WH32.1
#C3D-SEQ-NBR
SEQ_NBR		Numeric 4—PO30.1, WH32.1
#C3D-REC-NUMBER
REC_NUMBER		Numeric 10—PO30.1, WH32.1
#C3D-ORDER-NUMBER
ORDER_NUMBER		Numeric 8—PO30.1, WH32.1
#C3D-ORDER-LINE-NBR
ORDER_LINE_NBR		Numeric 6—PO30.1, WH32.1
#C3D-LINE-NBR
LINE_NBR		Numeric 6—PO30.1, WH32.1
#C3D-FISC-REF-LINE
FISC_REF_LINE		Numeric 6—PO30.1, WH32.1
#C3D-FISC-RF-LN-SEQ
FISC_RF_LN_SEQ		Numeric 4—PO30.1, WH32.1
#C3D-ITEM
ITEM		Alpha 32—PO30.1, WH32.1
#C3D-ITEM-DESC
ITEM_DESC		Alpha 30—PO30.1, WH32.1
#C3D-MATCH-QTY
MATCH_QTY		Signed 13.4—PO30.1, WH32.1
#C3D-MATCH-UNIT-CST
MATCH_UNIT_CST		Signed 18.5—PO30.1, WH32.1
#C3D-VPRI-UOM
VPRI_UOM		Alpha 4—PO30.1, WH32.1
#C3D-TOT-DIST-AMT
TOT_DIST_AMT		Signed 18.2—PO30.1, WH32.1
#C3D-WH-REC-NUMBER
WH_REC_NUMBER		Numeric 10—PO30.1, WH32.1
#C3D-WH-REC-LINE-NB
WH_REC_LINE_NB		Numeric 6—PO30.1, WH32.1
#C3D-MULT-PO-FL
MULT_PO_FL		Alpha 1—PO30.1, WH32.1
#C3D-GLBL-LINE-TYPE
GLBL_LINE_TYPE		Alpha 15—PO30.1, WH32.1
#C3D-FREIGHT-TOT
FREIGHT_TOT		Signed 18.2—PO30.1, WH32.1
#C3D-INSRNC-TOT
INSRNC_TOT		Signed 18.2—PO30.1, WH32.1
#C3D-CSTMS-TOT
CSTMS_TOT		Signed 18.2—PO30.1, WH32.1
#C3D-OTHER-AOC-TOT
OTHER_AOC_TOT		Signed 18.2—PO30.1, WH32.1
#C3D-BOD-ACCT-ENT
BOD_ACCT_ENT		Alpha 22—PO30.1, WH32.1
#C3D-BOD-LOCATION
BOD_LOCATION		Alpha 22—PO30.1, WH32.1
#C3D-BOD-DOC-ID
BOD_DOC_ID		Alpha 100—PO30.1, WH32.1
#C3D-FREIGHT-AOC
FREIGHT_AOC		Alpha 2—PO30.1, WH32.1
#C3D-INSRNC-AOC
INSRNC_AOC		Alpha 2—PO30.1, WH32.1
#C3D-CSTMS-AOC
CSTMS_AOC		Alpha 2—PO30.1, WH32.1
#C3D-OTHER-AOC
OTHER_AOC		Alpha 2—PO30.1, WH32.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
C3DSET1
  1. COMPANY
  2. TRANS-TYPE
  3. RECORD-TYPE
  4. VENDOR
  5. INVOICE
  6. PO-NUMBER
  7. PO-LINE-NUMBER
PrimaryAPI1.1, PO30.1, POI3.1, WH32.1

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
MainvdtlMAINVDTLNot Required
C3D-COMPANY→MAD-COMPANY
C3D-VENDOR→MAD-VENDOR
C3D-INVOICE→MAD-INVOICE
C3D-SUFFIX→MAD-SUFFIX
C3D-PO-NUMBER→MAD-PO-NUMBER
C3D-PO-RELEASE→MAD-PO-RELEASE
C3D-PO-CODE→MAD-PO-CODE
C3D-PO-LINE-NUMBER→MAD-LINE-NBR
C3D-SEQ-NBR→MAD-SEQ-NBR

Programs

Updated by (2)

Referenced by (2)