KITITEM FILE
Kit Item
The Kit Item file contains the valid kit or parent items for a make-to-order
or finished good kit.
REFERENCED BY
BL85.1 BL85.2 BL90.1 CXCP.1 DR100 IC10.2
IC11.1 IC12.1 IC141 IC142 IC143 IC330
IC61.1 IC63.1 IC67.1 IC68.1 IC68.2 IC83.1
POIJ.1 RQ11.1 RQ12.1 RQ13.1 WH110 WH130
WH22.1 WH33.1 WH33.2 WH33.3 WH33.4 WH33.5
WH33.6 WH33.8 WH33.9 WH34.1 WH34.2 WH34.3
WH34.4 IC260 IC262
UPDATED BY
IC60.1 IC60.3 IC60.2 IC62.1 IC62.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
KIT-ITEM-GROUP Alpha 5 IC60.1 IC62.1
Item Group This field contains the identifier for IC62.2
a group of items that can be shared by
one or more companies.
KIT-COMPANY Numeric 4 IC60.1 IC62.1
Company The company number represents an IC62.2
established company and is entered on
all function codes.
KIT-LOCATION Alpha 5 IC60.1 IC62.1
Location Code This field contains a valid stocking IC62.2
location within the company inventory.
KIT-ITEM Alpha 32 IC60.1 IC62.1
Item Number This field contains the item IC62.2
identifier.
KIT-ORDER-SIZE Numeric 8 IC60.1
Order Size This field contains the standard order
size for the kit. The component quantity
specifies the number of required kit
components needed for each kit. This
field is for reference purposes only.
KIT-NOTES Alpha 20 (Lower Case) IC60.1
Notes This field contains notes about the
kit. This information is for reference
purposes only.
KIT-PROCEDURE-CD Alpha 7 (Lower Case) IC60.1 IC62.1
Procedure Code This field contains the procedure code
for the kit. This information is for
reference purposes only.
KIT-MAKE-CD Alpha 1 IC60.1 IC62.1
Make Code This field contains the code that
specifies whether a kit is a
make-to-order or a finished good kit.
O = Make to Order
S = Make to Stock
KIT-ACTIVE-STATUS Alpha 1 IC60.1 IC62.1
Status This field contains the status to
control the use of the kit.
A = Active
I = Inactive
KIT-SEQ Numeric 3 IC60.1 IC62.1
Sequence Number This field contains the last sequence
number of the last component line. This
field is used when adding new component
lines.
KIT-INST-LINE Numeric 3 IC60.3 IC62.1
Instruction Line This field contains the number of the
last instruction line. This field is
used when adding new instruction lines.
KIT-CTG-PROD-FLAG Alpha 1 IC62.1
Ctg Prod Flag This field contains the contiguous
production flag, used if production
spans multiple days. Set its value to
Yes if production must occur on
consecutive days - there cannot be any
non-work days between the start and end
production dates.
Y = Yes
N = No
KIT-COST-TOL-PCT Percent 5.3 (Percent) IC62.1
Unit Cost Tolerance This field contains the cost tolerance
Percent percent for a finished good.
KIT-ZERO-COST-FL Alpha 1 IC62.1
Zero Cost Flag The zero cost tolerance flag is used to
indicate if zero tolerance is allowed
for finished good cost tolerance
checking. If no tolerance checking is
needed, this field's value is No.
Y = Yes
N = No
KIT-QTY-TOL-PCT Percent 5.3 (Percent) IC62.1
Qty Tol Pct This is the quantity tolerance percent
for a finished good.
KIT-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 finished good quantity
tolerance checking. If no tolerance
checking is desired, this field's value
is No.
Y = Yes
N = No
KIT-LAST-BRDN-SEQ Numeric 3 IC62.1
Last Brdn Seq This field contains the last burden
sequence.
KIT-LAST-BYPRO-SEQ Numeric 3 IC62.2
Last Bypro Seq This field contains the last byproduct
sequence.
KIT-CAPACITY Numeric 8 IC62.1
Capacity Capacity describes the maximum quantity
of a finished good that can be produced
for a work order.
KIT-FGV-ACCT-UNIT Alpha 15 IC60.1 IC62.1
Fgv Acct Unit The finished good variance accounting
unit is used to post variances in
finished good cost when there is a
difference between the cost from an
original work order and the cost
returned from inventory for a reversed
work order.
KIT-FGV-ACCOUNT Numeric 6 IC60.1 IC62.1
Fgv Account The finished good variance account is
used to post variances in finished good
cost when there is a difference between
the cost from an original work order and
the cost returned from inventory for a
reversed work order.
KIT-FGV-SUB-ACCT Numeric 4 IC60.1 IC62.1
Fgv Sub Acct The finished good variance subaccount
is used to post variances in finished
good cost when there is a difference
between the cost from an original work
order and the cost returned from
inventory for a reversed work order.
KIT-SCHED-INCR Numeric 2 IC62.1
Sched Incr Schedule increment is used with
schedule frequency to indicate the
length of a scheduling period for work
orders. The increment is the number of
days, weeks or months in a period.
KIT-SCHED-FREQ Alpha 1 IC62.1
Sched Freq Schedule frequency is used with
schedule increment to indicate the
length of a scheduling period for work
orders. The frequency defines whether
the period is in days, weeks or months.
D = Daily
W = Weekly
M = Monthly
KIT-PC-ACCT-UNIT Alpha 15 IC62.1
Pc Acct Unit
KIT-PC-ACCOUNT Numeric 6 IC62.1
Pc Account
KIT-PC-SUB-ACCT Numeric 4 IC62.1
Pc Sub Acct
KIT-BA-ACCT-UNIT Alpha 15 IC62.1
Ba Acct Unit
KIT-BA-ACCOUNT Numeric 6 IC62.1
Ba Account
KIT-BA-SUB-ACCT Numeric 4 IC62.1
Ba Sub Acct
KITITEM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
KITSET1 ITEM-GROUP BL85.1 BL85.2
COMPANY BL90.1 CXCP.1
LOCATION DR100 IC10.2
ITEM IC11.1 IC12.1
IC141 IC142
IC143 IC330
IC60.1 IC60.2
IC60.3 IC61.1
IC62.1 IC62.2
IC63.1 IC67.1
IC68.1 IC68.2
IC83.1 POIJ.1
RQ11.1 RQ12.1
RQ13.1 WH110
WH130 WH22.1
...
KITSET2 MAKE-CD KeyChange IC260 IC262
ITEM-GROUP IC60.1 IC62.1
COMPANY IC62.2
LOCATION
ITEM
KITITEM FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Iccompany ICCOMPANY Required
When KIT-COMPANY != Zeroes
KIT-COMPANY -> ICC-COMPANY
Iclocation ICLOCATION Required
When KIT-LOCATION != Spaces
KIT-COMPANY -> ICL-COMPANY
KIT-LOCATION -> ICL-LOCATION
Itemgroup ITEMGROUP Required
KIT-ITEM-GROUP -> ITG-ITEM-GROUP
Itemmast ITEMMAST Required
KIT-ITEM-GROUP -> ITE-ITEM-GROUP
KIT-ITEM -> ITE-ITEM
KITITEM FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Component COMPONENT Delete Cascades
KIT-ITEM-GROUP -> COM-ITEM-GROUP
KIT-COMPANY -> COM-COMPANY
KIT-LOCATION -> COM-LOCATION
KIT-ITEM -> COM-KIT-ITEM
COM-SEQ
COM-OPT-SEQ
Fgburden ICFGBRDN
KIT-COMPANY -> IBR-COMPANY
KIT-LOCATION -> IBR-LOCATION
KIT-ITEM -> IBR-ITEM
IBR-SEQ
Fgbyprod ICFGBYPROD Delete Restricted
KIT-COMPANY -> ICP-COMPANY
KIT-LOCATION -> ICP-LOCATION
KIT-ITEM -> ICP-FG-ITEM
ICP-SEQ
Ktinstruct KTINSTRUCT Delete Cascades
KIT-ITEM-GROUP -> KTI-ITEM-GROUP
KIT-COMPANY -> KTI-COMPANY
KIT-LOCATION -> KTI-LOCATION
KIT-ITEM -> KTI-KIT-ITEM
Zeroes -> KTI-SEQ
KTI-INST-LINE
Worder WORDER
KIT-COMPANY -> WOR-COMPANY
KIT-LOCATION -> WOR-LOCATION
KIT-ITEM -> WOR-ITEM
WOR-WORK-ORDER
WOR-WORK-ORDER-SUF
|
