COMPONENT FILE
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.
REFERENCED BY
BL90.1 BL92.1 CX100 CX20.1 CX20.2 CX20.4
CX20.5 CX220 CX30.1 CX300 CX506 CXCP.1
DR100 IC141 IC142 IC260 IC262 IC67.1
IC83.1 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5
OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8
OE11.9 OE110 OE113 OE114 OE129 OE14.4
OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE510 OE810 OE830 OE90.1
OE920 OE950 PO31.1 RQ10.1 RQ10.3 RQ11.1
RQ12.1 RQ13.1 RQ20.1 RQ35.1 RQ500 RQ961
WH110 WH130 WH132 WH190 WH20.1 WH20.2
WH20.7 WH22.1 WH222 WH30.1 WH30.2 WH30.3
WH31.1 WH31.2 WH31.3 WH32.1 WH32.2 WH32.3
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 WO120 WO132
WO140 WO20.1 WO30.1 WO32.1 WO40.1 WO40.2
WO40.3 WO40.4 WO40.5 WO41.1 WO41.2 WO41.3
WO41.4 WO42.1 WO42.2 WO42.3 WO42.4 WO42.5
WO45.1 WOEX.1 WOSP.1 IC11.1 IC12.1 IC65.1
IC68.1 IC68.2
UPDATED BY
IC60.1 IC60.2 IC60.3 IC61.1 IC62.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
COM-ITEM-GROUP Alpha 5 IC60.1 IC60.2
Item Group This field contains the identifier for IC62.1 IC68.1
a group of items that can be shared by
one or more companies.
COM-COMPANY Numeric 4 IC60.1 IC60.2
Company The company represents and established IC62.1 IC68.1
company and is entered on all functions
codes.
COM-LOCATION Alpha 5 IC60.1 IC60.2
Location Code This field contains a valid stock IC62.1 IC68.1
location within the company inventory.
COM-KIT-ITEM Alpha 32 IC60.1 IC60.2
Kit Item This field contains the parent item, IC62.1 IC68.1
which is made up of component items. The
kit item can be either a finished good
or make-to-order kit.
COM-SEQ Numeric 3 IC60.1 IC60.2
Sequence Number This field contains the number assigned IC62.1
to each component item.
COM-OPT-SEQ Numeric 3 IC60.2
Options Sequence This field contains a number assigned
Number to each optional item for a single
component. This field holds the last
options sequence number used for this
line.
COM-ITEM Alpha 32 BL92.1 CX100
Item Number This field contains the item's CX20.1 CX20.2
identifier. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
IC60.1 IC60.2
IC61.1 IC62.1
IC83.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE90.1
OE920 OE950
PO31.1 RQ10.1
RQ10.3 RQ11.1
...
COM-QUANTITY Signed 13.4 IC60.1 IC60.2
Quantity This field contains the number of IC62.1
component items needed to make one kit
item.
COM-START-DATE Numeric 8 (yyyymmdd) BL90.1 BL92.1
Start Date This field contains the first date that CX100 CX20.1
this component is a valid component item CX20.2 CX20.4
for the kit. CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC141
IC142 IC60.1
IC60.2 IC62.1
IC83.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE90.1
OE920 OE950
PO31.1 RQ10.1
RQ10.3 RQ11.1
...
COM-STOP-DATE Numeric 8 (yyyymmdd) BL90.1 BL92.1
Stop Date This field contains the last date that CX100 CX20.1
this component is a valid component item CX20.2 CX20.4
for the kit. CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC141
IC142 IC60.1
IC60.2 IC62.1
IC83.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE90.1
OE920 OE950
PO31.1 RQ10.1
RQ10.3 RQ11.1
...
COM-REQUIRED-FL Alpha 1 BL92.1 CX100
Required Flag This field indicates whether the CX20.1 CX20.2
component is required for the kit. CX20.4 CX20.5
N = No CX220 CX30.1
Y = Yes CX300 CX506
CXCP.1 DR100
IC141 IC142
IC60.1 IC60.2
IC62.1 IC83.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE90.1 OE920
OE950 PO31.1
RQ10.1 RQ10.3
RQ11.1 RQ12.1
...
COM-INST-LINE Numeric 3 IC60.3
Instruction Line This field contains the last line
number used for kit instructions for
this line.
COM-LAST-OPT-SEQ Numeric 3 IC60.2
Last Option Sequence This field contains the last number
used for sequencing optional components
for this line.
COM-QTY-TOL-PCT Percent 5.3 (Percent) IC62.1
Qty Tol Pct This is the quantity tolerance percent
for a component of a finished good kit
item.
COM-ZERO-QTY-FL Alpha 1 IC62.1
Zero Qty Fl 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
COM-WST-ACCT-UNIT Alpha 15 IC60.1 IC62.1
Wst Acct Unit The waste account unit is used to
default to components added to a work
order.
COM-WST-ACCOUNT Numeric 6 IC60.1 IC62.1
Wst Account The waste account is used to default to
components added to a work order.
COM-WST-SUB-ACCT Numeric 4 IC60.1 IC62.1
Wst Sub Acct The waste subaccount is used to default
to components added to a work order.
COM-COMPONENT-TYPE Alpha 1 IC60.1 IC62.1
Component Type 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 the Inventory Control system, 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
COM-INV-LOCATION Alpha 5 IC60.1 IC62.1
Inventory Location This field contains the location from
which inventory is taken.
COM-ME-ACCT-UNIT Alpha 15 IC62.1
Me Acct Unit The material expense account unit is
used to default to components added to a
work order.
COM-ME-ACCOUNT Numeric 6 IC62.1
Me Account The material expense account is used to
default to components added to a work
order.
COM-ME-SUB-ACCT Numeric 4 IC62.1
Me Sub Acct The material expense sub account is
used to default to components added to a
work order.
COMPONENT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
COMSET1 ITEM-GROUP BL90.1 BL92.1
COMPANY CX100 CX20.1
LOCATION CX20.2 CX20.4
KIT-ITEM CX20.5 CX220
SEQ CX30.1 CX300
OPT-SEQ CX506 CXCP.1
DR100 IC141
IC142 IC260
IC262 IC60.1
IC60.2 IC60.3
IC61.1 IC62.1
IC67.1 IC83.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
...
COMSET2 ITEM-GROUP KeyChange IC11.1 IC12.1
ITEM IC60.1 IC61.1
KIT-ITEM IC62.1 IC65.1
COMPANY
LOCATION
SEQ
OPT-SEQ
COMSET3 ITEM-GROUP KeyChange IC60.2 IC61.1
COMPANY IC62.1 IC68.1
LOCATION IC68.2
KIT-ITEM
ITEM
SEQ
OPT-SEQ
COMPONENT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Itemgroup ITEMGROUP Required
COM-ITEM-GROUP -> ITG-ITEM-GROUP
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 RELATED
NAME 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
|