COMPONENT

Components of a Kit

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.
UPDATED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 API1.1 API2.1
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 CX506 CXCP.1 DR100 IC10.2
IC11.1 IC12.1 IC140 IC141 IC142 IC260
IC262 IC330 IC60.1 IC60.2 IC60.3 IC61.1
IC62.1 IC62.4 IC65.1 IC66.1 IC67.1 IC68.1
IC68.2 IC83.1 MA180 MA41.1 MA41.2 MA41.4
MA41.7 MA42.2 MA43.2 MA43.7 MA44.1 MA44.2
MA530 MA531 MA60.2 MA60.3 MA60.5 MA61.1
MA66.2 MA67.2 MA67.3 MA68.2 MA68.3 MA68.5
MA70.1 MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2
PD130 PD20.1 PD20.2 PD20.3 PO100 PO101
PO122 PO131 PO136 PO150 PO190 PO20.1
PO20.6 PO20.9 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO22.3 PO22.4 PO23.1 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO27.2 PO28.2
PO29.1 PO30.1 PO30.2 PO30.3 PO30.4 PO300
PO31.1 PO31.2 PO32.2 PO32.4 PO33.1 PO34.1
PO35.1 PO36.1 PO36.2 PO38.1 PO39.1 PO39.2
PO44.1 PO50.1 PO52.1 PO520 PO536 PO54.5
POCP.1 POI3.1 POID.1 POII.1 POIJ.1 RQ10.1
RQ10.2 RQ10.3 RQ10.4 RQ11.1 RQ12.1 RQ13.1
RQ13.2 RQ35.1 RQ500 RQIC.1 RQID.1 RQIF.1
RQIG.1 RQIJ.1 WH110 WH130 WH132 WH190
WH20.1 WH20.2 WH20.7 WH22.1 WH222 WH25.1
WH25.2 WH30.1 WH30.2 WH30.3 WH30.4 WH31.1
WH31.2 WH31.3 WH31.4 WH32.1 WH32.2 WH32.3
WH32.4 WH32.5 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830
ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
COM-ITEM-GROUP
Element: Item Group
Alpha 5
This 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
Element: Company
Numeric 4
Identifies 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
Element: Location
Alpha 5
This field contains a valid stock location within the company inventory.
IC60.1 IC60.2
IC62.1 IC62.4
IC68.1
COM-KIT-ITEM
Element: Item
Alpha 32
This 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
Element: Seq
Numeric 3
This field contains the number assigned to each component item.
IC60.1 IC60.2
IC62.1 IC62.4
COM-OPT-SEQ
Element: Seq
Numeric 3
This 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
Element: Item
Alpha 32
This field contains the item's identifier.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC141 IC142
IC60.1 IC60.2
IC61.1 IC62.1
IC62.4 IC66.1
IC83.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
MA68.2 MA68.3
COM-QUANTITY
Element: Quantity
Signed 13.4
This field contains the number of component items needed to make one kit item.
IC60.1 IC60.2
IC62.1 IC62.4
COM-START-DATE
Element: 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC141 IC142
IC60.1 IC60.2
IC62.1 IC62.4
IC66.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
MA44.1 MA44.2
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
COM-STOP-DATE
Element: 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC141 IC142
IC60.1 IC60.2
IC62.1 IC62.4
IC66.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
MA44.1 MA44.2
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
COM-REQUIRED-FL
Element: All Flag
Alpha 1
This 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC141 IC142
IC60.1 IC60.2
IC62.1 IC62.4
IC66.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
MA44.1 MA44.2
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
COM-INST-LINE
Element: Inst Line
Numeric 3
This field contains the last line number used for kit instructions for this line.
IC60.3
COM-LAST-OPT-SEQ
Element: Seq
Numeric 3
This field contains the last number used for sequencing optional components for this line.
IC60.2
COM-QTY-TOL-PCT
Element: 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
Element: All Flag
Alpha 1
The 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
Element: Acct Unit
Alpha 15
The waste account unit is used to default to components added to a work order.
IC60.1 IC62.1
IC62.4
COM-WST-ACCOUNT
Element: Account
Numeric 6
The waste account is used to default to components added to a work order.
IC60.1 IC62.1
IC62.4
COM-WST-SUB-ACCT
Element: Sub Acct
Numeric 4
The waste subaccount is used to default to components added to a work order.
IC60.1 IC62.1
IC62.4
COM-COMPONENT-TYPE
Element: Component Type
Alpha 1
The 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
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
IC60.1 IC62.1
IC62.4
COM-ME-ACCT-UNIT
Element: Me Acct Unit
Alpha 15
IC62.1 IC62.4
COM-ME-ACCOUNT
Element: Me Account
Numeric 6
IC62.1 IC62.4
COM-ME-SUB-ACCT
Element: Me Sub Acct
Numeric 4
IC62.1 IC62.4


COMPONENT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
COMSET1 ITEM-GROUP
COMPANY
LOCATION
KIT-ITEM
SEQ
OPT-SEQ
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
COMSET2 ITEM-GROUP
ITEM
KIT-ITEM
COMPANY
LOCATION
SEQ
OPT-SEQ
KeyChange
IC10.2 IC11.1
IC12.1 IC330
IC60.1 IC61.1
IC62.1 IC62.4
IC65.1
COMSET3 ITEM-GROUP
COMPANY
LOCATION
KIT-ITEM
ITEM
SEQ
OPT-SEQ
KeyChange
IC60.2 IC61.1
IC62.1 IC62.4
IC68.1 IC68.2


COMPONENT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Comp Is Kit KITITEM Not Required
COM-ITEM-GROUP->KIT-ITEM-GROUP
COM-COMPANY->KIT-COMPANY
COM-LOCATION->KIT-LOCATION
COM-ITEM->KIT-ITEM
Itemgroup ITEMGROUP Required
COM-ITEM-GROUP->ITG-ITEM-GROUP
Itemloc ITEMLOC Required
COM-COMPANY->ITL-COMPANY
COM-LOCATION->ITL-LOCATION
COM-ITEM->ITL-ITEM
Itemmast ITEMMAST Required
COM-ITEM-GROUP->ITE-ITEM-GROUP
COM-ITEM->ITE-ITEM
Kit Itemmast ITEMMAST Required
COM-ITEM-GROUP->ITE-ITEM-GROUP
COM-KIT-ITEM->ITE-ITEM
Kititem KITITEM Required
COM-ITEM-GROUP->KIT-ITEM-GROUP
COM-COMPANY->KIT-COMPANY
COM-LOCATION->KIT-LOCATION
COM-KIT-ITEM->KIT-ITEM


COMPONENT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Ktinstruct KTINSTRUCT Delete Cascades
COM-ITEM-GROUP->KTI-ITEM-GROUP
COM-COMPANY->KTI-COMPANY
COM-LOCATION->KTI-LOCATION
COM-KIT-ITEM->KTI-KIT-ITEM
COM-SEQ->KTI-SEQ
  KTI-INST-LINE


File created: Thu Jun 09 11:16:46 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.