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
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. |
|
||||||
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. |
|||||||
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. |
|||||||
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. |
|||||||
COM-REQUIRED-FL Element: All Flag | Alpha 1 This field indicates whether the component is required for the kit. N = No Y = Yes |
|||||||
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 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
COMSET1 |
ITEM-GROUP COMPANY LOCATION KIT-ITEM SEQ OPT-SEQ |
|
|||||||||||||||||
COMSET2 |
ITEM-GROUP ITEM KIT-ITEM COMPANY LOCATION SEQ OPT-SEQ |
|
| ||||||||||||||||
COMSET3 |
ITEM-GROUP COMPANY LOCATION KIT-ITEM ITEM SEQ OPT-SEQ |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Comp Is Kit | KITITEM |
Not Required
| ||||||||||||
Itemgroup | ITEMGROUP |
Required
| ||||||||||||
Itemloc | ITEMLOC |
Required
| ||||||||||||
Itemmast | ITEMMAST |
Required
| ||||||||||||
Kit Itemmast | ITEMMAST |
Required
| ||||||||||||
Kititem | KITITEM |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Ktinstruct | KTINSTRUCT |
Delete Cascades
|
All trademarks and registered trademarks are the property of their
respective owners.