COCOMP – Demand Line Kit Components

System
Warehouse (WH)
Prefix
CKT
Primary key
COMPANY, SYSTEM-CD, DOC-NBR, LINE-NBR, COMPONENT-SEQ
Fields
12
Updated by
230 programs
Referenced by
2 programs

COCOMP is the Demand Line Kit Components table in Lawson Warehouse (prefix CKT). It is indexed by COMPANY, SYSTEM-CD, DOC-NBR, LINE-NBR, COMPONENT-SEQ (CKTSET1); alternate indexes: CKTSET2 and CKTSET4. It is related 1:1 to COLINE, COMPONENT, ICCOMPANY, ITEMLOC, ITEMMAST and OECOMPANY and 1:M to COMPONENT. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 222 more and referenced by RQD1.1 and WHD2.1. The table has 12 fields, 3 indexes and 9 documented relations.

About COCOMP

The Demand Line Kit Components file contains the kit components that make up a line on a document.

Fields (12)

Column = COBOL field name without the CKT- 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
#CKT-COMPANY PK
COMPANY
Numeric 4This field contains the company number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CKT-SYSTEM-CD PK
SYSTEM_CD
Alpha 2This field indicates on which Lawson system the document originated.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CKT-DOC-NBR PK
DOC_NBR
Alpha 10 (Right Justified)This field contains the document number of the document containing the component item.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CKT-DOC-NBR-NUM
DOC_NBR_NUM
Numeric 10This field contains the numeric value of the document number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CKT-LINE-NBR PK
LINE_NBR
Numeric 6This field displays the system assigned line number within the transaction number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CKT-COMPONENT-SEQ PK
COMPONENT_SEQ
Numeric 3This field contains the component sequence number for kit component items.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CKT-OPT-SEQ
OPT_SEQ
Numeric 3This field contains the option's sequence number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CKT-ITEM
ITEM
Alpha 32This field contains the item identifier.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CKT-OPTION-CD
OPTION_CD
Alpha 1This field contains the option code which determines the status of the option. Valid values are:
  • R Review Required.
  • N Option Does Not Exist.
  • E Option Exists.
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CKT-QUANTITY
QUANTITY
Signed 13.4This field contains the quantity per kit in stock unit of measure.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CKT-ITEM-16
ITEM_16
DerivedThis field contains the first 16 characters of the item's identifier. This information is used by inquiries and reports.—
#CKT-DISP-QTY
DISP_QTY
DerivedThis field contains the quantity needed for the line in stock quantity.—

Indexes (3)

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
CKTSET1
  1. COMPANY
  2. SYSTEM-CD
  3. DOC-NBR
  4. LINE-NBR
  5. COMPONENT-SEQ
PrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
CKTSET2
  1. COMPANY
  2. SYSTEM-CD
  3. DOC-NBR
  4. LINE-NBR
  5. COMPONENT-SEQ
SubsetWhere (OPTION-CD = "R")AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
CKTSET4
  1. COMPANY
  2. SYSTEM-CD
  3. DOC-NBR
  4. COMPONENT-SEQ
  5. LINE-NBR
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Relations

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

One to one (7) — lookups and parents

RelationTableRulesConditionField map
ColineCOLINERequired
CKT-COMPANY→COL-COMPANY
CKT-DOC-NBR-NUM→COL-ORDER-NBR
CKT-LINE-NBR→COL-LINE-NBR
ComponentCOMPONENTNot Required
ICC-ITEM-GROUP→COM-ITEM-GROUP
CKT-COMPANY→COM-COMPANY
COL-INV-LOC→COM-LOCATION
COL-ITEM→COM-KIT-ITEM
CKT-COMPONENT-SEQ→COM-SEQ
CKT-OPT-SEQ→COM-OPT-SEQ
IccompanyICCOMPANYRequired
CKT-COMPANY→ICC-COMPANY
ItemlocITEMLOCRequired
CKT-COMPANY→ITL-COMPANY
COL-INV-LOC→ITL-LOCATION
CKT-ITEM→ITL-ITEM
ItemmastITEMMASTRequired
ICC-ITEM-GROUP→ITE-ITEM-GROUP
CKT-ITEM→ITE-ITEM
KititemITEMMASTRequired
ICC-ITEM-GROUP→ITE-ITEM-GROUP
COL-ITEM→ITE-ITEM
OecompanyOECOMPANYRequired
CKT-COMPANY→OEC-COMPANY

One to many (2) — child tables

RelationTableRulesConditionField map
Options CompCOMPONENT
ICC-ITEM-GROUP→COM-ITEM-GROUP
CKT-COMPANY→COM-COMPANY
COL-INV-LOC→COM-LOCATION
COL-ITEM→COM-KIT-ITEM
CKT-COMPONENT-SEQ→COM-SEQ
—→COM-OPT-SEQ
Options GroupCOMPONENTValid When COM- != CKT-
ICC-ITEM-GROUP→COM-ITEM-GROUP
Zeroes→COM-COMPANY
Spaces→COM-LOCATION
ITE-ITEM→COM-KIT-ITEM
CKT-COMPONENT-SEQ→COM-SEQ
—→COM-OPT-SEQ

Programs

Updated by (230)

Referenced by (2)