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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 SET2
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 SET13
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 SET3
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 SET4
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 SET4
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 SET5
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 SET5
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 SET6
SALES_MAJCL		Alpha 4This field contains the sales major class code.IC10.2, IC11.1, IC330, IC811
#ITE-SALES-MINCL SET6
SALES_MINCL		Alpha 4This field contains the sales minor class code within the major class.IC10.2, IC11.1, IC330, IC811
#ITE-MANUF-CODE SET11 SET8
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 SET11 SET8
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 SET11 SET8
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 SET12
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 SET7
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 SET10
ICSEGMENT		Alpha 2—IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more
#ITE-ICFAMILY SET10
ICFAMILY		Alpha 2—IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more
#ITE-ICCLASS SET10
ICCLASS		Alpha 2—IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more
#ITE-ICCOMMODITY SET10
ICCOMMODITY		Alpha 2—IC10.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 SET9
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 35—IC11.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 10—IC10.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 8—IC10.2, IC11.1, IC18.1, IC330, IC60.1, IC62.1, IC62.4, IC811 +15 more
#ITE-LAST-UPDATE-BY
LAST_UPDATE_BY		Alpha 10—IC10.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 80—IC11.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 7—IC11.1, IC811

Indexes (13)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ITESET1
  1. ITEM-GROUP
  2. ITEM
PrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
ITESET10
  1. ITEM-GROUP
  2. ICSEGMENT
  3. ICFAMILY
  4. ICCLASS
  5. ICCOMMODITY
  6. ITEM
KeyChange, 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)
ITESET11
  1. ITEM-GROUP
  2. MANUF-NBR
  3. MANUF-CODE
  4. MANUF-DIVISION
  5. ITEM
KeyChange, SubsetWhere MANUF-NBR != Spaces And ACTIVE-STATUS = "A"—
ITESET12
  1. ITEM-GROUP
  2. REPLACE-ITEM
  3. ITEM
KeyChange, SubsetWhere REPLACE-ITEM != SpacesIC11.1
ITESET13
  1. ITEM-GROUP
  2. DESCRIPTION2
  3. ITEM
KeyChange, SubsetWhere DESCRIPTION2 != SpacesIC30.1
ITESET2
  1. ITEM-GROUP
  2. DESCRIPTION
  3. ITEM
KeyChangeIC30.1
ITESET3
  1. ITEM-GROUP
  2. GENERIC
  3. ITEM
KeyChange, SubsetWhere GENERIC != Spaces And ACTIVE-STATUS = "A"IC08.1, IC30.1
ITESET4
  1. ITEM-GROUP
  2. PURCH-MAJCL
  3. PURCH-MINCL
  4. ITEM
KeyChange, SubsetWhere PURCH-MAJCL != Spaces And ACTIVE-STATUS = "A"IC07.1, IC30.1, IC46.1
ITESET5
  1. ITEM-GROUP
  2. INVEN-MAJCL
  3. INVEN-MINCL
  4. ITEM
KeyChange, SubsetWhere INVEN-MAJCL != Spaces And ACTIVE-STATUS = "A"IC06.1, IC30.1, IC46.1, RQ250
ITESET6
  1. ITEM-GROUP
  2. SALES-MAJCL
  3. SALES-MINCL
  4. ITEM
KeyChange, SubsetWhere SALES-MAJCL != Spaces And ACTIVE-STATUS = "A"IC05.1, IC30.1, IC46.1
ITESET7
  1. ITEM-GROUP
  2. USER-FIELD1
  3. ITEM
KeyChange, SubsetWhere USER-FIELD1 != Spaces And ACTIVE-STATUS = "A"IC30.1, IC46.1
ITESET8
  1. ITEM-GROUP
  2. MANUF-CODE
  3. MANUF-DIVISION
  4. MANUF-NBR
  5. ITEM
KeyChange, 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
ITESET9
  1. IC-OBJ-ID
KeyChange, SubsetWhere IC-OBJ-ID != ZeroesIC220, IC223, IC231, IC233, IC234, IC243, IC247, IC30.1 +11 more

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ICGENERICHAZARDICITEUFICMANFCODEMINORCLITEBODITEMGROUPICITEMCODEPROCUREGRPITEMMASTICAUDITICITEMGTINICMXVALITCOMMENTITEMSUBITEMUPCITEMUPN1ITEMUPN2POITEMVENTXTAXCODEITEMMAST

One to one (12) — lookups and parents

