KITITEM – Kit Item

System
Inventory Control (IC)
Prefix
KIT
Primary key
ITEM-GROUP, COMPANY, LOCATION, ITEM
Fields
31
Updated by
6 programs
Referenced by
270 programs

KITITEM is the Kit Item table in Lawson Inventory Control (prefix KIT). It is indexed by ITEM-GROUP, COMPANY, LOCATION, ITEM (KITSET1); alternate indexes: KITSET2. It is related 1:1 to ICCOMPANY, ICLOCATION, ITEMGROUP, ITEMMAST and KITBOD and 1:M to COMPONENT, ICFGBRDN, ICFGBYPROD, KTINSTRUCT and WORDER. It is updated by IC60.1, IC60.2, IC60.3, IC62.1, IC62.2 and IC62.4 and referenced by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 262 more. The table has 31 fields, 2 indexes and 10 documented relations.

About KITITEM

The Kit Item file contains the valid kit or parent items for a make-to-order or finished good kit.

Fields (31)

Column = COBOL field name without the KIT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
KIT-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.1, IC62.1, IC62.2, IC62.4
KIT-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.IC262, IC60.1, IC62.1, IC62.2, IC62.4
KIT-LOCATION PK
LOCATION		Alpha 5This field contains a valid stocking location within the company inventory.IC262, IC60.1, IC62.1, IC62.2, IC62.4
KIT-ITEM PK
ITEM		Alpha 32This field contains the item identifier.IC262, IC60.1, IC62.1, IC62.2, IC62.4
KIT-ORDER-SIZE
ORDER_SIZE		Numeric 8This field contains the standard order size for the kit. The component quantity specifies the number of required kit components needed for each kit. This field is for reference purposes only.IC60.1
KIT-NOTES
NOTES		Alpha 20 (Lower Case)This field contains notes about the kit. This information is for reference purposes only.IC60.1
KIT-PROCEDURE-CD
PROCEDURE_CD		Alpha 7 (Lower Case)This field contains the procedure code for the kit. This information is for reference purposes only.IC60.1, IC62.1, IC62.4
KIT-MAKE-CD
MAKE_CD		Alpha 1This field contains the code that specifies whether a kit is a make-to-order or a finished good kit.
  • O Make to Order
  • S Make to Stock
IC60.1, IC62.1, IC62.4
KIT-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1This field contains the status to control the use of the kit.
  • A Active
  • I Inactive
IC60.1, IC62.1, IC62.4
KIT-SEQ
SEQ		Numeric 3This field contains the last sequence number of the last component line. This field is used when adding new component lines.IC60.1, IC62.1, IC62.4
KIT-INST-LINE
INST_LINE		Numeric 3This field contains the number of the last instruction line. This field is used when adding new instruction lines.IC60.3, IC62.1, IC62.4
KIT-CTG-PROD-FLAG
CTG_PROD_FLAG		Alpha 1This field contains the contiguous production flag, used if production spans multiple days. Set its value to Yes if production must occur on consecutive days - there cannot be any non-work days between the start and end production dates.
  • Y Yes
  • N No
IC62.1, IC62.4
KIT-COST-TOL-PCT
COST_TOL_PCT		Percent 5.3 (Percent)This field contains the cost tolerance percent for a finished good.IC62.1, IC62.4
KIT-ZERO-COST-FL
ZERO_COST_FL		Alpha 1The zero cost tolerance flag is used to indicate if zero tolerance is allowed for finished good cost tolerance checking. If no tolerance checking is needed, this field's value is No.
  • Y Yes
  • N No
IC62.1, IC62.4
KIT-QTY-TOL-PCT
QTY_TOL_PCT		Percent 5.3 (Percent)This is the quantity tolerance percent for a finished good.IC62.1, IC62.4
KIT-ZERO-QTY-FL
ZERO_QTY_FL		Alpha 1The zero quantity tolerance flag is used to indicate if zero tolerance is allowed for finished good quantity tolerance checking. If no tolerance checking is desired, this field's value is No.
  • Y Yes
  • N No
