KITITEM

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 AP510 API1.1
API2.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 DR100
IC02.1 IC10.2 IC11.1 IC12.1 IC140 IC141
IC142 IC143 IC145 IC15.2 IC175 IC183
IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2
IC223 IC23.1 IC24.1 IC24.2 IC243 IC25.1
IC320 IC330 IC331 IC500 IC503 IC524
IC58.1 IC61.1 IC63.1 IC64.1 IC64.2 IC64.3
IC64.4 IC64.5 IC64.6 IC64.7 IC64.8 IC64.9
IC66.1 IC67.1 IC68.1 IC68.2 IC81.1 IC811
IC812 IC82.1 IC83.1 IC840 ICBD.1 ICBD.2
MA180 MA278 MA41.1 MA41.2 MA41.4 MA41.7
MA42.2 MA43.2 MA43.7 MA44.1 MA44.2 MA53.1
MA530 MA531 MA60.2 MA60.3 MA60.5 MA61.1
MA66.2 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 PD570 PO04.1
PO04.2 PO10.1 PO10.2 PO100 PO101 PO115
PO120 PO122 PO131 PO132 PO136 PO15.1
PO15.2 PO15.4 PO150 PO17.1 PO190 PO20.1
PO20.6 PO20.9 PO204 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO22.3 PO22.4 PO220
PO222 PO224 PO225 PO229 PO23.1 PO230
PO234 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO251 PO26.3 PO26.4 PO26.5 PO26.7 PO26.9
PO27.2 PO27.3 PO27.4 PO275 PO276 PO277
PO28.2 PO280 PO29.1 PO30.1 PO30.2 PO30.3
PO30.4 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 PO54.5 POCP.1 POI3.1 POID.1 POII.1
POIJ.1 RQ01.1 RQ10.1 RQ10.2 RQ10.3 RQ10.4
RQ10.5 RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ35.1
RQ44.1 RQ500 RQ810 RQIB.1 RQIC.1 RQID.1
RQIF.1 RQIG.1 RQIH.1 RQII.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 WH32.5 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 IC260 IC262 RQD1.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
Element: Item Group
Alpha 5
This field contains the identifier for a group of items that can be shared by one or more companies.
IC60.1 IC62.1
IC62.2 IC62.4
KIT-COMPANY
Element: Company
Numeric 4
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.
IC262 IC60.1
IC62.1 IC62.2
IC62.4
KIT-LOCATION
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
IC262 IC60.1
IC62.1 IC62.2
IC62.4
KIT-ITEM
Element: Item
Alpha 32
This field contains the item identifier.
IC262 IC60.1
IC62.1 IC62.2
IC62.4
KIT-ORDER-SIZE
Element: Order Size
Numeric 8
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.
IC60.1
KIT-NOTES
Element: Notes
Alpha 20 (Lower Case)
This field contains notes about the kit. This information is for reference purposes only.
IC60.1
KIT-PROCEDURE-CD
Element: Procedure Cd
Alpha 7 (Lower Case)
This field contains the procedure code for the kit. This information is for reference purposes only.
IC60.1 IC62.1
IC62.4
KIT-MAKE-CD
Element: Make Cd
Alpha 1
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
IC60.1 IC62.1
IC62.4
KIT-ACTIVE-STATUS
Element: Active Status
Alpha 1
This field contains the status to control the use of the kit.
A = Active
I = Inactive
IC60.1 IC62.1
IC62.4
KIT-SEQ
Element: Seq
Numeric 3
This field contains the last sequence number of the last component line. This field is used when adding new component lines.
IC60.1 IC62.1
IC62.4
KIT-INST-LINE
Element: Inst Line
Numeric 3
This field contains the number of the last instruction line. This field is used when adding new instruction lines.
IC60.3 IC62.1
IC62.4
KIT-CTG-PROD-FLAG
Element: All Flag
Alpha 1
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
IC62.1 IC62.4
KIT-COST-TOL-PCT
Element: Cost Tol Pct
Percent 5.3 (Percent)
This field contains the cost tolerance percent for a finished good.
IC62.1 IC62.4
KIT-ZERO-COST-FL
Element: All Flag
Alpha 1
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
IC62.1 IC62.4
KIT-QTY-TOL-PCT
Element: Qty Tol Pct
Percent 5.3 (Percent)
This is the quantity tolerance percent for a finished good.
IC62.1 IC62.4
KIT-ZERO-QTY-FL
Element: All Flag
Alpha 1
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
IC62.1 IC62.4
KIT-LAST-BRDN-SEQ
Element: Seq
Numeric 3
This field contains the last burden sequence.
IC62.1 IC62.4
KIT-LAST-BYPRO-SEQ
Element: Seq
Numeric 3
This field contains the last byproduct sequence.
IC62.2
KIT-CAPACITY
Element: Capacity
Numeric 8
Capacity describes the maximum quantity of a finished good that can be produced for a work order.
IC62.1 IC62.4
KIT-FGV-ACCT-UNIT
Element: Acct Unit
Alpha 15
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.
IC60.1 IC62.1
IC62.4
KIT-FGV-ACCOUNT
Element: Account
Numeric 6
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.
IC60.1 IC62.1
IC62.4
KIT-FGV-SUB-ACCT
Element: Sub Acct
Numeric 4
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.
IC60.1 IC62.1
IC62.4
KIT-SCHED-INCR
Element: Sched Incr
Numeric 2
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.
IC62.1 IC62.4
KIT-SCHED-FREQ
Element: Sched Freq
Alpha 1
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
IC62.1 IC62.4
KIT-PC-ACCT-UNIT
Element: Pc Acct Unit
Alpha 15
IC62.1 IC62.4
KIT-PC-ACCOUNT
Element: Pc Account
Numeric 6
IC62.1 IC62.4
KIT-PC-SUB-ACCT
Element: Pc Sub Acct
Numeric 4
IC62.1 IC62.4
KIT-BA-ACCT-UNIT
Element: Ba Acct Unit
Alpha 15
IC62.1 IC62.4
KIT-BA-ACCOUNT
Element: Ba Account
Numeric 6
IC62.1 IC62.4
KIT-BA-SUB-ACCT
Element: Ba Sub Acct
Numeric 4
IC62.1 IC62.4
KIT-ITEM-CODE-USED
Element: Item Code Used
Derived


KITITEM FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
KITSET1 ITEM-GROUP
COMPANY
LOCATION
ITEM
...
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
KITSET2 MAKE-CD
ITEM-GROUP
COMPANY
LOCATION
ITEM
KeyChange
IC260 IC262
IC60.1 IC62.1
IC62.2 IC62.4
RQD1.1


KITITEM FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
Kitbod KITBOD Not Required, Delete Cascades
KIT-ITEM-GROUP->IBF-ITEM-GROUP
KIT-COMPANY->IBF-COMPANY
KIT-LOCATION->IBF-LOCATION
KIT-ITEM->IBF-ITEM


KITITEM FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 02:19:09 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.