COMPONENT

User Field

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
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 AP510 API1.1
API2.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 DR100
IC02.1 IC10.2 IC11.1 IC12.1 IC140 IC141
IC142 IC145 IC15.2 IC175 IC183 IC20.1
IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC223
IC23.1 IC24.1 IC24.2 IC243 IC25.1 IC260
IC262 IC320 IC330 IC331 IC500 IC503
IC524 IC58.1 IC64.1 IC64.2 IC64.3 IC64.4
IC64.5 IC64.6 IC64.7 IC64.8 IC64.9 IC66.1
IC67.1 IC81.1 IC811 IC812 IC82.1 IC83.1
IC840 MA180 MA278 MA41.1 MA41.2 MA41.4
MA41.7 MA42.2 MA43.2 MA43.7 MA44.1 MA44.2
MA53.1 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 PD570
PO04.1 PO04.2 PO10.1 PO10.2 PO100 PO101
PO115 PO120 PO122 PO131 PO132 PO136
PO15.1 PO15.2 PO15.4 PO150 PO17.1 PO190
PO20.1 PO20.6 PO20.9 PO204 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO22.3 PO22.4
PO220 PO222 PO224 PO225 PO229 PO23.1
PO230 PO234 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO251 PO26.3 PO26.4 PO26.5 PO26.7
PO26.9 PO27.2 PO27.3 PO27.4 PO275 PO276
PO277 PO28.2 PO280 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 RQ01.1 RQ10.1 RQ10.2 RQ10.3
RQ10.4 RQ10.5 RQ11.1 RQ12.1 RQ13.1 RQ13.2
RQ35.1 RQ44.1 RQ500 RQ810 RQIB.1 RQIC.1
RQID.1 RQIF.1 RQIG.1 RQII.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 IC65.1 IC68.1 IC68.2


UPDATED BY
IC60.1 IC60.2 IC60.3 IC61.1 IC62.1 IC62.4

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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC60.1
IC60.2 IC61.1
IC62.1 IC62.4
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 MA180
MA278 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC60.1
IC60.2 IC62.1
IC62.4 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC60.1
IC60.2 IC62.1
IC62.4 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC60.1
IC60.2 IC62.1
IC62.4 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
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 02:18:25 2016

Home
Contact Us



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