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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CKTSET1COMPANY, SYSTEM-CD, DOC-NBR, LINE-NBR, COMPONENT-SEQPrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
CKTSET2COMPANY, SYSTEM-CD, DOC-NBR, LINE-NBR, COMPONENT-SEQSubsetWhere (OPTION-CD = "R")AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
CKTSET4COMPANY, SYSTEM-CD, DOC-NBR, COMPONENT-SEQ, LINE-NBRAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Relations

One to one (7) — lookups and parents

RelationTableRulesConditionField map
ColineCOLINERequiredCKT-COMPANYCOL-COMPANY, CKT-DOC-NBR-NUMCOL-ORDER-NBR, CKT-LINE-NBRCOL-LINE-NBR
ComponentCOMPONENTNot RequiredICC-ITEM-GROUPCOM-ITEM-GROUP, CKT-COMPANYCOM-COMPANY, COL-INV-LOCCOM-LOCATION, COL-ITEMCOM-KIT-ITEM, CKT-COMPONENT-SEQCOM-SEQ, CKT-OPT-SEQCOM-OPT-SEQ
IccompanyICCOMPANYRequiredCKT-COMPANYICC-COMPANY
ItemlocITEMLOCRequiredCKT-COMPANYITL-COMPANY, COL-INV-LOCITL-LOCATION, CKT-ITEMITL-ITEM
ItemmastITEMMASTRequiredICC-ITEM-GROUPITE-ITEM-GROUP, CKT-ITEMITE-ITEM
KititemITEMMASTRequiredICC-ITEM-GROUPITE-ITEM-GROUP, COL-ITEMITE-ITEM
OecompanyOECOMPANYRequiredCKT-COMPANYOEC-COMPANY

One to many (2) — child tables

RelationTableRulesConditionField map
Options CompCOMPONENTICC-ITEM-GROUPCOM-ITEM-GROUP, CKT-COMPANYCOM-COMPANY, COL-INV-LOCCOM-LOCATION, COL-ITEMCOM-KIT-ITEM, CKT-COMPONENT-SEQCOM-SEQ, COM-OPT-SEQ
Options GroupCOMPONENTValid When COM- != CKT-ICC-ITEM-GROUPCOM-ITEM-GROUP, ZeroesCOM-COMPANY, SpacesCOM-LOCATION, ITE-ITEMCOM-KIT-ITEM, CKT-COMPONENT-SEQCOM-SEQ, COM-OPT-SEQ

Programs

Updated by (230)

Referenced by (2)