ITEMMAST – Item Master

System
Inventory Control (IC)
Prefix
ITE
Primary key
ITEM-GROUP, ITEM
Fields
107
Updated by
23 programs
Referenced by
532 programs

ITEMMAST is the Item Master table in Lawson Inventory Control (prefix ITE). It is indexed by ITEM-GROUP, ITEM (ITESET1); alternate indexes: ITESET10, ITESET11, ITESET12, ITESET13, ITESET2, ITESET3, ITESET4, ITESET5 and 4 more. It is related 1:1 to ICGENERIC, HAZARD, ICITEUF, ICMANFCODE, MINORCL, ITEBOD, ITEMGROUP, ICITEMCODE and 2 more and 1:M to ICAUDIT, ICITEMGTIN, ICMXVAL, ITCOMMENT, ITEMSUB, ITEMUPC, ITEMUPN1, ITEMUPN2 and 2 more. It is updated by IC10.2, IC11.1, IC18.1, IC330, IC60.1, IC62.1, IC62.4, IC811 and 15 more and referenced by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 524 more. The table has 107 fields, 13 indexes and 23 documented relations.

About ITEMMAST

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.

Fields (107)

Column = COBOL field name without the ITE- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
ITE-ITEM-GROUP PK
ITEM_GROUP
Alpha 5This field contains the identifier for a group of items that can be shared by one or more companies.IC10.2, IC11.1, IC811, PO150, PO25.6, PO25.7, PO26.4, PO26.5 +3 more
ITE-ITEM PK
ITEM
Alpha 32This field contains the item identifier.IC10.2, IC11.1, IC811, PO150, PO25.6, PO25.7, PO26.4, PO26.5 +3 more
ITE-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)This field contains the first line of the description.IC10.2, IC11.1, IC270, IC330, IC811, PO150, PO25.6, PO25.7 +16 more
ITE-DESCRIPTION2
DESCRIPTION2
Alpha 30 (Lower Case)This field contains the second line of the description.IC10.2, IC11.1, IC270, IC330, IC811, PO150, PO25.6, PO25.7 +9 more
ITE-STOCK-UOM
STOCK_UOM
Alpha 4This field contains the valid stock unit of measure for this item.IC10.2, IC11.1, IC243, IC811, PO150, PO25.6, PO25.7, PO26.4 +8 more
ITE-SEC-UOM
SEC_UOM
Alpha 4This field contains the secondary quantity unit of measure.IC11.1, IC330, IC811
ITE-SEC-UOM-MULT
SEC_UOM_MULT
Signed 13.7This 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.IC11.1, IC811
ITE-SEC-UOM-CONV
SEC_UOM_CONV
Signed 10.5This field contains the secondary unit of measure conversion factor.IC11.1, IC811
ITE-CTW-CODE
CTW_CODE
Alpha 1This 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
IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +6 more
ITE-CTW-VAR-PCT
CTW_VAR_PCT
Signed 5.2This 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.IC10.2, IC11.1, IC330, IC811
ITE-GENERIC
GENERIC
Alpha 10This field contains a user-defined general name for an item, used for searching for an item.IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more
ITE-FREIGHT-CLASS
FREIGHT_CLASS
Alpha 4This field contains the user-defined freight classification code. The Warehouse system uses freight classes for bill of lading processing.IC10.2, IC11.1, IC330, IC811
ITE-PURCH-MAJCL
PURCH_MAJCL
Alpha 4This field contains the user-defined major purchasing class identifier.IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more
ITE-PURCH-MINCL
PURCH_MINCL
Alpha 4This field contains the user-defined minor purchasing class identifier.IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more
ITE-INVEN-MAJCL
INVEN_MAJCL
Alpha 4This field contains the user-defined major inventory class code.IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more
ITE-INVEN-MINCL
INVEN_MINCL
Alpha 4The user-defined minor inventory class code within the major class.IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more
ITE-SALES-MAJCL
SALES_MAJCL
Alpha 4This field contains the sales major class code.IC10.2, IC11.1, IC330, IC811
ITE-SALES-MINCL
SALES_MINCL
Alpha 4This field contains the sales minor class code within the major class.IC10.2, IC11.1, IC330, IC811
ITE-MANUF-CODE
MANUF_CODE
Alpha 4This field contains a user-defined code that indicates the manufacturer of an item.IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more
ITE-MANUF-DIVISION
MANUF_DIVISION
Alpha 4This is a user defined code that indicates which division of a manufacturer is tied to an item.IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more
ITE-MANUF-NBR
MANUF_NBR
Alpha 35This is the identifier that the manufacturer has assigned to an item.IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more
ITE-HAZARD-CODE
HAZARD_CODE
Alpha 8This field contains a short code describing why an item can be hazardous.IC10.2, IC11.1, IC330, IC811
ITE-PURCH-TAX-FL
PURCH_TAX_FL
Alpha 1This 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
IC10.2, IC11.1, IC330, IC811
ITE-PURCH-TAX-CD
PURCH_TAX_CD
Alpha 10This 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.IC10.2, IC11.1, IC330, IC811
ITE-PROD-TAX-CAT
PROD_TAX_CAT
Alpha 15This field contains a classification of items for determining taxes using the VERTEX system in the Order Entry system.IC10.2, IC11.1, IC330, IC811
ITE-HARMONIZE-CD
HARMONIZE_CD
Alpha 11This field contains the harmonize class code.
ITE-WEIGHT
WEIGHT
Signed 9.3This field contains the net unit weight of the item based on the stock unit of measure.IC10.2, IC11.1, IC330, IC811
ITE-CUBIC-FEET
CUBIC_FEET
Signed 9.3This field contains the net unit cubic measure of the item based on the stock unit of measure.IC10.2, IC11.1, IC330, IC811
ITE-NBR-DEC-QTY
NBR_DEC_QTY
Numeric 1This 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
IC10.2, IC11.1, IC330, IC811, PO229, PO32.3, PO63.1, PO67.1 +1 more
ITE-NBR-DEC-COST
NBR_DEC_COST
Numeric 1This 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
IC10.2, IC11.1, IC330, IC811, PO150, PO229, PO25.6, PO25.7 +5 more
ITE-NBR-DEC-PRICE
NBR_DEC_PRICE
Numeric 1This 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
IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more
ITE-LOT-TRACK-FL
LOT_TRACK_FL
Alpha 1This 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
IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more
ITE-SER-TRACK-FL
SER_TRACK_FL
Alpha 1This field determines if the item is to be tracked by a serial number.
  • I Issues
  • N Not tracked
  • R Receipts
IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more
ITE-CERT-REQ-FL
CERT_REQ_FL
Alpha 1This field indicates whether a certification is required when this item is purchased.
  • N No
  • Y Yes
IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more
ITE-KIT-ITEM-FL
KIT_ITEM_FL
Alpha 1This field indicates whether a kit has been set up for this item.
  • N No
  • Y Yes
IC10.2, IC11.1, IC330, IC60.1, IC62.1, IC62.4, IC811
ITE-BRKN-CS-CHRG
BRKN_CS_CHRG
Alpha 1This 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
IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more
ITE-REPLACE-ITEM
REPLACE_ITEM
Alpha 32This field contains a valid item number designated as a replacement for this item.IC10.2, IC11.1, IC330, IC811
ITE-USER-FIELD1
USER_FIELD1
Alpha 30This is the first user-defined field. Set up the title of this field in Corporate Item Group (IC00.1).IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more
ITE-USER-FIELD2
USER_FIELD2
Alpha 30This 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).IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more
ITE-USER-FIELD3
USER_FIELD3
Alpha 30This 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).IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more
ITE-USER-FIELD4
USER_FIELD4
Alpha 30This 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).IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more
ITE-USER-FIELD5
USER_FIELD5
Alpha 30This 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).IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more
ITE-USER-FIELD-N1
USER_FIELD_N1
Signed 18.5This 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).IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more
ITE-USER-FIELD-N2
USER_FIELD_N2
Signed 18.5This 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).IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more
ITE-USER-FIELD-N3
USER_FIELD_N3
Signed 18.5This 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).IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more
ITE-SEQ
SEQ
Numeric 3This field contains the last sequence number used for the item comments added in IC18.1 (Item Comments) for this item.IC10.2, IC11.1, IC18.1, IC811
ITE-ADDED-DATE
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.IC10.2, IC11.1, IC811, PO150, PO25.6, PO25.7, PO26.4, PO26.5 +3 more
ITE-MSDS-FLAG
MSDS_FLAG
Alpha 1This field indicates whether this item requires a Material Safety Data Sheet.
  • N No
  • Y Yes
IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more
ITE-ACTIVE-STATUS
ACTIVE_STATUS
Alpha 1This 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
IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more
ITE-ALT-UOM
ALT_UOM
Alpha 4 Occurs 10 Times ×10This field contains the alternate unit of measure for this item.IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more
ITE-ALT-UOM-CONV
ALT_UOM_CONV
Signed 10.5 Occurs 10 Times ×10This field contains the conversion factor from the alternate unit of measure to the stock unit of measure.IC10.2, IC11.1, IC811, PO150, PO25.6, PO25.7, PO26.4, PO26.5 +3 more
ITE-ALT-UOM-MULT
ALT_UOM_MULT
Signed 13.7 Occurs 10 Times ×10This 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.IC10.2, IC11.1, IC811, PO150, PO25.6, PO25.7, PO26.4, PO26.5 +3 more
ITE-TRACKING-FL
TRACKING_FL
Alpha 1 Occurs 10 Times ×10This field indicates whether quantities are tracked by this alternate unit of measure.
  • X X- Inventory Tracked
IC10.2, IC11.1, IC811, PO150, PO25.6, PO25.7, PO26.4, PO26.5 +4 more
ITE-TRANS-FL
TRANS_FL
Alpha 1 Occurs 10 Times ×10This 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.
  • 9 9-Inactive
IC10.2, IC11.1, IC811, PO150, PO25.6, PO25.7, PO26.4, PO26.5 +3 more
ITE-SELL-FL
SELL_FL
Alpha 1 Occurs 10 Times ×10This 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.
  • 9 9-Inactive
IC10.2, IC11.1, IC811, PO150, PO25.6, PO25.7, PO26.4, PO26.5 +3 more
ITE-SELL-PRICE-FL
SELL_PRICE_FL
Alpha 1 Occurs 10 Times ×10This 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.
  • 9 9-Inactive
IC10.2, IC11.1, IC811, PO150, PO25.6, PO25.7, PO26.4, PO26.5 +3 more
ITE-BUY-FL
BUY_FL
Alpha 1 Occurs 10 Times ×10This 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.
  • 9 9-Inactive
IC10.2, IC11.1, IC811, PO150, PO25.6, PO25.7, PO26.4, PO26.5 +3 more
ITE-PACKING-WEIGHT
PACKING_WEIGHT
Signed 9.3 Occurs 10 Times ×10This field contains the packed weight of an item in the alternate unit of measure.IC10.2, IC11.1, IC330, IC811
ITE-PACKING-CUBIC
PACKING_CUBIC
Signed 9.3 Occurs 10 Times ×10This field contains the cubic measure of the packed alternate unit of measure.IC10.2, IC11.1, IC330, IC811
ITE-USE-IDENTIFIER
USE_IDENTIFIER
Alpha 1
  • D Drugs
  • M Instrument
  • R Reusable
  • P Pharmacy
  • L Implant
  • U Analytics
  • N Narcotic
  • S Dressing
IC10.2, IC11.1, IC330, IC811
ITE-CONSIGNMENT-FL
CONSIGNMENT_FL
Alpha 1The 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
IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more
ITE-UPC-EXISTS
UPC_EXISTS
Numeric 1This is a flag to indicate that UPC numbers exist for this item.
  • 0 No
  • 1 Yes
ICI4.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8, PO28.2 +2 more
ITE-UPN1-EXISTS
UPN1_EXISTS
Numeric 1This is a flag to indicate that UPN1 numbers exist for this item.
  • 0 No
  • 1 Yes
ICI5.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8, PO28.2 +2 more
ITE-UPN2-EXISTS
UPN2_EXISTS
Numeric 1This is a flag to indicate that UPN2 numbers exist for this item.
  • 0 No
  • 1 Yes
ICI6.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8, PO28.2 +2 more
ITE-SKU-EXISTS
SKU_EXISTS
Numeric 1This is a flag to indicate that SKU numbers exist for this item.
  • 0 No
  • 1 Yes
ICI7.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8, PO28.2 +2 more
ITE-NDC-EXISTS
NDC_EXISTS
Numeric 1This is a flag to indicate that NDC numbers exist for this item.
  • 0 No
  • 1 Yes
ICIC.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8, PO28.2 +2 more
ITE-INSP-REQ-FL
INSP_REQ_FL
Alpha 1
  • N No
  • Y Yes
