|
|
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 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 BL85.1 BL85.2
BL90.1 BL92.1 CXCP.1 IC11.1 IC12.1 IC330
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 RQIC.1 RQID.1 RQIF.1 RQIG.1
RQIH.1 RQIJ.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 RQD1.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
KIT-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.
KIT-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.
KIT-LOCATION Alpha 5
Element: Location This field contains a valid stocking
location within the company inventory.
KIT-ITEM Alpha 32
Element: Item This field contains the item
identifier.
KIT-ORDER-SIZE Numeric 8
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)
Element: Notes This field contains notes about the
kit. This information is for reference
purposes only.
KIT-PROCEDURE-CD Alpha 7 (Lower Case)
Element: Procedure Cd This field contains the procedure code
for the kit. This information is for
reference purposes only.
KIT-MAKE-CD Alpha 1
Element: Make Cd 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
Element: Active Status This field contains the status to
control the use of the kit.
A = Active
I = Inactive
KIT-SEQ Numeric 3
Element: Seq 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
Element: Inst 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
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)
Element: Cost Tol Pct This field contains the cost tolerance
percent for a finished good.
KIT-ZERO-COST-FL Alpha 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)
Element: Qty Tol Pct This is the quantity tolerance percent
for a finished good.
KIT-ZERO-QTY-FL Alpha 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
Element: Seq This field contains the last burden
sequence.
KIT-LAST-BYPRO-SEQ Numeric 3
Element: Seq This field contains the last byproduct
sequence.
KIT-CAPACITY Numeric 8
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
Element: 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
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
Element: 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
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
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
Element: Pc Acct Unit
KIT-PC-ACCOUNT Numeric 6
Element: Pc Account
KIT-PC-SUB-ACCT Numeric 4
Element: Pc Sub Acct
KIT-BA-ACCT-UNIT Alpha 15
Element: Ba Acct Unit
KIT-BA-ACCOUNT Numeric 6
Element: Ba Account
KIT-BA-SUB-ACCT Numeric 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 AP20.1
LOCATION AP20.2 AP20.3
ITEM 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
BL85.1 BL85.2
...
KITSET2 MAKE-CD KeyChange RQD1.1
ITEM-GROUP
COMPANY
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
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
|
