|
|
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 BL92.1 CX100 CX20.1
CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300
CX506 CXCP.1 DR100 IC11.1 IC12.1 IC141
IC142 IC61.1 IC63.1 IC67.1 IC68.1 IC68.2
IC83.1 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5
OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8
OE11.9 OE110 OE113 OE114 OE129 OE14.4
OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE510 OE810 OE830 OE90.1
OE920 OE950 PO31.1 RQ10.1 RQ10.3 RQ11.1
RQ12.1 RQ13.1 RQ15.1 RQ20.1 RQ35.1 RQ500
RQ961 WH110 WH130 WH132 WH190 WH20.1
WH20.2 WH20.7 WH22.1 WH222 WH30.1 WH30.2
WH30.3 WH31.1 WH31.2 WH31.3 WH32.1 WH32.2
WH32.3 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 WO120
WO132 WO140 WO20.1 WO20.2 WO30.1 WO32.1
WO40.1 WO40.2 WO40.3 WO40.4 WO40.5 WO41.1
WO41.2 WO41.3 WO41.4 WO42.1 WO42.2 WO42.3
WO42.4 WO42.5 WO45.1 WOA2.1 WOEX.1 WOSP.1
IC260 IC262 WO10.1 WO220 WO255 WO510
WO82.1
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 stock IC62.2
location within the company inventory.
KIT-ITEM Alpha 32 IC60.1 IC62.1
Item Number This field contains the item identifier. IC62.2
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 WO20.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 = Days
W = Weeks
M = Months
KIT-PC-ACCT-UNIT Alpha 15 IC62.1
Pc Acct Unit The production credit account unit is
used to default to work orders making a
particular finished good.
KIT-PC-ACCOUNT Numeric 6 IC62.1
Pc Account The production credit account is used
to default to a work order making a
particular finished good.
KIT-PC-SUB-ACCT Numeric 4 IC62.1
Pc Sub Acct The production credit sub account is
used to default to a work order creating
a particular finished good.
KIT-BA-ACCT-UNIT Alpha 15 IC62.1
Ba Acct Unit The burden absorption account unit is
used to default to a work order creating
a particular finished good.
KIT-BA-ACCOUNT Numeric 6 IC62.1
Ba Account The burden absorption account is used
to default to work orders creating a
specific finished good.
KIT-BA-SUB-ACCT Numeric 4 IC62.1
Ba Sub Acct The burden absorption sub account is
used to default to work orders creating
a specific finished good.
KITITEM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
KITSET1 ITEM-GROUP BL85.1 BL85.2
COMPANY BL90.1 BL92.1
LOCATION CX100 CX20.1
ITEM CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC11.1
IC12.1 IC141
IC142 IC60.1
IC60.2 IC60.3
IC61.1 IC62.1
IC62.2 IC63.1
IC67.1 IC68.1
IC68.2 IC83.1
...
KITSET2 MAKE-CD KeyChange IC260 IC262
ITEM-GROUP IC60.1 IC62.1
COMPANY IC62.2 WO10.1
LOCATION WO120 WO20.1
ITEM WO20.2 WO220
WO255 WO40.1
WO510 WO82.1
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
|