Lawson Insight Technical Documentation |
|
COMPONENT
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
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 BL120
BL122 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL90.1 BL92.1
CXCP.1 MA180 MA41.1 MA41.2 MA41.4 MA41.7
MA43.1 MA43.2 MA43.3 MA43.7 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA66.2 MA66.3
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 PO190 PO20.1 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO23.1 PO24.1 PO25.1
PO25.5 PO25.6 PO25.7 PO27.2 PO29.1 PO30.1
PO30.2 PO30.3 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 POI3.1 POID.1 POII.1 POIJ.1
RQ10.1 RQ10.2 RQ10.3 RQ11.1 RQ12.1 RQ13.1
RQ13.2 RQ35.1 RQ500 RQIF.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 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 IC11.1 IC12.1 IC330
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
COM-ITEM-GROUP Alpha 5
Element: Item Group This field contains the identifier for
a group of items that can be shared by
one or more companies.
COM-COMPANY Numeric 4
Element: Company 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 Alpha 5
Element: Location This field contains a valid stock
location within the company inventory.
COM-KIT-ITEM Alpha 32
Element: Item 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 Numeric 3
Element: Seq This field contains the number assigned
to each component item.
COM-OPT-SEQ Numeric 3
Element: Seq 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 Alpha 32 AP125 AP126
Element: Item This field contains the item's AP131 AP20.1
identifier. 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 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 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
...
COM-QUANTITY Signed 13.4
Element: Quantity This field contains the number of
component items needed to make one kit
item.
COM-START-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Start Date This field contains the first date that AP131 AP20.1
this component is a valid component item AP20.2 AP20.3
for the kit. AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL90.1 BL92.1
CXCP.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
MA75.1 MA80.1
MAI1.1 PD10.1
PD10.2 PD130
...
COM-STOP-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Stop Date This field contains the last date that AP131 AP20.1
this component is a valid component item AP20.2 AP20.3
for the kit. AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL90.1 BL92.1
CXCP.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
MA75.1 MA80.1
MAI1.1 PD10.1
PD10.2 PD130
...
COM-REQUIRED-FL Alpha 1 AP125 AP126
Element: All Flag This field indicates whether the AP131 AP20.1
component is required for the kit. AP20.2 AP20.3
N = No AP20.4 AP20.5
Y = Yes AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 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
...
COM-INST-LINE Numeric 3
Element: Inst Line This field contains the last line
number used for kit instructions for
this line.
COM-LAST-OPT-SEQ Numeric 3
Element: Seq This field contains the last number
used for sequencing optional components
for this line.
COM-QTY-TOL-PCT Percent 5.3 (Percent)
Element: Qty Tol Pct This is the quantity tolerance percent
for a component of a finished good kit
item.
COM-ZERO-QTY-FL Alpha 1
Element: All Flag 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
Element: Acct Unit The waste account unit is used to
default to components added to a work
order.
COM-WST-ACCOUNT Numeric 6
Element: Account The waste account is used to default to
components added to a work order.
COM-WST-SUB-ACCT Numeric 4
Element: Sub Acct The waste subaccount is used to default
to components added to a work order.
COM-COMPONENT-TYPE Alpha 1
Element: Component TypeThe 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 Alpha 5
Element: Location This field contains a valid stocking
location within the company inventory.
COM-ME-ACCT-UNIT Alpha 15
Element: Me Acct Unit
COM-ME-ACCOUNT Numeric 6
Element: Me Account
COM-ME-SUB-ACCT Numeric 4
Element: Me Sub Acct
COMPONENT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
COMSET1 ITEM-GROUP AP125 AP126
COMPANY AP131 AP20.1
LOCATION AP20.2 AP20.3
KIT-ITEM AP20.4 AP20.5
SEQ AP20.7 AP21.1
OPT-SEQ AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL90.1 BL92.1
...
COMSET2 ITEM-GROUP KeyChange IC11.1 IC12.1
ITEM IC330
KIT-ITEM
COMPANY
LOCATION
SEQ
OPT-SEQ
COMSET3 ITEM-GROUP KeyChange
COMPANY
LOCATION
KIT-ITEM
ITEM
SEQ
OPT-SEQ
COMPONENT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
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
|