IC10.2, IC330, IC811
ITE-ICN-CODE
ICN_CODE
Alpha 8ICN 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.IC10.2, IC11.1, IC330, IC811
ITE-ICSEGMENT
ICSEGMENT
Alpha 2IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more
ITE-ICFAMILY
ICFAMILY
Alpha 2IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more
ITE-ICCLASS
ICCLASS
Alpha 2IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more
ITE-ICCOMMODITY
ICCOMMODITY
Alpha 2IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more
ITE-ISS-ACCOUNT
ISS_ACCOUNT
Numeric 6This 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".IC10.2, IC11.1, IC330, IC811
ITE-ISS-SUB-ACCT
ISS_SUB_ACCT
Numeric 4This 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".IC10.2, IC11.1, IC330, IC811
ITE-CAP-TECH-FLAG
CAP_TECH_FLAG
Numeric 1
  • 0 None
  • 1 Capital
  • 2 Technical
  • 3 Both
ITE-IC-OBJ-ID
IC_OBJ_ID
Numeric 12This 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.IC10.2, IC11.1, IC811, PO150, PO25.6, PO25.7, PO26.4, PO26.5 +3 more
ITE-COMMODITY-CODE
COMMODITY_CODE
Alpha 35IC11.1, IC811, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO28.2 +2 more
ITE-ALLOC-UOM
ALLOC_UOM
DerivedThis field is the allocation unit of measure based on whether the item is a catch weight or regular item.
ITE-HAZARD-FL
HAZARD_FL
DerivedThis field is used to display an "X" if the item is hazardous.
ITE-TRACK-1
TRACK_1
DerivedThis field is used to determine if this item is tracked by more than one unit of measure.
ITE-TRACK-2
TRACK_2
DerivedThis field is used to determine if this item is tracked by more than one unit of measure.
ITE-TRACK-3
TRACK_3
DerivedThis field is used to determine if this item is tracked by more than one unit of measure.
ITE-TRACK-4
TRACK_4
DerivedThis field is used to determine if this item is tracked by more than one unit of measure.
ITE-TRACK-5
TRACK_5
DerivedThis field is used to determine if this item is tracked by more than one unit of measure.
ITE-TRACK-6
TRACK_6
DerivedThis field is used to determine if this item is tracked by more than one unit of measure.
ITE-VALUE-1
VALUE_1
DerivedThis 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
VALUE_2
DerivedThis 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
VALUE_3
DerivedThis 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
VALUE_4
DerivedThis 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
VALUE_5
DerivedThis 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
VALUE_6
DerivedThis 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
MULT_UOMS
DerivedThis field contains the value of the number of units of measure this item is tracked by.
ITE-ITEM-CODE-USED
ITEM_CODE_USED
Derived
ITE-OE-ALLOW-RTN
OE_ALLOW_RTN
Alpha 1" "
  • Y Yes
  • N No
  • L Limit
IC10.2, IC11.1, IC811
ITE-OE-RTN-DATE
OE_RTN_DATE
Numeric 8 (yyyymmdd)IC10.2, IC11.1, IC811
ITE-CREATED-BY
CREATED_BY
Alpha 10IC10.2, IC11.1, IC811, PO150, PO25.6, PO25.7, PO26.4, PO26.5 +3 more
ITE-LAST-UPDT-DATE
LAST_UPDT_DATE
Numeric 8 (yyyymmdd)IC10.2, IC11.1, IC18.1, IC330, IC60.1, IC62.1, IC62.4, IC811 +15 more
ITE-LAST-UPDT-TIME
LAST_UPDT_TIME
Numeric 8IC10.2, IC11.1, IC18.1, IC330, IC60.1, IC62.1, IC62.4, IC811 +15 more
ITE-LAST-UPDATE-BY
LAST_UPDATE_BY
Alpha 10IC10.2, IC11.1, IC18.1, IC330, IC60.1, IC62.1, IC62.4, IC811 +15 more
ITE-DESCRIPTION3
DESCRIPTION3
Alpha 350 (Lower Case)IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more
ITE-EFFECT-DT
EFFECT_DT
Numeric 8 (yyyymmdd)This is the first date that this item can be used as a Replacement item.IC10.2, IC11.1
ITE-EXPIRE-DT
EXPIRE_DT
Numeric 8 (yyyymmdd)This is the last date that this item can be used as a Replacement item.IC10.2, IC11.1
ITE-CHARGE-NBR
CHARGE_NBR
Alpha 80IC11.1, IC811
ITE-LATEX-IND
LATEX_IND
Numeric 1
  • 0 Unspecified
  • 1 Package indicates Latex
  • 2 Package doesn't indicate Latex
  • 3 Not Applicable
