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.

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

IndexKeysFlagsConditionUsed in
KTISET1ITEM-GROUP, COMPANY, LOCATION, KIT-ITEM, SEQ, INST-LINEPrimaryIC260, IC60.1, IC60.3, IC61.1, IC62.1, IC62.4, WH130

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
ComponentCOMPONENTRequiredWhen KTI-SEQ != ZeroesKTI-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
ItemmastITEMMASTRequiredKTI-ITEM-GROUP → ITE-ITEM-GROUP, KTI-KIT-ITEM → ITE-ITEM
KititemKITITEMRequiredWhen KTI-SEQ = ZeroesKTI-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)