COMPONENT – User Field

System
Inventory Control (IC)
Prefix
COM
Primary key
ITEM-GROUP, COMPANY, LOCATION, KIT-ITEM, SEQ, OPT-SEQ
Fields
23
Updated by
6 programs
Referenced by
264 programs

COMPONENT is the User Field table in Lawson Inventory Control (prefix COM). It is indexed by ITEM-GROUP, COMPANY, LOCATION, KIT-ITEM, SEQ, OPT-SEQ (COMSET1); alternate indexes: COMSET2 and COMSET3. It is related 1:1 to KITITEM, ITEMGROUP, ITEMLOC and ITEMMAST and 1:M to KTINSTRUCT. It is updated by IC60.1, IC60.2, IC60.3, IC61.1, IC62.1 and IC62.4 and referenced by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 256 more. The table has 23 fields, 3 indexes and 7 documented relations.

About COMPONENT

The Components of a Kit file contains the component items that make up a kit item (finished good or make-to-order kit). Also, it contains the optional items associated with a make-to-order component.

Fields (23)

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

Field / columnTypeDescription & valuesUpdated by
COM-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, IC60.2, IC62.1, IC62.4, IC68.1
COM-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.1, IC60.2, IC62.1, IC62.4, IC68.1
COM-LOCATION PK
LOCATION
Alpha 5This field contains a valid stock location within the company inventory.IC60.1, IC60.2, IC62.1, IC62.4, IC68.1
COM-KIT-ITEM PK
KIT_ITEM
Alpha 32This field contains the parent item, which is made up of component items. The kit item can be either a finished good or make-to-order kit.IC60.1, IC60.2, IC62.1, IC62.4, IC68.1
COM-SEQ PK
SEQ
Numeric 3This field contains the number assigned to each component item.IC60.1, IC60.2, IC62.1, IC62.4
COM-OPT-SEQ PK
OPT_SEQ
Numeric 3This field contains a number assigned to each optional item for a single component. This field holds the last options sequence number used for this line.IC60.2
COM-ITEM
ITEM
Alpha 32This field contains the item's identifier.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
COM-QUANTITY
QUANTITY
Signed 13.4This field contains the number of component items needed to make one kit item.IC60.1, IC60.2, IC62.1, IC62.4
COM-START-DATE
START_DATE
Numeric 8 (yyyymmdd)This field contains the first date that this component is a valid component item for the kit.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
COM-STOP-DATE
STOP_DATE
Numeric 8 (yyyymmdd)This field contains the last date that this component is a valid component item for the kit.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
COM-REQUIRED-FL
REQUIRED_FL
Alpha 1This field indicates whether the component is required for the kit.
  • N No
  • Y Yes
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
COM-INST-LINE
INST_LINE
Numeric 3This field contains the last line number used for kit instructions for this line.IC60.3
COM-LAST-OPT-SEQ
LAST_OPT_SEQ
Numeric 3This field contains the last number used for sequencing optional components for this line.IC60.2
COM-QTY-TOL-PCT
QTY_TOL_PCT
Percent 5.3 (Percent)This is the quantity tolerance percent for a component of a finished good kit item.IC62.1, IC62.4
COM-ZERO-QTY-FL
ZERO_QTY_FL
Alpha 1The zero quantity tolerance flag is used to indicate if zero tolerance is allowed for component quantity tolerance checking. If no tolerance checking is requested, this field's value is No.
  • Y Yes
  • N No
IC62.1, IC62.4
COM-WST-ACCT-UNIT
WST_ACCT_UNIT
Alpha 15The waste account unit is used to default to components added to a work order.IC60.1, IC62.1, IC62.4
COM-WST-ACCOUNT
WST_ACCOUNT
Numeric 6The waste account is used to default to components added to a work order.IC60.1, IC62.1, IC62.4
COM-WST-SUB-ACCT
WST_SUB_ACCT
Numeric 4The waste subaccount is used to default to components added to a work order.IC60.1, IC62.1, IC62.4
COM-COMPONENT-TYPE
COMPONENT_TYPE
Alpha 1The component type for a work order specifies one of three kinds of components (normal, packaging, and offsite). A normal component requires a non-zero quantity when set up on the finished good template. A packaging item is a type of component that can have a zero quantity when set up on the finished good template. An offsite component is one that is not an item within Inventory Control, but is a component of a finished good that will be supplied by an offsite location that does part of the production process for a work order.
  • C Component
  • P Packaging
  • O Offsite
IC60.1, IC62.1, IC62.4
COM-INV-LOCATION
INV_LOCATION
Alpha 5This field contains a valid stocking location within the company inventory.IC60.1, IC62.1, IC62.4
COM-ME-ACCT-UNIT
ME_ACCT_UNIT
Alpha 15IC62.1, IC62.4
COM-ME-ACCOUNT
ME_ACCOUNT
Numeric 6IC62.1, IC62.4
COM-ME-SUB-ACCT
ME_SUB_ACCT
Numeric 4IC62.1, IC62.4

Indexes (3)

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

IndexKeysFlagsConditionUsed in
COMSET1ITEM-GROUP, COMPANY, LOCATION, KIT-ITEM, SEQ, OPT-SEQPrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
COMSET2ITEM-GROUP, ITEM, KIT-ITEM, COMPANY, LOCATION, SEQ, OPT-SEQKeyChangeIC10.2, IC11.1, IC12.1, IC330, IC60.1, IC61.1, IC62.1, IC62.4 +1 more
COMSET3ITEM-GROUP, COMPANY, LOCATION, KIT-ITEM, ITEM, SEQ, OPT-SEQKeyChangeIC60.2, IC61.1, IC62.1, IC62.4, IC68.1, IC68.2

Relations

One to one (6) — lookups and parents

RelationTableRulesConditionField map
Comp Is KitKITITEMNot RequiredCOM-ITEM-GROUPKIT-ITEM-GROUP, COM-COMPANYKIT-COMPANY, COM-LOCATIONKIT-LOCATION, COM-ITEMKIT-ITEM
ItemgroupITEMGROUPRequiredCOM-ITEM-GROUPITG-ITEM-GROUP
ItemlocITEMLOCRequiredCOM-COMPANYITL-COMPANY, COM-LOCATIONITL-LOCATION, COM-ITEMITL-ITEM
ItemmastITEMMASTRequiredCOM-ITEM-GROUPITE-ITEM-GROUP, COM-ITEMITE-ITEM
Kit ItemmastITEMMASTRequiredCOM-ITEM-GROUPITE-ITEM-GROUP, COM-KIT-ITEMITE-ITEM
KititemKITITEMRequiredCOM-ITEM-GROUPKIT-ITEM-GROUP, COM-COMPANYKIT-COMPANY, COM-LOCATIONKIT-LOCATION, COM-KIT-ITEMKIT-ITEM

One to many (1) — child tables

RelationTableRulesConditionField map
KtinstructKTINSTRUCTDelete CascadesCOM-ITEM-GROUPKTI-ITEM-GROUP, COM-COMPANYKTI-COMPANY, COM-LOCATIONKTI-LOCATION, COM-KIT-ITEMKTI-KIT-ITEM, COM-SEQKTI-SEQ, KTI-INST-LINE

Programs

Updated by (6)

Referenced by (264)