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
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1 PO136
PO190 PO300 PO520 POCP.1 POI3.1 POII.1
POIJ.1

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.
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.
COM-LOCATION
Element: Location
Alpha 5
This field contains a valid stock location within the company inventory.
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.
COM-SEQ
Element: Seq
Numeric 3
This field contains the number assigned to each component item.
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.
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
COM-QUANTITY
Element: Quantity
Signed 13.4
This field contains the number of component items needed to make one kit item.
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
COM-INST-LINE
Element: Inst Line
Numeric 3
This field contains the last line number used for kit instructions for this line.
COM-LAST-OPT-SEQ
Element: Seq
Numeric 3
This field contains the last number used for sequencing optional components for this line.
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.
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
COM-WST-ACCT-UNIT
Element: Acct Unit
Alpha 15
The waste account unit is used to default to components added to a work order.
COM-WST-ACCOUNT
Element: Account
Numeric 6
The waste account is used to default to components added to a work order.
COM-WST-SUB-ACCT
Element: Sub Acct
Numeric 4
The waste subaccount is used to default to components added to a work order.
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
COM-INV-LOCATION
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
COM-ME-ACCT-UNIT
Element: Me Acct Unit
Alpha 15
COM-ME-ACCOUNT
Element: Me Account
Numeric 6
COM-ME-SUB-ACCT
Element: Me Sub Acct
Numeric 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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
COMSET2 ITEM-GROUP
ITEM
KIT-ITEM
COMPANY
LOCATION
SEQ
OPT-SEQ
KeyChange
COMSET3 ITEM-GROUP
COMPANY
LOCATION
KIT-ITEM
ITEM
SEQ
OPT-SEQ
KeyChange


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 (KITSET1)
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


File created: Wed Jun 08 20:49:37 2016

Home
Contact Us



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