ITEMMAST FILE Item Master The Item Master file stores static information about each item. Every item has one Item Master record which contains data such as description, classes, units of measure, and weight. This data is shared by all Item Location records for this item. REFERENCED BY AP125 AP126 AP225 AP226 AP25.1 AP25.2 AP26.1 BL04.1 BL10.1 BL120 BL121 BL122 BL123 BL130 BL140 BL141 BL15.1 BL20.1 BL20.3 BL204 BL21.2 BL21.5 BL210 BL215 BL220 BL230 BL240 BL241 BL243 BL245 BL246 BL247 BL248 BL29.1 BL29.2 BL290 BL30.3 BL30.5 BL31.1 BL31.2 BL31.3 BL31.5 BL31.7 BL32.2 BL32.3 BL32.4 BL33.1 BL330 BL331 BL340 BL341 BL40.1 BL40.2 BL40.3 BL42.1 BL42.2 BL45.3 BL46.3 BL47.3 BL48.3 BL520 BL720 BL80.1 BL820 BL85.1 BL85.2 BL90.1 BL92.1 BL940 BL96E CX05.1 CX05.2 CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX205 CX220 CX30.1 CX300 CX506 CX805 CXCP.1 DR100 DR25.1 DR40.1 DR42.1 IC00.1 IC110 IC116 IC12.1 IC120 IC125 IC13.1 IC130 IC134 IC135 IC138 IC140 IC141 IC142 IC143 IC145 IC150 IC151 IC152 IC16.4 IC170 IC175 IC179 IC182 IC19.1 IC190 IC191 IC192 IC20.1 IC20.2 IC21.1 IC21.2 IC210 IC211 IC212 IC213 IC216 IC219 IC22.1 IC22.2 IC220 IC221 IC222 IC223 IC224 IC225 IC226 IC227 IC228 IC229 IC23.1 IC23.2 IC23.3 IC23.4 IC23.5 IC230 IC232 IC233 IC234 IC237 IC238 IC239 IC24.1 IC24.2 IC240 IC241 IC242 IC243 IC25.1 IC26.1 IC26.2 IC260 IC262 IC27.1 IC270 IC28.1 IC280 IC281 IC283 IC29.1 IC29.2 IC29.3 IC295 IC30.1 IC31.1 IC36.1 IC38.1 IC40.1 IC40.2 IC41.1 IC42.1 IC42.2 IC42.3 IC42.4 IC43.1 IC45.1 IC47.1 IC48.1 IC49.1 IC50.1 IC50.2 IC50.3 IC500 IC51.1 IC519 IC52.1 IC520 IC521 IC522 IC523 IC524 IC525 IC526 IC527 IC53.1 IC530 IC550 IC574 IC589 IC59.1 IC590 IC61.1 IC65.1 IC67.1 IC68.1 IC68.2 IC68.3 IC70.1 IC72.1 IC73.1 IC74.1 IC76.1 IC81.1 IC81.2 IC812 IC82.1 IC820 IC83.1 IC840 IC850 IC851 IC90.1 IC95.1 IC95.2 IC95.3 PC10.1 PC120 PC20.1 PC540 PC810 SEA1.1 IN20.1 MA140 MA190 MA278 MA40.1 MA41.1 MA41.2 MA41.3 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540 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 OE112 OE113 OE114 OE129 OE130 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE230 OE254 OE270 OE271 OE280 OE281 OE282 OE283 OE286 OE287 OE293 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE330 OE510 OE54.1 OE55.1 OE55.2 OE81.1 OE81.3 OE810 OE830 OE90.1 OE90.2 OE920 OE950 PO10.1 PO100 PO115 PO120 PO121 PO122 PO123 PO125 PO13.1 PO130 PO131 PO132 PO133 PO135 PO14.1 PO15.1 PO150 PO16.1 PO16.2 PO180 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.6 PO213 PO214 PO216 PO22.1 PO22.2 PO22.3 PO220 PO221 PO223 PO224 PO225 PO227 PO230 PO233 PO236 PO24.1 PO25.1 PO25.2 PO26.1 PO272 PO275 PO276 PO277 PO28.1 PO28.3 PO28.4 PO28.5 PO28.6 PO28.7 PO28.8 PO280 PO295 PO30.1 PO30.2 PO31.1 PO32.1 PO32.2 PO32.3 PO33.1 PO33.2 PO34.1 PO34.2 PO35.1 PO37.1 PO39.1 PO50.1 PO52.1 PO529 PO53.3 PO530 PO550 PO560 PO60.1 PO61.1 PO62.1 PO63.1 PO64.1 PO67.1 PO72.1 PO72.2 PO813 PO821 PO85.1 PO94.1 POA2.1 RQ10.1 RQ10.2 RQ10.3 RQ11.1 RQ111 RQ115 RQ12.1 RQ120 RQ125 RQ13.1 RQ15.1 RQ20.1 RQ20.2 RQ20.3 RQ20.4 RQ215 RQ230 RQ235 RQ240 RQ35.1 RQ39.1 RQ39.2 RQ39.3 RQ40.1 RQ42.1 RQ44.1 RQ44.2 RQ50.1 RQ500 RQ961 RQ964 SEA3.1 SA04.1 SA100 SA110 SA250 SA251 SA252 SA253 SA254 SA255 SA256 SA258 SA300 SA80.3 SA90.3 SAA2.1 WH110 WH120 WH126 WH130 WH132 WH140 WH190 WH20.1 WH20.2 WH20.3 WH20.4 WH20.5 WH20.6 WH20.7 WH210 WH22.1 WH220 WH221 WH222 WH224 WH225 WH226 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 WH34.5 WH40.1 WH40.2 WH520 WH830 WH961 WO10.1 WO120 WO130 WO131 WO132 WO133 WO140 WO20.1 WO215 WO220 WO232 WO235 WO250 WO251 WO252 WO255 WO256 WO30.1 WO30.2 WO300 WO32.1 WO32.2 WO32.3 WO32.4 WO32.5 WO35.1 WO40.1 WO40.2 WO40.3 WO40.4 WO40.5 WO40.6 WO41.1 WO41.2 WO41.3 WO41.4 WO42.1 WO42.2 WO42.3 WO42.4 WO42.5 WO45.1 WO510 WO80.1 WO81.1 WO81.2 WO82.1 WOA2.1 WOEX.1 WOSP.1 IC08.1 IC07.1 IC06.1 RQ250 IC05.1 IC14.1 UPDATED BY IC10.2 IC11.1 IC18.1 IC60.1 IC62.1 IC811 IC965 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY ITE-ITEM-GROUP Alpha 5 IC10.2 IC11.1 Item Group This field contains the identifier for IC811 IC965 a group of items that can be shared by one or more companies. ITE-ITEM Alpha 32 IC10.2 IC11.1 Item Number This field contains the item identifier. IC811 IC965 ITE-DESCRIPTION Alpha 30 (Lower Case) BL241 BL243 Description This field contains the first line of BL341 BL42.1 the description. IC10.2 IC11.1 IC270 IC811 IC965 OE114 OE130 OE287 OE293 OE330 PO28.1 PO60.1 PO63.1 PO85.1 SA04.1 SA258 WH110 WH126 WH130 WH132 WH20.2 WH221 WH222 WH224 WH226 WH520 WO132 ITE-DESCRIPTION2 Alpha 30 (Lower Case) BL241 BL243 Second Description This field contains the second line of IC10.2 IC11.1 the description. IC270 IC811 IC965 PO26.1 PO28.1 PO85.1 WH110 WH130 WH226 ITE-STOCK-UOM Alpha 4 IC10.2 IC11.1 Stocking Unit of This is the stock unit of measure for IC811 IC965 Measure the item. OE130 OE230 WH110 WH130 WH132 WH20.7 WH520 ITE-SEC-UOM Alpha 4 IC11.1 IC811 Secondary Unit of This field contains the secondary IC965 Measure quantity unit of measure. ITE-SEC-UOM-MULT Signed 13.7 IC11.1 IC811 Secondary UOM This field contains the multiplier for IC965 Multiplier the secondary quantity unit of measure. It is used to convert the stock-on-hand quantity to the secondary quantity or visa versa. This field is calculated using the secondary conversion factor. ITE-SEC-UOM-CONV Signed 10.5 IC11.1 IC811 Secondary UOM This field contains the secondary unit IC965 ConversionFactor of measure conversion factor. ITE-CTW-CODE Alpha 1 IC10.2 IC11.1 Catch Weight Code This field indicates whether this item IC811 IC965 is a catch weight item. A catch weight PO32.3 PO33.2 item tracks two quantities with two PO34.2 PO60.1 different units of measure. The first PO63.1 quantity is the stock quantity (for catch weights this would be pounds). The second quantity is the secondary quantity (for example, case). This field controls when both quantities are entered. N = Not a catch weight item. A = All transactions require both. I = Enter secondary qty at issue. R = Enter secondary qty at receipt ITE-CTW-VAR-PCT Signed 5.2 IC10.2 IC11.1 Catch Weight This field contains the catch weight IC811 IC965 Variance Percent variance percent. It is used to give a warning message if the stock and secondary quantities on a catch weight transaction are outside this variance percent. ITE-GENERIC Alpha 10 IC10.2 IC11.1 Generic Name This field contains a user-defined IC811 IC965 general name for an item, used for searching for an item. ITE-FREIGHT-CLASS Alpha 4 IC10.2 IC11.1 Freight Class This field contains the user-defined IC811 IC965 freight classification code. The Warehouse system uses freight classes for bill of lading processing. ITE-PURCH-MAJCL Alpha 4 IC10.2 IC11.1 Major Purchasing This field contains the user-defined IC811 IC965 Class major purchasing class identifier. ITE-PURCH-MINCL Alpha 4 IC10.2 IC11.1 Minor Purchasing This field contains the user-defined IC811 IC965 Class minor purchasing class identifier. ITE-INVEN-MAJCL Alpha 4 IC10.2 IC11.1 Inventory Major This field contains the user-defined IC811 IC965 Class major inventory class code. ITE-INVEN-MINCL Alpha 4 IC10.2 IC11.1 Inventory Minor The user-defined minor inventory class IC811 IC965 Class code within the major class. ITE-SALES-MAJCL Alpha 4 IC10.2 IC11.1 Sales Major Class This field contains the sales major IC811 IC965 class code. ITE-SALES-MINCL Alpha 4 IC10.2 IC11.1 Sales Minor Class This field contains the sales minor IC811 IC965 class code within the major class. ITE-MANUF-CODE Alpha 4 CX205 IC10.2 Manufacturer's Code This field contains a user-defined code IC11.1 IC281 that indicates the manufacturer of an IC521 IC522 item. IC524 IC525 IC526 IC527 IC811 IC965 PO100 PO120 PO123 PO16.1 PO20.1 PO22.3 PO31.1 RQ20.1 RQ20.4 WH130 ITE-MANUF-DIVISION Alpha 4 CX205 IC10.2 Manufacturer's This is a user defined code that IC11.1 IC281 Division indicates which division of a IC521 IC522 manufacturer is tied to an item. IC524 IC525 IC526 IC527 IC811 IC965 PO100 PO120 PO123 PO16.1 PO20.1 PO22.3 PO31.1 RQ20.1 RQ20.4 WH130 ITE-MANUF-NBR Alpha 15 CX205 IC10.2 Manufacturer's Item This is the identifier that the IC11.1 IC281 Number manufacturer has assigned to an item. IC521 IC522 IC524 IC525 IC526 IC527 IC811 IC965 PO100 PO120 PO123 PO16.1 PO20.1 PO22.3 PO31.1 RQ20.1 RQ20.4 WH130 ITE-HAZARD-CODE Alpha 8 IC10.2 IC11.1 Hazard Code This field contains a short code IC811 IC965 describing why an item can be hazardous. ITE-PURCH-TAX-FL Alpha 1 IC10.2 IC11.1 Purchasing Tax Flag This flag specifies if this item is IC811 IC965 taxable when it is purchased. It defaults to No (nontaxable). The value Yes indicates taxable. ITE-PURCH-TAX-CD Alpha 10 IC10.2 IC11.1 Purchasing Tax This code is used to determine if this IC811 IC965 Table Code item is taxable when purchased and to extract tax data from the Tax file based on this tax code. ITE-PROD-TAX-CAT Alpha 15 IC10.2 IC11.1 Product Tax Category This field contains a classification of IC811 IC965 items for determining taxes using the VERTEX system in the Order Entry system. ITE-HARMONIZE-CD Alpha 11 IC10.2 IC11.1 Harmonize Code This field contains the harmonize class IC811 IC965 code. ITE-UPC Alpha 13 IC10.2 IC11.1 Universal Product This field contains the Universal IC811 IC965 Code Product Code (UPC). ITE-WEIGHT Signed 9.3 IC10.2 IC11.1 Unit Weight This field contains the net unit weight IC811 IC965 of the item based on the stock unit of measure. ITE-CUBIC-FEET Signed 9.3 IC10.2 IC11.1 Cubic Feet This field contains the net unit cubic IC811 IC965 measure of the item based on the stock unit of measure. ITE-NBR-DEC-QTY Numeric 1 BL120 BL121 Nbr of Decimals for This field contains the number of BL122 BL290 Quantity decimal places that are entered and BL80.1 IC10.2 displayed for the cost field. IC11.1 IC811 0 = 0 Decimals IC965 OE114 1 = 1 Decimal OE30.3 OE510 2 = 2 Decimals PO32.3 PO33.2 3 = 3 Decimals PO34.2 PO63.1 4 = 4 Decimals PO67.1 SA250 SA251 SA252 SA253 SA254 SA255 SA256 WH130 ITE-NBR-DEC-COST Numeric 1 IC10.2 IC11.1 Number of Decimals This field contains the number of IC811 IC965 for Cost decimal places that are entered and OE30.3 displayed for the unit cost field. 2 = Two decimals 3 = Three decimals 4 = Four decimals 5 = Five decimals 0 = 0 Decimals ITE-NBR-DEC-PRICE Numeric 1 BL120 BL121 Number of Decimals This field contains the number of BL122 BL241 for Price decimal places that are entered and BL290 BL341 displayed for the unit cost field. BL40.1 BL40.2 2 = Two decimals BL40.3 BL80.1 3 = Three decimals IC10.2 IC11.1 4 = Four decimals IC811 IC965 5 = Five decimals OE114 OE30.3 0 = 0 Decimals ITE-LOT-TRACK-FL Alpha 1 IC10.2 IC11.1 Lot Tracking Flag This field contains the lot tracking IC811 IC965 field which indicates whether the item OE114 OE330 is tracked by a lot/sublot number. WH130 N = No Y = Yes ITE-SER-TRACK-FL Alpha 1 IC10.2 IC11.1 Serial Tracking Flag This field determines if the item is to IC811 IC965 be tracked by a serial number. OE114 OE330 I = Issues WH130 N = Not tracked R = Receipts ITE-CERT-REQ-FL Alpha 1 IC10.2 IC11.1 Certification This field indicates whether a IC811 IC965 Required Flag certification is required when this item is purchased. N = No Y = Yes ITE-KIT-ITEM-FL Alpha 1 IC10.2 IC11.1 Kit Item Flag This field indicates whether a kit has IC60.1 IC62.1 been set up for this item. IC811 IC965 N = No Y = Yes ITE-REUSE-FL Alpha 1 IC10.2 IC11.1 Reuse Fl This flag indicates that this item is a IC811 IC965 reusable item. It can be used, then reconditioned and used again. Y = Yes N = No ITE-BRKN-CS-CHRG Alpha 1 IC10.2 IC11.1 Broken Case Charge This flag determines if there is a IC811 IC965 charge to break up a case to satisfy an order in the Order Entry system. ITE-REPLACE-ITEM Alpha 32 IC10.2 IC11.1 Replacement Item This field contains a valid item number IC811 IC965 designated as a replacement for this item. ITE-USER-FIELD1 Alpha 30 IC10.2 IC11.1 Item Mster User This is the first user-defined field. IC811 IC965 Defined Field1 Set up the title of this field in IC00.1 (Corporate Item Group). ITE-USER-FIELD2 Alpha 10 (Lower Case) IC10.2 IC11.1 Item Mster User This is the second user-defined field. IC811 IC965 Defined Field2 It can contain any data the user wants. The title of this field is set up in IC00.1 (Corporate Item Group). ITE-USER-FIELD3 Alpha 10 (Lower Case) IC10.2 IC11.1 Item Mster User This is the third user-defined field. IC811 IC965 Defined Field3 It can contain any data the user wants. The title of this field is set up in IC00.1 (Corporate Item Group). ITE-USER-FIELD4 Alpha 10 (Lower Case) IC10.2 IC11.1 Item Mster User This is the fourth user-defined field. IC811 IC965 Defined Field4 It can contain any data the user wants. The title of this field is set up in IC00.1 (Corporate Item Group). ITE-USER-FIELD5 Alpha 10 (Lower Case) IC10.2 IC11.1 User Mster User This is the fifth user-defined field. IC811 IC965 Defined Field5 It can contain any data the user wants. The title of this field is set up in IC00.1 (Corporate Item Group). ITE-USER-FIELD-N1 Signed 13.5 IC10.2 IC11.1 User Defined This is the first user-defined numeric IC811 IC965 Numeric Field 1 field. It can contain any data the user wants. The title of this field is set up in IC00.1 (Corporate Item Group). ITE-USER-FIELD-N2 Signed 13.5 IC10.2 IC11.1 User Defined This is the second user-defined numeric IC811 IC965 Numeric Field 2 field. It can contain any data the user wants. The title of this field is set up in IC00.1 (Corporate Item Group). ITE-USER-FIELD-N3 Signed 13.5 IC10.2 IC11.1 User Defined This is the third user-defined numeric IC811 IC965 Numeric Field 3 field. It can contain any data the user wants. The title of this field is set up in IC00.1 (Corporate Item Group). ITE-SEQ Numeric 3 IC10.2 IC11.1 Sequence Number This field contains the last sequence IC18.1 IC811 number used for the item comments added IC965 in IC18.1 (Item Comments) for this item. ITE-ADDED-DATE Numeric 8 (yyyymmdd) IC10.2 IC11.1 Date Item was Added This field contains the date the Item IC811 IC965 Master record was originally added in IC11.1 (Item Master) or IC10.1 (Formats). The field defaults to the system date when the record is added. ITE-MSDS-FLAG Alpha 1 IC10.2 IC11.1 Material Safety This field indicates whether this item IC811 IC965 DataSheet Flag requires a Material Safety Data Sheet. N = No Y = Yes ITE-ACTIVE-STATUS Alpha 1 IC10.2 IC11.1 Status This status flag indicates whether this IC811 IC965 item is active or inactive. If inactive, no transactions can be entered using this item, but transactions that are in process can be completed. I = Inactive A = Active ITE-ALT-UOM Alpha 4 Occurs 6 Times IC10.2 IC11.1 Alternate Unit of This field contains the alternate unit IC811 IC965 Measure of measure for this item. ITE-ALT-UOM-CONV Signed 10.5 Occurs 6 Times IC10.2 IC11.1 AlternateUOM This field contains the conversion IC811 IC965 Conversion Factor factor from the alternate unit of measure to the stock unit of measure. ITE-ALT-UOM-MULT Signed 13.7 Occurs 6 Times IC10.2 IC11.1 Alternate UOM This field contains the multiplier for IC811 IC965 Multiplier converting an alternate unit of measure to the stock unit of measure. It is calculated by IC11.1 (Item Master) based on the conversion factor and the relationship between the stock and alternate units of measure. ITE-TRACKING-FL Alpha 1 Occurs 6 Times IC11.1 IC811 Tracking Flag This field indicates whether quantities IC965 are tracked by this alternate unit of measure. ITE-TRANS-FL Alpha 1 Occurs 6 Times IC10.2 IC11.1 Transaction Flag This flag indicates whether this IC811 IC965 alternate unit of measure is valid for inventory transactions. The flag settings consist of the following. Blank = Cannot be used. 1 = Valid. Default on transaction. 2 = Valid. ITE-SELL-FL Alpha 1 Occurs 6 Times IC10.2 IC11.1 Selling Flag This field indicates whether this IC811 IC965 alternate unit of measure is valid for the sell quantity in the Order Entry system. The flag settings consist of the following. Blank = Cannot be used. 1 = Valid. Default on entry. 2 = Valid. ITE-SELL-PRICE-FL Alpha 1 Occurs 6 Times IC10.2 IC11.1 Sell Price Flag This field indicates whether this IC811 IC965 alternate unit of measure is valid for the sell price in the Order Entry system. The flag settings consist of the following. Blank = Cannot be used. 1 = Valid. Default on entry. 2 = Valid. ITE-BUY-FL Alpha 1 Occurs 6 Times IC10.2 IC11.1 Buying Flag This field indicates whether this IC811 IC965 alternate unit of measure is valid for the buy quantity in the Purchase Order system. The flag settings consist of the following. Blank = Cannot be used. 1 = Valid. Default on entry. 2 = Valid. ITE-PACKING-WEIGHT Signed 9.3 Occurs 6 Times IC10.2 IC11.1 Packing Weight This field contains the packed weight IC811 IC965 of an item in the alternate unit of measure. ITE-PACKING-CUBIC Signed 9.3 Occurs 6 Times IC10.2 IC11.1 Packing Cubic This field contains the cubic measure IC811 IC965 of the packed alternate unit of measure. ITE-ALLOC-UOM Derived Allocation Unit of This field is the allocation unit of Measure measure based on whether the item is a catch weight or regular item. ITE-HAZARD-FL Derived Hazard Flag This field is used to display an "X" if the item is hazardous. ITE-DESCRIPTION-15 Derived Description 15 This field is derived from the item description to be used to display a short description when there is not enough room to display the regular description. ITE-TRACK-1 Derived Track 1 This field is used to determine if this item is tracked by more than one unit of measure. ITE-TRACK-2 Derived Track 2 This field is used to determine if this item is tracked by more than one unit of measure. ITE-TRACK-3 Derived Track 3 This field is used to determine if this item is tracked by more than one unit of measure. ITE-TRACK-4 Derived Track 4 This field is used to determine if this item is tracked by more than one unit of measure. ITE-TRACK-5 Derived Track 5 This field is used to determine if this item is tracked by more than one unit of measure. ITE-TRACK-6 Derived Track 6 This field is used to determine if this item is tracked by more than one unit of measure. ITE-VALUE-1 Derived Value 1 This field is used to determine if this item is tracked by this unit of measure. 1 = Tracked by this unit of measure. 0 = Not tracked by this unit of measure. ITE-VALUE-2 Derived Value 2 This field is used to determine if this item is tracked by this unit of measure. 1 = Tracked by this unit of measure. 0 = Not tracked by this unit of measure. ITE-VALUE-3 Derived Value 3 This field is used to determine if this item is tracked by this unit of measure. 1 = Tracked by this unit of measure. 0 = Not tracked by this unit of measure. ITE-VALUE-4 Derived Value 4 This field is used to determine if this item is tracked by this unit of measure. 1 = Tracked by this unit of measure. 0 = Not tracked by this unit of measure. ITE-VALUE-5 Derived Value 5 This field is used to determine if this item is tracked by this unit of measure. 1 = Tracked by this unit of measure. 0 = Not tracked by this unit of measure. ITE-VALUE-6 Derived Value 6 This field is used to determine if this item is tracked by this unit of measure. 1 = Tracked by this unit of measure. 0 = Not tracked by this unit of measure. ITE-MULT-UOMS Derived Mult Uoms This field contains the value of the number of units of measure this item is tracked by. ITE-INSP-REQ-FL Alpha 1 IC11.1 Inspection Required This flag indicates whether this item Flag has to be inspected when received via PO. Y N ITEMMAST FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN ITESET1 ITEM-GROUP AP125 AP126 ITEM AP225 AP226 AP25.1 AP25.2 AP26.1 BL04.1 BL10.1 BL120 BL121 BL122 BL123 BL130 BL140 BL141 BL15.1 BL20.1 BL20.3 BL204 BL21.2 BL21.5 BL210 BL215 BL220 BL230 BL240 BL241 BL243 BL245 ... ITESET2 ITEM-GROUP KeyChange IC30.1 DESCRIPTION ITEM ITESET3 ITEM-GROUP KeyChange IC08.1 IC30.1 GENERIC OE55.2 ITEM ITESET4 ITEM-GROUP KeyChange IC07.1 IC30.1 PURCH-MAJCL SEA1.1 POA2.1 PURCH-MINCL SEA3.1 ITEM ITESET5 ITEM-GROUP KeyChange IC06.1 IC30.1 INVEN-MAJCL SEA1.1 RQ250 INVEN-MINCL SEA3.1 ITEM ITESET6 ITEM-GROUP KeyChange BL85.2 IC05.1 SALES-MAJCL IC30.1 SEA1.1 SALES-MINCL OE55.2 SEA3.1 ITEM SAA2.1 ITESET7 ITEM-GROUP KeyChange IC30.1 USER-FIELD1 ITEM ITESET8 ITEM-GROUP KeyChange IC14.1 POA2.1 MANUF-CODE MANUF-DIVISION MANUF-NBR ITEM ITESET9 ITEM-GROUP Subset BL92.1 IC11.1 UPC Where UPC != Spaces 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 OE510 OE810 OE920 WH20.2 WH20.7 ITEMMAST FILE RELATIONS ONE TO ONE RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Genericname ICGENERIC Required When ITE-GENERIC != Spaces ITE-ITEM-GROUP -> ICG-ITEM-GROUP ITE-GENERIC -> ICG-GENERIC Hazard HAZARD Required When ITE-HAZARD-CODE != Spaces ITE-ITEM-GROUP -> HAZ-ITEM-GROUP ITE-HAZARD-CODE -> HAZ-HAZARD-CODE Icmanfcode ICMANFCODE Required When ITE-MANUF-CODE != Spaces ITE-ITEM-GROUP -> IMC-ITEM-GROUP ITE-MANUF-CODE -> IMC-MANUF-CODE ITE-MANUF-DIVISION -> IMC-MANUF-DIVISION Inventoryclass MINORCL Required When ITE-INVEN-MAJCL != Spaces And ITE-INVEN-MINCL != Spaces ITE-ITEM-GROUP -> MIN-ITEM-GROUP "I" -> MIN-CLASS-TYPE ITE-INVEN-MAJCL -> MIN-MAJOR-CLASS ITE-INVEN-MINCL -> MIN-MINOR-CLASS Itemgroup ITEMGROUP Required ITE-ITEM-GROUP -> ITG-ITEM-GROUP Purchaseclass MINORCL Required When ITE-PURCH-MAJCL != Spaces And ITE-PURCH-MINCL != Spaces ITE-ITEM-GROUP -> MIN-ITEM-GROUP "P" -> MIN-CLASS-TYPE ITE-PURCH-MAJCL -> MIN-MAJOR-CLASS ITE-PURCH-MINCL -> MIN-MINOR-CLASS Replace Item ITEMMAST Required When ITE-REPLACE-ITEM != Spaces ITE-ITEM-GROUP -> ITE-ITEM-GROUP ITE-REPLACE-ITEM -> ITE-ITEM Salesclass MINORCL Required When ITE-SALES-MAJCL != Spaces And ITE-SALES-MINCL != Spaces ITE-ITEM-GROUP -> MIN-ITEM-GROUP "S" -> MIN-CLASS-TYPE ITE-SALES-MAJCL -> MIN-MAJOR-CLASS ITE-SALES-MINCL -> MIN-MINOR-CLASS ITEMMAST FILE RELATIONS ONE TO MANY RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Itemcomments ITCOMMENT Delete Restricted ITE-ITEM-GROUP -> ICO-ITEM-GROUP ITE-ITEM -> ICO-ITEM Spaces -> ICO-LANGUAGE-CODE ICO-SEQ Itemsub ITEMSUB Delete Restricted ITE-ITEM-GROUP -> ITS-ITEM-GROUP ITE-ITEM -> ITS-ITEM ITS-SUB-ITEM Oediagdtl OEDIAGDTL ITE-ITEM -> ODL-ITEM ITE-ITEM-GROUP -> ODL-ITEM-GROUP ODL-DIAGRAM-ID ODL-SEQ-NBR Taxcode TXTAXCODE ITE-PURCH-TAX-CD -> TAC-TAX-CODE TAC-COMPANY |