IC11.1, IC811
ITE-HAS-EXP-DT
HAS_EXP_DT
Alpha 1
  • N No
  • Y Yes
IC11.1, IC811
ITE-CHARGEABLE-FL
CHARGEABLE_FL
Alpha 1
  • N No
  • Y Yes
IC11.1, IC811
ITE-HCPCS
HCPCS
Alpha 7IC11.1, IC811

Indexes (13)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ITESET1ITEM-GROUP, ITEMPrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
ITESET10ITEM-GROUP, ICSEGMENT, ICFAMILY, ICCLASS, ICCOMMODITY, ITEMKeyChange, SubsetWhere ICSEGMENT != Spaces And ACTIVE-STATUS = "A"AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
ITESET11ITEM-GROUP, MANUF-NBR, MANUF-CODE, MANUF-DIVISION, ITEMKeyChange, SubsetWhere MANUF-NBR != Spaces And ACTIVE-STATUS = "A"
ITESET12ITEM-GROUP, REPLACE-ITEM, ITEMKeyChange, SubsetWhere REPLACE-ITEM != SpacesIC11.1
ITESET13ITEM-GROUP, DESCRIPTION2, ITEMKeyChange, SubsetWhere DESCRIPTION2 != SpacesIC30.1
ITESET2ITEM-GROUP, DESCRIPTION, ITEMKeyChangeIC30.1
ITESET3ITEM-GROUP, GENERIC, ITEMKeyChange, SubsetWhere GENERIC != Spaces And ACTIVE-STATUS = "A"IC08.1, IC30.1
ITESET4ITEM-GROUP, PURCH-MAJCL, PURCH-MINCL, ITEMKeyChange, SubsetWhere PURCH-MAJCL != Spaces And ACTIVE-STATUS = "A"IC07.1, IC30.1, IC46.1
ITESET5ITEM-GROUP, INVEN-MAJCL, INVEN-MINCL, ITEMKeyChange, SubsetWhere INVEN-MAJCL != Spaces And ACTIVE-STATUS = "A"IC06.1, IC30.1, IC46.1, RQ250
ITESET6ITEM-GROUP, SALES-MAJCL, SALES-MINCL, ITEMKeyChange, SubsetWhere SALES-MAJCL != Spaces And ACTIVE-STATUS = "A"IC05.1, IC30.1, IC46.1
ITESET7ITEM-GROUP, USER-FIELD1, ITEMKeyChange, SubsetWhere USER-FIELD1 != Spaces And ACTIVE-STATUS = "A"IC30.1, IC46.1
ITESET8ITEM-GROUP, MANUF-CODE, MANUF-DIVISION, MANUF-NBR, ITEMKeyChange, SubsetWhere MANUF-CODE != Spaces And ACTIVE-STATUS = "A"IC11.1, IC14.1, IC46.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5 +3 more
ITESET9IC-OBJ-IDKeyChange, SubsetWhere IC-OBJ-ID != ZeroesIC220, IC223, IC231, IC233, IC234, IC243, IC247, IC30.1 +11 more

Relations

One to one (12) — lookups and parents

