KTINSTRUCT – Kit Instructions

System
Inventory Control (IC)
Prefix
KTI
Primary key
ITEM-GROUP, COMPANY, LOCATION, KIT-ITEM, SEQ, INST-LINE
Fields
7
Updated by
5 programs
Referenced by
2 programs

KTINSTRUCT is the Kit Instructions table in Lawson Inventory Control (prefix KTI). It is indexed by ITEM-GROUP, COMPANY, LOCATION, KIT-ITEM, SEQ, INST-LINE (KTISET1). It is related 1:1 to COMPONENT, ITEMMAST and KITITEM. It is updated by IC60.1, IC60.3, IC61.1, IC62.1 and IC62.4 and referenced by IC260 and WH130. The table has 7 fields, 1 index and 3 documented relations.

About KTINSTRUCT

The Kit Instructions file contains the assembly instructions for make-to-order and finished good kits. They can be added to any component item in the kit.

Fields (7)

Column = COBOL field name without the KTI- 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
#KTI-ITEM-GROUP PK
ITEM_GROUP		Alpha 5This field contains the identifier for a group of items that can be shared by one or more companies.IC60.3
#KTI-COMPANY PK
COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.IC60.3
#KTI-LOCATION PK
LOCATION		Alpha 5This field contains a valid stocking location within the company inventory.IC60.3
#KTI-KIT-ITEM PK
KIT_ITEM		Alpha 32This field contains the item identifier.IC60.1, IC60.3
#KTI-SEQ PK
SEQ		Numeric 3This field contains the sequence number of the component item line.IC60.1, IC60.3
#KTI-INST-LINE PK
INST_LINE		Numeric 3This field contains the number of the instruction line.IC60.3
#KTI-INSTRUCTION
INSTRUCTION		Alpha 40 (Lower Case)This field contains the one line of instruction text.IC60.3

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
KTISET1
  1. ITEM-GROUP
  2. COMPANY
  3. LOCATION
  4. KIT-ITEM
  5. SEQ
  6. INST-LINE
PrimaryIC260, IC60.1, IC60.3, IC61.1, IC62.1, IC62.4, WH130

Relations

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

One to one (3) — lookups and parents

RelationTableRulesConditionField map
ComponentCOMPONENTRequiredWhen KTI-SEQ != Zeroes
KTI-ITEM-GROUP→COM-ITEM-GROUP
KTI-COMPANY→COM-COMPANY
KTI-LOCATION→COM-LOCATION
KTI-KIT-ITEM→COM-KIT-ITEM
KTI-SEQ→COM-SEQ
Zeroes→COM-OPT-SEQ
ItemmastITEMMASTRequired
KTI-ITEM-GROUP→ITE-ITEM-GROUP
KTI-KIT-ITEM→ITE-ITEM
KititemKITITEMRequiredWhen KTI-SEQ = Zeroes
KTI-ITEM-GROUP→KIT-ITEM-GROUP
KTI-COMPANY→KIT-COMPANY
KTI-LOCATION→KIT-LOCATION
KTI-KIT-ITEM→KIT-ITEM

Programs

Updated by (5)

Referenced by (2)