RelationTableRulesConditionField map
GenericnameICGENERICRequiredWhen ITE-GENERIC != Spaces And ITE-ACTIVE-STATUS = "A"
ITE-ITEM-GROUP→ICG-ITEM-GROUP
ITE-GENERIC→ICG-GENERIC
HazardHAZARDRequiredWhen ITE-HAZARD-CODE != Spaces
ITE-ITEM-GROUP→HAZ-ITEM-GROUP
ITE-HAZARD-CODE→HAZ-HAZARD-CODE
IciteufICITEUFNot Required, Delete Cascades
ITE-ITEM-GROUP→UFM-ITEM-GROUP
ITE-ITEM→UFM-ITEM
IcmanfcodeICMANFCODERequiredWhen ITE-MANUF-CODE != Spaces And ITE-ACTIVE-STATUS = "A"
ITE-ITEM-GROUP→IMC-ITEM-GROUP
ITE-MANUF-CODE→IMC-MANUF-CODE
ITE-MANUF-DIVISION→IMC-MANUF-DIVISION
InventoryclassMINORCLRequiredWhen ITE-INVEN-MAJCL != Spaces And ITE-ACTIVE-STATUS = "A"
ITE-ITEM-GROUP→MIN-ITEM-GROUP
"I"→MIN-CLASS-TYPE
ITE-INVEN-MAJCL→MIN-MAJOR-CLASS
ITE-INVEN-MINCL→MIN-MINOR-CLASS
ItebodITEBODNot RequiredValid When IBA- = ITE-
ITE-ITEM-GROUP→IBA-ITEM-GROUP
ITE-ITEM→IBA-ITEM
ItemgroupITEMGROUPRequired
ITE-ITEM-GROUP→ITG-ITEM-GROUP
ItemtoitemcodeICITEMCODENot Required
ITE-ITEM-GROUP→IIC-ITEM-GROUP
ITE-ICSEGMENT→IIC-ICSEGMENT
ITE-ICFAMILY→IIC-ICFAMILY
ITE-ICCLASS→IIC-ICCLASS
ITE-ICCOMMODITY→IIC-ICCOMMODITY
ProcuregrpPROCUREGRPRequired
ITE-ITEM-GROUP→PCG-ITEM-GROUP
PurchaseclassMINORCLRequiredWhen ITE-PURCH-MAJCL != Spaces And ITE-ACTIVE-STATUS = "A"
ITE-ITEM-GROUP→MIN-ITEM-GROUP
"P"→MIN-CLASS-TYPE
ITE-PURCH-MAJCL→MIN-MAJOR-CLASS
ITE-PURCH-MINCL→MIN-MINOR-CLASS
Replace ItemITEMMASTRequiredWhen ITE-REPLACE-ITEM != Spaces
ITE-ITEM-GROUP→ITE-ITEM-GROUP
ITE-REPLACE-ITEM→ITE-ITEM
SalesclassMINORCLRequiredWhen ITE-SALES-MAJCL != Spaces And ITE-ACTIVE-STATUS = "A"
ITE-ITEM-GROUP→MIN-ITEM-GROUP
"S"→MIN-CLASS-TYPE
ITE-SALES-MAJCL→MIN-MAJOR-CLASS
ITE-SALES-MINCL→MIN-MINOR-CLASS

One to many (11) — child tables

RelationTableRulesConditionField map
IcauditICAUDIT
ITE-ITEM-GROUP→IAU-ITEM-GROUP
Zeroes→IAU-COMPANY
Spaces→IAU-LOCATION
ITE-ITEM→IAU-ITEM
—→IAU-GL-CATEGORY
—→IAU-DATE
—→IAU-TIME
—→IAU-FLD-NBR
IcitemgtinICITEMGTIN
ITE-ITEM-GROUP→GTI-ITEM-GROUP
ITE-ITEM→GTI-ITEM
—→GTI-GTIN
IcmxvalICMXVALDelete Cascades
ITE-IC-OBJ-ID→IMV-IC-OBJ-ID
—→IMV-MATRIX-CAT
ItemcommentsITCOMMENTDelete Restricted
ITE-ITEM-GROUP→ICO-ITEM-GROUP
ITE-ITEM→ICO-ITEM
—→ICO-LANGUAGE-CODE
—→ICO-SEQ
ItemcompanionITEMSUB
ITE-ITEM-GROUP→ITS-ITEM-GROUP
ITE-ITEM→ITS-ITEM
"C"→ITS-SUBTYPE
—→ITS-SUB-ITEM
ItemsubITEMSUB
ITE-ITEM-GROUP→ITS-ITEM-GROUP
ITE-ITEM→ITS-ITEM
"S"→ITS-SUBTYPE
—→ITS-SUB-ITEM
ItemtoupcITEMUPC
ITE-ITEM-GROUP→IPC-ITEM-GROUP
ITE-ITEM→IPC-ITEM
—→IPC-UPC
Itemtoupn1ITEMUPN1
ITE-ITEM-GROUP→IPN-ITEM-GROUP
ITE-ITEM→IPN-ITEM
—→IPN-UPN-NBR
Itemtoupn2ITEMUPN2
ITE-ITEM-GROUP→IP2-ITEM-GROUP
ITE-ITEM→IP2-ITEM
—→IP2-UPN2-NBR
PoitemvenPOITEMVEN
PCG-PROCURE-GROUP→PIV-PROCURE-GROUP
ITE-ITEM→PIV-ITEM
—→PIV-VENDOR
—→PIV-VEN-ITEM
TaxcodeTXTAXCODE
ITE-PURCH-TAX-CD→TAC-TAX-CODE
—→TAC-COMPANY

Programs

Updated by (23)

Referenced by (532)