IC62.1, IC62.4
KIT-LAST-BRDN-SEQ
LAST_BRDN_SEQ		Numeric 3This field contains the last burden sequence.IC62.1, IC62.4
KIT-LAST-BYPRO-SEQ
LAST_BYPRO_SEQ		Numeric 3This field contains the last byproduct sequence.IC62.2
KIT-CAPACITY
CAPACITY		Numeric 8Capacity describes the maximum quantity of a finished good that can be produced for a work order.IC62.1, IC62.4
KIT-FGV-ACCT-UNIT
FGV_ACCT_UNIT		Alpha 15The finished good variance accounting unit is used to post variances in finished good cost when there is a difference between the cost from an original work order and the cost returned from inventory for a reversed work order.IC60.1, IC62.1, IC62.4
KIT-FGV-ACCOUNT
FGV_ACCOUNT		Numeric 6The finished good variance account is used to post variances in finished good cost when there is a difference between the cost from an original work order and the cost returned from inventory for a reversed work order.IC60.1, IC62.1, IC62.4
KIT-FGV-SUB-ACCT
FGV_SUB_ACCT		Numeric 4The finished good variance subaccount is used to post variances in finished good cost when there is a difference between the cost from an original work order and the cost returned from inventory for a reversed work order.IC60.1, IC62.1, IC62.4
KIT-SCHED-INCR
SCHED_INCR		Numeric 2Schedule increment is used with schedule frequency to indicate the length of a scheduling period for work orders. The increment is the number of days, weeks or months in a period.IC62.1, IC62.4
KIT-SCHED-FREQ
SCHED_FREQ		Alpha 1Schedule frequency is used with schedule increment to indicate the length of a scheduling period for work orders. The frequency defines whether the period is in days, weeks or months.
  • D Daily
  • W Weekly
  • M Monthly
IC62.1, IC62.4
KIT-PC-ACCT-UNIT
PC_ACCT_UNIT		Alpha 15—IC62.1, IC62.4
KIT-PC-ACCOUNT
PC_ACCOUNT		Numeric 6—IC62.1, IC62.4
KIT-PC-SUB-ACCT
PC_SUB_ACCT		Numeric 4—IC62.1, IC62.4
KIT-BA-ACCT-UNIT
BA_ACCT_UNIT		Alpha 15—IC62.1, IC62.4
KIT-BA-ACCOUNT
BA_ACCOUNT		Numeric 6—IC62.1, IC62.4
KIT-BA-SUB-ACCT
BA_SUB_ACCT		Numeric 4—IC62.1, IC62.4
KIT-ITEM-CODE-USED
ITEM_CODE_USED		Derived——

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
KITSET1ITEM-GROUP, COMPANY, LOCATION, ITEMPrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
KITSET2MAKE-CD, ITEM-GROUP, COMPANY, LOCATION, ITEMKeyChangeIC260, IC262, IC60.1, IC62.1, IC62.2, IC62.4, RQD1.1

Relations

One to one (5) — lookups and parents

RelationTableRulesConditionField map
IccompanyICCOMPANYRequiredWhen KIT-COMPANY != ZeroesKIT-COMPANY → ICC-COMPANY
IclocationICLOCATIONRequiredWhen KIT-LOCATION != SpacesKIT-COMPANY → ICL-COMPANY, KIT-LOCATION → ICL-LOCATION
ItemgroupITEMGROUPRequiredKIT-ITEM-GROUP → ITG-ITEM-GROUP
ItemmastITEMMASTRequiredKIT-ITEM-GROUP → ITE-ITEM-GROUP, KIT-ITEM → ITE-ITEM
KitbodKITBODNot Required, Delete CascadesKIT-ITEM-GROUP → IBF-ITEM-GROUP, KIT-COMPANY → IBF-COMPANY, KIT-LOCATION → IBF-LOCATION, KIT-ITEM → IBF-ITEM

One to many (5) — child tables

RelationTableRulesConditionField map
ComponentCOMPONENTDelete CascadesKIT-ITEM-GROUP → COM-ITEM-GROUP, KIT-COMPANY → COM-COMPANY, KIT-LOCATION → COM-LOCATION, KIT-ITEM → COM-KIT-ITEM, → COM-SEQ, → COM-OPT-SEQ
FgburdenICFGBRDNKIT-COMPANY → IBR-COMPANY, KIT-LOCATION → IBR-LOCATION, KIT-ITEM → IBR-ITEM, → IBR-SEQ
FgbyprodICFGBYPRODDelete RestrictedKIT-COMPANY → ICP-COMPANY, KIT-LOCATION → ICP-LOCATION, KIT-ITEM → ICP-FG-ITEM, → ICP-SEQ
KtinstructKTINSTRUCTDelete CascadesKIT-ITEM-GROUP → KTI-ITEM-GROUP, KIT-COMPANY → KTI-COMPANY, KIT-LOCATION → KTI-LOCATION, KIT-ITEM → KTI-KIT-ITEM, Zeroes → KTI-SEQ, → KTI-INST-LINE
WorderWORDERKIT-COMPANY → WOR-COMPANY, KIT-LOCATION → WOR-LOCATION, KIT-ITEM → WOR-ITEM, → WOR-WORK-ORDER, → WOR-WORK-ORDER-SUF

Programs

Updated by (6)

Referenced by (270)