|
|
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
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.4 API1.1 CXCP.1 IC10.2
IC11.1 IC12.1 IC143 IC28.1 IC330 IC61.1
IC63.1 IC67.1 IC68.1 IC68.2 IC83.1 MA180
MA41.2 MA41.7 MA43.1 MA43.2 MA43.3 MA43.9
MA530 MA531 MA60.2 MA60.3 MA60.5 MA61.1
MA66.2 MA66.3 MA67.1 MA67.2 MA70.1 MA75.1
MA80.1 MAI1.1 PO100 PO101 PO122 PO131
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.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 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 POII.1
POIJ.1 RQ10.1 RQ10.2 RQ10.3 RQ11.1 RQ12.1
RQ13.1 RQ35.1 RQ500 RQIE.1 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 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
WOEX.1 WOPR.1 WOSP.1 IC260 IC262 RQD1.1
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
Element: 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
Element: 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
Element: Location Code This field contains a valid stocking IC62.2
location within the company inventory.
KIT-ITEM Alpha 32 IC60.1 IC62.1
Element: Item Number This field contains the item IC62.2
identifier.
KIT-ORDER-SIZE Numeric 8 IC60.1
Element: 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
Element: 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
Element: Procedure CodeThis field contains the procedure code
for the kit. This information is for
reference purposes only.
KIT-MAKE-CD Alpha 1 IC60.1 IC62.1
Element: 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
Element: 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
Element: Sequence NumbeThis 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
Element: Hdr Dtl Lines 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
Element: All 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
Element: Cost Pct This field contains the cost tolerance
percent for a finished good.
KIT-ZERO-COST-FL Alpha 1 IC62.1
Element: All 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
Element: Cost Pct This is the quantity tolerance percent
for a finished good.
KIT-ZERO-QTY-FL Alpha 1 IC62.1
Element: All Flag 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
Element: Sequence NumbeThis field contains the last burden
sequence.
KIT-LAST-BYPRO-SEQ Numeric 3 IC62.2
Element: Sequence NumbeThis field contains the last byproduct
sequence.
KIT-CAPACITY Numeric 8 IC62.1
Element: 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
Element: Accounting UniThe 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
Element: 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
Element: Subaccount 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
Element: 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
Element: 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
Element: Pc Acct Unit
KIT-PC-ACCOUNT Numeric 6 IC62.1
Element: Pc Account
KIT-PC-SUB-ACCT Numeric 4 IC62.1
Element: Pc Sub Acct
KIT-BA-ACCT-UNIT Alpha 15 IC62.1
Element: Ba Acct Unit
KIT-BA-ACCOUNT Numeric 6 IC62.1
Element: Ba Account
KIT-BA-SUB-ACCT Numeric 4 IC62.1
Element: Ba Sub Acct
KIT-ITEM-CODE-USED Derived
Element: Item Code Used
KITITEM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
KITSET1 ITEM-GROUP AP125 AP126
COMPANY AP131 AP20.1
LOCATION AP20.2 AP20.3
ITEM AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
CXCP.1 IC10.2
IC11.1 IC12.1
IC143 IC28.1
IC330 IC60.1
IC60.2 IC60.3
IC61.1 IC62.1
IC62.2 IC63.1
...
KITSET2 MAKE-CD KeyChange IC260 IC262
ITEM-GROUP IC60.1 IC62.1
COMPANY IC62.2 RQD1.1
LOCATION WO10.1 WO120
ITEM WO20.1 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
|