RelationTableRulesConditionField map
GenericnameICGENERICRequiredWhen ITE-GENERIC != Spaces And ITE-ACTIVE-STATUS = "A"ITE-ITEM-GROUPICG-ITEM-GROUP, ITE-GENERICICG-GENERIC
HazardHAZARDRequiredWhen ITE-HAZARD-CODE != SpacesITE-ITEM-GROUPHAZ-ITEM-GROUP, ITE-HAZARD-CODEHAZ-HAZARD-CODE
IciteufICITEUFNot Required, Delete CascadesITE-ITEM-GROUPUFM-ITEM-GROUP, ITE-ITEMUFM-ITEM
IcmanfcodeICMANFCODERequiredWhen ITE-MANUF-CODE != Spaces And ITE-ACTIVE-STATUS = "A"ITE-ITEM-GROUPIMC-ITEM-GROUP, ITE-MANUF-CODEIMC-MANUF-CODE, ITE-MANUF-DIVISIONIMC-MANUF-DIVISION
InventoryclassMINORCLRequiredWhen ITE-INVEN-MAJCL != Spaces And ITE-ACTIVE-STATUS = "A"ITE-ITEM-GROUPMIN-ITEM-GROUP, "I"MIN-CLASS-TYPE, ITE-INVEN-MAJCLMIN-MAJOR-CLASS, ITE-INVEN-MINCLMIN-MINOR-CLASS
ItebodITEBODNot RequiredValid When IBA- = ITE-ITE-ITEM-GROUPIBA-ITEM-GROUP, ITE-ITEMIBA-ITEM
ItemgroupITEMGROUPRequiredITE-ITEM-GROUPITG-ITEM-GROUP
ItemtoitemcodeICITEMCODENot RequiredITE-ITEM-GROUPIIC-ITEM-GROUP, ITE-ICSEGMENTIIC-ICSEGMENT, ITE-ICFAMILYIIC-ICFAMILY, ITE-ICCLASSIIC-ICCLASS, ITE-ICCOMMODITYIIC-ICCOMMODITY
ProcuregrpPROCUREGRPRequiredITE-ITEM-GROUPPCG-ITEM-GROUP
PurchaseclassMINORCLRequiredWhen ITE-PURCH-MAJCL != Spaces And ITE-ACTIVE-STATUS = "A"ITE-ITEM-GROUPMIN-ITEM-GROUP, "P"MIN-CLASS-TYPE, ITE-PURCH-MAJCLMIN-MAJOR-CLASS, ITE-PURCH-MINCLMIN-MINOR-CLASS
Replace ItemITEMMASTRequiredWhen ITE-REPLACE-ITEM != SpacesITE-ITEM-GROUPITE-ITEM-GROUP, ITE-REPLACE-ITEMITE-ITEM
SalesclassMINORCLRequiredWhen ITE-SALES-MAJCL != Spaces And ITE-ACTIVE-STATUS = "A"ITE-ITEM-GROUPMIN-ITEM-GROUP, "S"MIN-CLASS-TYPE, ITE-SALES-MAJCLMIN-MAJOR-CLASS, ITE-SALES-MINCLMIN-MINOR-CLASS

One to many (11) — child tables

RelationTableRulesConditionField map
IcauditICAUDITITE-ITEM-GROUPIAU-ITEM-GROUP, ZeroesIAU-COMPANY, SpacesIAU-LOCATION, ITE-ITEMIAU-ITEM, IAU-GL-CATEGORY, IAU-DATE, IAU-TIME, IAU-FLD-NBR
IcitemgtinICITEMGTINITE-ITEM-GROUPGTI-ITEM-GROUP, ITE-ITEMGTI-ITEM, GTI-GTIN
IcmxvalICMXVALDelete CascadesITE-IC-OBJ-IDIMV-IC-OBJ-ID, IMV-MATRIX-CAT
ItemcommentsITCOMMENTDelete RestrictedITE-ITEM-GROUPICO-ITEM-GROUP, ITE-ITEMICO-ITEM, ICO-LANGUAGE-CODE, ICO-SEQ
ItemcompanionITEMSUBITE-ITEM-GROUPITS-ITEM-GROUP, ITE-ITEMITS-ITEM, "C"ITS-SUBTYPE, ITS-SUB-ITEM
ItemsubITEMSUBITE-ITEM-GROUPITS-ITEM-GROUP, ITE-ITEMITS-ITEM, "S"ITS-SUBTYPE, ITS-SUB-ITEM
ItemtoupcITEMUPCITE-ITEM-GROUPIPC-ITEM-GROUP, ITE-ITEMIPC-ITEM, IPC-UPC
Itemtoupn1ITEMUPN1ITE-ITEM-GROUPIPN-ITEM-GROUP, ITE-ITEMIPN-ITEM, IPN-UPN-NBR
Itemtoupn2ITEMUPN2ITE-ITEM-GROUPIP2-ITEM-GROUP, ITE-ITEMIP2-ITEM, IP2-UPN2-NBR
PoitemvenPOITEMVENPCG-PROCURE-GROUPPIV-PROCURE-GROUP, ITE-ITEMPIV-ITEM, PIV-VENDOR, PIV-VEN-ITEM
TaxcodeTXTAXCODEITE-PURCH-TAX-CDTAC-TAX-CODE, TAC-COMPANY

Programs

Updated by (23)

Referenced by (532)