|
|
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 AP25.1 AP25.2 AP26.1
AP27.1 AP30.4 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL85.1 BL85.2 BL90.1 BL92.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 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 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 OE111 OE113
OE114 OE116 OE129 OE13.2 OE13.3 OE13.5
OE13.6 OE14.4 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE510 OE530
OE81.1 OE810 OE830 OE90.1 OE90.2 PO100
PO101 PO122 PO131 PO20.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO23.1 PO29.1 PO30.1
PO30.2 PO30.3 PO300 PO31.1 PO31.2 PO32.2
PO33.1 PO34.1 PO35.1 PO38.1 PO39.1 PO39.2
PO44.1 PO50.1 PO52.1 PO520 POI3.1 POIE.1
POII.1 POIJ.1 RQ10.1 RQ10.2 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 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 WO10.1
WO220 WO255 WO510 WO82.1
UPDATED BY
IC60.1 IC60.3 IC60.2 IC62.1 IC62.2 IC62.4
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 IC62.4
a group of items that can be shared by
one or more companies.
KIT-COMPANY Numeric 4 IC262 IC60.1
Element: Company Identifies the AP company if the IC62.1 IC62.2
resource type = V. Identifies the HR IC62.4
company if the resource type = E. It is
blank for type A, P or Q resources.
KIT-LOCATION Alpha 5 IC262 IC60.1
Element: Location Code This field contains a valid stocking IC62.1 IC62.2
location within the company inventory. IC62.4
KIT-ITEM Alpha 32 IC262 IC60.1
Element: Item Number This field contains the item IC62.1 IC62.2
identifier. IC62.4
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 IC62.4
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 IC62.4
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 IC62.4
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 IC62.4
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: Instruction LiThis field contains the number of the IC62.4
last instruction line. This field is
used when adding new instruction lines.
KIT-CTG-PROD-FLAG Alpha 1 IC62.1 IC62.4
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 IC62.4
Unit Cost Tolerance This field contains the cost tolerance
Percent percent for a finished good.
KIT-ZERO-COST-FL Alpha 1 IC62.1 IC62.4
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 IC62.4
Element: Qty Tol Pct This is the quantity tolerance percent
for a finished good.
KIT-ZERO-QTY-FL Alpha 1 IC62.1 IC62.4
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 IC62.4
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 IC62.4
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 IC62.4
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 IC62.4
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 IC62.4
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 IC62.4
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 IC62.4
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 IC62.4
Element: Pc Acct Unit
KIT-PC-ACCOUNT Numeric 6 IC62.1 IC62.4
Element: Pc Account
KIT-PC-SUB-ACCT Numeric 4 IC62.1 IC62.4
Element: Pc Sub Acct
KIT-BA-ACCT-UNIT Alpha 15 IC62.1 IC62.4
Element: Ba Acct Unit
KIT-BA-ACCOUNT Numeric 6 IC62.1 IC62.4
Element: Ba Account
KIT-BA-SUB-ACCT Numeric 4 IC62.1 IC62.4
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 AP25.1
LOCATION AP25.2 AP26.1
ITEM AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL85.1
BL85.2 BL90.1
BL92.1 CXCP.1
IC10.2 IC11.1
IC12.1 IC143
IC28.1 IC330
...
KITSET2 MAKE-CD KeyChange IC260 IC262
ITEM-GROUP IC60.1 IC62.1
COMPANY IC62.2 IC62.4
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
|
