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	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	API2.1
ICI1.1	ICI9.1	ICIT.1	MA41.1	MA41.2	MA41.4
MA41.7	MA43.1	MA43.2	MA43.3	MA43.4	MA43.6
MA43.7	MA540	MAI1.1	PO136	PO15.1	PO15.2
PO15.4	PO190	PO215	PO300	PO520	PO53.2
PO53.8	PO64.1	POCP.1	POI3.1	POI6.1	POI7.1
POIH.1	POII.1	POIJ.1	POIM.1	MM280	RQ50.1
MX223

UPDATED BY

MX123

MX500

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
ITE-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.
ITE-ITEM Element: Item	Alpha 32 This field contains the item identifier.
ITE-DESCRIPTION Element: Item Description	Alpha 30 (Lower Case) This field contains the first line of the description.
ITE-DESCRIPTION2 Element: Description	Alpha 30 (Lower Case) This field contains the second line of the description.
ITE-STOCK-UOM Element: Uom	Alpha 4 This field contains the valid stock unit of measure for this item.
ITE-SEC-UOM Element: Uom	Alpha 4 This field contains the secondary quantity unit of measure.
ITE-SEC-UOM-MULT Element: Uom Mult	Signed 13.7 This field contains the multiplier for 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 Element: Alt Uom Conv	Signed 10.5 This field contains the secondary unit of measure conversion factor.
ITE-CTW-CODE Element: Ctw Code	Alpha 1 This field indicates whether this item is a catch weight item. A catch weight item tracks two quantities with two different units of measure. The first 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 Both Qty's at Issue R = Enter Both Qty's at Receipt
ITE-CTW-VAR-PCT Element: Ctw Var Pct	Signed 5.2 This field contains the catch weight 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 Element: Generic	Alpha 10 This field contains a user-defined general name for an item, used for searching for an item.
ITE-FREIGHT-CLASS Element: Freight Class	Alpha 4 This field contains the user-defined freight classification code. The Warehouse system uses freight classes for bill of lading processing.
ITE-PURCH-MAJCL Element: Major Class	Alpha 4 This field contains the user-defined major purchasing class identifier.
ITE-PURCH-MINCL Element: Minor Class	Alpha 4 This field contains the user-defined minor purchasing class identifier.
ITE-INVEN-MAJCL Element: Major Class	Alpha 4 This field contains the user-defined major inventory class code.
ITE-INVEN-MINCL Element: Minor Class	Alpha 4 The user-defined minor inventory class code within the major class.
ITE-SALES-MAJCL Element: Major Class	Alpha 4 This field contains the sales major class code.
ITE-SALES-MINCL Element: Minor Class	Alpha 4 This field contains the sales minor class code within the major class.
ITE-MANUF-CODE Element: Manuf Code	Alpha 4 This field contains a user-defined code that indicates the manufacturer of an item.
ITE-MANUF-DIVISION Element: Manuf Division	Alpha 4 This is a user defined code that indicates which division of a manufacturer is tied to an item.
ITE-MANUF-NBR Element: Manuf Nbr	Alpha 35 This is the identifier that the manufacturer has assigned to an item.
ITE-HAZARD-CODE Element: Hazard Code	Alpha 8 This field contains a short code describing why an item can be hazardous.
ITE-PURCH-TAX-FL Element: Purch Tax Fl	Alpha 1 This flag specifies if this item is taxable when it is purchased. It defaults to No (nontaxable). The value Yes indicates taxable. " " = Default to Next Level N = No Y = Yes
ITE-PURCH-TAX-CD Element: Tax Code	Alpha 10 This code is used to determine if this item is taxable when purchased and to extract tax data from the Tax file based on this tax code.
ITE-PROD-TAX-CAT Element: Prod Tax Cat	Alpha 15 This field contains a classification of items for determining taxes using the VERTEX system in the Order Entry system.
ITE-HARMONIZE-CD Element: Harmonize Cd	Alpha 11 This field contains the harmonize class code.
ITE-WEIGHT Element: Weight	Signed 9.3 This field contains the net unit weight of the item based on the stock unit of measure.
ITE-CUBIC-FEET Element: Cubic Feet	Signed 9.3 This field contains the net unit cubic measure of the item based on the stock unit of measure.
ITE-NBR-DEC-QTY Element: Nbr Dec Qty	Numeric 1 This field contains the number of decimal places that are entered and displayed for the cost field. 0 = 0 Decimals 1 = 1 Decimal 2 = 2 Decimals 3 = 3 Decimals 4 = 4 Decimals
ITE-NBR-DEC-COST Element: Nbr Dec Cost	Numeric 1 This field contains the number of decimal places that are entered and displayed for the unit cost field. 0 = No Decimals 1 = One Decimal 2 = Two decimals 3 = Three Decimals 4 = Four decimals 5 = Five decimals
ITE-NBR-DEC-PRICE Element: Nbr Dec Cost	Numeric 1 This field contains the number of decimal places that are entered and displayed for the unit cost field. 0 = No Decimals 1 = One Decimal 2 = Two Decimals 3 = Three Decimals 4 = Four Decimals 5 = Five Decimals
ITE-LOT-TRACK-FL Element: All Flag	Alpha 1 This field contains the lot tracking field which indicates whether the item is tracked by a lot/sublot number. I = Issues N = Not tracked R = Receipts
ITE-SER-TRACK-FL Element: Ser Track Fl	Alpha 1 This field determines if the item is to be tracked by a serial number. I = Issues N = Not tracked R = Receipts
ITE-CERT-REQ-FL Element: Cert Req Fl	Alpha 1 This field indicates whether a certification is required when this item is purchased. N = No Y = Yes
ITE-KIT-ITEM-FL Element: All Flag	Alpha 1 This field indicates whether a kit has been set up for this item. N = No Y = Yes
ITE-BRKN-CS-CHRG Element: Brkn Cs Chrg	Alpha 1 This flag determines if there is a charge to break up a case to satisfy an order in the Order Entry system. Y = Yes N = No
ITE-REPLACE-ITEM Element: Item	Alpha 32 This field contains a valid item number designated as a replacement for this item.
ITE-USER-FIELD1 Element: User Field1	Alpha 30 This is the first user-defined field. Set up the title of this field in Corporate Item Group (IC00.1).
ITE-USER-FIELD2 Element: User Field2	Alpha 30 This is the second user-defined field. It can contain any data the user wants. The title of this field is set up in Corporate Item Group (IC00.1).
ITE-USER-FIELD3 Element: User Field2	Alpha 30 This is the third user-defined field. It can contain any data the user wants. The title of this field is set up in Corporate Item Group (IC00.1).
ITE-USER-FIELD4 Element: User Field2	Alpha 30 This is the fourth user-defined field. It can contain any data the user wants. The title of this field is set up in Corporate Item Group (IC00.1).
ITE-USER-FIELD5 Element: User Field2	Alpha 30 This is the fifth user-defined field. It can contain any data the user wants. The title of this field is set up in Corporate Item Group (IC00.1).
ITE-USER-FIELD-N1 Element: Intl Cost	Signed 18.5 This is the first user-defined numeric field. It can contain any data the user wants. The title of this field is set up in Corporate Item Group (IC00.1).
ITE-USER-FIELD-N2 Element: Intl Cost	Signed 18.5 This is the second user-defined numeric field. It can contain any data the user wants. The title of this field is set up in Corporate Item Group (IC00.1).
ITE-USER-FIELD-N3 Element: Intl Cost	Signed 18.5 This is the third user-defined numeric field. It can contain any data the user wants. The title of this field is set up in Corporate Item Group (IC00.1).
ITE-SEQ Element: Seq	Numeric 3 This field contains the last sequence number used for the item comments added in IC18.1 (Item Comments) for this item.
ITE-ADDED-DATE Element: Added Date	Numeric 8 (yyyymmdd) This field contains the date the Item 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 Element: All Flag	Alpha 1 This field indicates whether this item requires a Material Safety Data Sheet. N = No Y = Yes
ITE-ACTIVE-STATUS Element: Active Status	Alpha 1 This status flag indicates whether this 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 Element: Uom	Alpha 4 Occurs 10 Times This field contains the alternate unit of measure for this item.
ITE-ALT-UOM-CONV Element: Alt Uom Conv	Signed 10.5 Occurs 10 Times This field contains the conversion factor from the alternate unit of measure to the stock unit of measure.
ITE-ALT-UOM-MULT Element: Uom Mult	Signed 13.7 Occurs 10 Times This field contains the multiplier for 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 Element: All Flag	Alpha 1 Occurs 10 Times This field indicates whether quantities are tracked by this alternate unit of measure. X = X- Inventory Tracked
ITE-TRANS-FL Element: Trans Fl	Alpha 1 Occurs 10 Times This flag indicates whether this 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 Element: Account Flag	Alpha 1 Occurs 10 Times This field indicates whether this 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 Element: Account Flag	Alpha 1 Occurs 10 Times This field indicates whether this 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 Element: Buy Fl	Alpha 1 Occurs 10 Times This field indicates whether this 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 Element: Weight	Signed 9.3 Occurs 10 Times This field contains the packed weight of an item in the alternate unit of measure.
ITE-PACKING-CUBIC Element: Cubic Feet	Signed 9.3 Occurs 10 Times This field contains the cubic measure of the packed alternate unit of measure.
ITE-USE-IDENTIFIER Element: Use Identifier	Alpha 1 D = Drugs M = Instrument R = Reusable P = Pharmacy L = Implant U = Analytics N = Narcotic
ITE-CONSIGNMENT-FL Element: Consignment Fl	Alpha 1 The consignment flag set to Y indicates that this item is not to be counted as part of the owned inventory. It will default to N and will be defaulted to the ITEMLOC record with the same flag. N = No Y = Yes
ITE-UPC-EXISTS Element: Upc Exists	Numeric 1 This is a flag to indicate that UPC numbers exist for this item. 0 = No 1 = Yes
ITE-UPN1-EXISTS Element: Upn1 Exists	Numeric 1 This is a flag to indicate that UPN1 numbers exist for this item. 0 = No 1 = Yes
ITE-UPN2-EXISTS Element: Upn2 Exists	Numeric 1 This is a flag to indicate that UPN2 numbers exist for this item. 0 = No 1 = Yes
ITE-SKU-EXISTS Element: Sku Exists	Numeric 1 This is a flag to indicate that SKU numbers exist for this item. 0 = No 1 = Yes
ITE-NDC-EXISTS Element: Ndc Exists	Numeric 1 This is a flag to indicate that NDC numbers exist for this item. 0 = No 1 = Yes
ITE-INSP-REQ-FL Element: All Flag	Alpha 1 N = No Y = Yes
ITE-ICN-CODE Element: Icn Code	Alpha 8 ICN stands for Intrastat Classification Nomenclature. ICN code is a combination of the 2-digit Harmonize System Chapter code, 2-digit Harmonize Heading, 2-digit Harmonize Subheading, and 2-digit combined nomenclature code. The Harmonize System of classification codes is designed to identify items for international trade. The ICN code entered on Item Master (IC11.1) will be validated against the code listing in ICN and Unit of Measure Codes (IN03.1). When a code is added there will also be a check to make sure there is an alternate UOM defined for the item that is associated with the code in Intrastat.
ITE-ICSEGMENT Element: Icsegment	Alpha 2
ITE-ICFAMILY Element: Icfamily	Alpha 2
ITE-ICCLASS Element: Icclass	Alpha 2
ITE-ICCOMMODITY Element: Iccommodity	Alpha 2
ITE-ISS-ACCOUNT Element: Account	Numeric 6 This is a default account number for issues to requisitions and purchase orders. This field will eliminate the need to create item location records pertaining to non-stock items for the purpose of defaulting an "issue account number".
ITE-ISS-SUB-ACCT Element: Sub Acct	Numeric 4 This is the default sub account number for issues. Will be used as a default to issues, requisitions and purchase-orders. Will eliminate the need to create item-location records pertaining to non-stock items for the purpose of defaulting a "issue account number".
ITE-CAP-TECH-FLAG Element: Cap Tech Flag	Numeric 1 0 = None 1 = Capital 2 = Technical 3 = Both
ITE-IC-OBJ-ID Element: Obj Id	Numeric 12 This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.
ITE-COMMODITY-CODE Element: Commodity Code	Alpha 35
ITE-ALLOC-UOM Element: Alloc Uom	Derived This field is the allocation unit of measure based on whether the item is a catch weight or regular item.
ITE-HAZARD-FL Element: Hazard Fl	Derived This field is used to display an "X" if the item is hazardous.
ITE-TRACK-1 Element: Track 1	Derived This field is used to determine if this item is tracked by more than one unit of measure.
ITE-TRACK-2 Element: Track 2	Derived This field is used to determine if this item is tracked by more than one unit of measure.
ITE-TRACK-3 Element: Track 3	Derived This field is used to determine if this item is tracked by more than one unit of measure.
ITE-TRACK-4 Element: Track 4	Derived This field is used to determine if this item is tracked by more than one unit of measure.
ITE-TRACK-5 Element: Track 5	Derived This field is used to determine if this item is tracked by more than one unit of measure.
ITE-TRACK-6 Element: Track 6	Derived This field is used to determine if this item is tracked by more than one unit of measure.
ITE-VALUE-1 Element: Value 1	Derived 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 Element: Value 2	Derived 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 Element: Value 3	Derived 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 Element: Value 4	Derived 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 Element: Value 5	Derived 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 Element: Value 6	Derived 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 Element: Mult Uoms	Derived This field contains the value of the number of units of measure this item is tracked by.
ITE-ITEM-CODE-USED Element: Item Code Used	Derived
ITE-OE-ALLOW-RTN Element: All Flag	Alpha 1 " " Y = Yes N = No L = Limit
ITE-OE-RTN-DATE Element: Date	Numeric 8 (yyyymmdd)

ITEMMAST FILE INDEX

ITEMMAST FILE RELATIONS

ONE TO ONE RELATIONS

ITEMMAST FILE RELATIONS

ONE TO MANY RELATIONS

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