ITEMMAST

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 AP510 API1.1
API2.1 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 IC02.1 IC110 IC12.1 IC12.2
IC120 IC125 IC13.1 IC130 IC134 IC135
IC138 IC140 IC141 IC142 IC143 IC145
IC15.2 IC150 IC151 IC152 IC170 IC175
IC179 IC182 IC183 IC19.1 IC190 IC191
IC192 IC195 IC20.1 IC20.2 IC21.1 IC21.2
IC21.5 IC210 IC211 IC212 IC213 IC216
IC218 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 IC231 IC232 IC233 IC234
IC235 IC237 IC238 IC239 IC24.1 IC24.2
IC240 IC241 IC242 IC243 IC244 IC247
IC25.1 IC250 IC26.1 IC26.2 IC260 IC262
IC266 IC27.1 IC270 IC28.1 IC280 IC281
IC282 IC283 IC285 IC287 IC29.1 IC29.2
IC29.3 IC295 IC30.1 IC30.2 IC31.1 IC320
IC331 IC36.1 IC38.1 IC40.1 IC40.2 IC41.1
IC42.1 IC42.2 IC42.3 IC42.4 IC43.1 IC44.1
IC45.1 IC46.1 IC47.1 IC48.1 IC49.1 IC50.1
IC50.2 IC500 IC503 IC51.1 IC511 IC512
IC519 IC52.1 IC520 IC521 IC522 IC523
IC524 IC525 IC526 IC527 IC53.1 IC55.1
IC55.2 IC550 IC56.1 IC56.2 IC56.4 IC56.3
IC574 IC58.1 IC589 IC59.1 IC590 IC598
IC61.1 IC64.1 IC64.2 IC64.3 IC64.4 IC64.5
IC64.6 IC64.7 IC64.8 IC64.9 IC65.1 IC66.1
IC67.1 IC68.1 IC68.2 IC68.3 IC70.1 IC72.1
IC73.1 IC74.1 IC76.1 IC800 IC81.1 IC81.2
IC812 IC82.1 IC820 IC83.1 IC84.1 IC84.2
IC840 IC850 IC851 IC90.1 IC91.1 IC91.2
IC95.1 IC95.2 IC95.3 IC95.4 ICBL.1 ICBL.2
ICBL.4 ICI1.1 ICI8.1 ICI9.1 ICIA.1 ICIT.1
PC10.1 PC120 PC190 PC20.1 PC540 PC810
PC90.1 MX123 MX500 MA180 MA236 MA278
MA41.1 MA41.2 MA41.4 MA41.7 MA42.1 MA42.2
MA43.1 MA43.2 MA43.3 MA43.7 MA44.1 MA44.2
MA53.1 MA53.5 MA53.7 MA530 MA531 MA540
MA60.2 MA60.3 MA60.5 MA61.1 MA63.1 MA64.6
MA65.1 MA66.2 MA66.3 MA66.8 MA67.2 MA67.3
MA68.2 MA68.3 MA68.5 MA69.1 MA69.2 MA70.1
MA75.1 MA80.1 MA90.2 MA90.3 MA90.4 MAI1.1
PD10.1 PD10.2 PD130 PD20.1 PD20.2 PD20.3
PD570 PO04.1 PO04.2 PO10.1 PO10.2 PO100
PO101 PO115 PO120 PO122 PO125 PO13.1
PO13.3 PO130 PO131 PO132 PO133 PO135
PO136 PO137 PO139 PO15.1 PO15.2 PO15.4
PO16.1 PO16.2 PO17.1 PO190 PO192 PO20.1
PO20.6 PO20.7 PO20.9 PO204 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO213 PO215 PO216
PO22.1 PO22.2 PO22.3 PO22.4 PO22.5 PO220
PO222 PO223 PO224 PO225 PO227 PO228
PO229 PO23.1 PO23.6 PO23.7 PO230 PO233
PO234 PO24.1 PO251 PO253 PO254 PO27.2
PO27.3 PO27.4 PO274 PO275 PO276 PO277
PO278 PO280 PO29.1 PO295 PO30.1 PO30.2
PO30.3 PO30.4 PO300 PO31.1 PO31.2 PO32.1
PO32.2 PO32.3 PO32.4 PO33.1 PO34.1 PO35.1
PO38.1 PO39.1 PO39.2 PO44.1 PO45.1 PO50.1
PO52.1 PO520 PO53.2 PO53.8 PO54.1 PO54.2
PO54.3 PO54.4 PO54.5 PO550 PO560 PO63.1
PO64.1 PO67.1 PO69.1 PO813 PO94.1 POAP.1
POCP.1 POI3.1 POI6.1 POI7.1 POID.1 POIE.1
POIH.1 POII.1 POIJ.1 POIM.1 MM280 MM80.1
MM80.2 RQ01.1 RQ10.1 RQ10.2 RQ10.3 RQ10.4
RQ10.5 RQ11.1 RQ11.3 RQ11.4 RQ11.5 RQ111
RQ12.1 RQ13.1 RQ13.2 RQ140 RQ230 RQ235
RQ250 RQ260 RQ270 RQ35.1 RQ39.1 RQ39.2
RQ39.3 RQ40.1 RQ41.1 RQ42.1 RQ44.1 RQ44.2
RQ50.1 RQ500 RQ810 RQCP.1 RQD0.1 RQD1.1
RQIB.1 RQIC.1 RQID.1 RQIF.1 RQIG.1 RQIH.1
RQII.1 RQIJ.1 WH110 WH120 WH126 WH130
WH132 WH140 WH190 WH20.1 WH20.2 WH20.3
WH20.4 WH20.5 WH20.6 WH20.7 WH21.1 WH21.2
WH21.3 WH21.4 WH210 WH22.1 WH220 WH221
WH222 WH224 WH225 WH226 WH25.1 WH25.2
WH30.1 WH30.2 WH30.3 WH30.4 WH31.1 WH31.2
WH31.3 WH31.4 WH32.1 WH32.2 WH32.3 WH32.4
WH32.5 WH33.1 WH33.2 WH33.3 WH33.4 WH33.5
WH33.6 WH33.8 WH33.9 WH34.1 WH34.2 WH34.3
WH34.4 WH34.5 WH40.1 WH40.2 WH520 WH830
WHD2.1 IC16.1 IC516 PO983 IC08.1 IC07.1
IC06.1 IC05.1 IC14.1 MX223


UPDATED BY
IC10.2 IC11.1 IC18.1 IC330 IC60.1 IC62.1
IC62.4 IC811 ICI4.1 ICI5.1 ICI6.1 ICI7.1
ICIC.1 PO150 PO25.6 PO25.7 PO26.4 PO26.5
PO26.8 PO28.2 PO36.2 PO536 WHD3.1

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.
IC10.2 IC11.1
IC811 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
ITE-ITEM
Element: Item		Alpha 32
This field contains the item identifier.
IC10.2 IC11.1
IC811 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
ITE-DESCRIPTION
Element: 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
PO253 PO26.4
PO26.5 PO28.2
PO36.2 PO536
PO63.1 WH110
WH126 WH132
WH20.2 WH221
WH222 WH224
WH226 WH520
ITE-DESCRIPTION2
Element: Description		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
PO26.1 PO26.4
PO26.5 PO28.2
PO36.2 PO536
POIE.1 WH110
WH226
ITE-STOCK-UOM
Element: Uom		Alpha 4
This field contains the valid stock unit of measure for this item.
IC10.2 IC11.1
IC243 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
WH110 WH132
WH20.7 WH520
ITE-SEC-UOM
Element: Uom		Alpha 4
This field contains the secondary quantity unit of measure.
IC11.1 IC330
IC811
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.
IC11.1 IC811
ITE-SEC-UOM-CONV
Element: Alt Uom Conv		Signed 10.5
This field contains the secondary unit of measure conversion factor.
IC11.1 IC811
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
IC10.2 IC11.1
IC330 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO32.3 PO36.2
PO536 PO63.1
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.
IC10.2 IC11.1
IC330 IC811
ITE-GENERIC
Element: Generic		Alpha 10
This 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
PO26.5 PO28.2
PO36.2 PO536
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.
IC10.2 IC11.1
IC330 IC811
ITE-PURCH-MAJCL
Element: Major Class		Alpha 4
This field contains the user-defined major purchasing class identifier.
IC10.2 IC11.1
IC330 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
ITE-PURCH-MINCL
Element: Minor Class		Alpha 4
This field contains the user-defined minor purchasing class identifier.
IC10.2 IC11.1
IC330 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
ITE-INVEN-MAJCL
Element: Major Class		Alpha 4
This field contains the user-defined major inventory class code.
IC10.2 IC11.1
IC330 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
ITE-INVEN-MINCL
Element: Minor Class		Alpha 4
The user-defined minor inventory class code within the major class.
IC10.2 IC11.1
IC330 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
ITE-SALES-MAJCL
Element: Major Class		Alpha 4
This field contains the sales major class code.
IC10.2 IC11.1
IC330 IC811
ITE-SALES-MINCL
Element: Minor Class		Alpha 4
This field contains the sales minor class code within the major class.
IC10.2 IC11.1
IC330 IC811
ITE-MANUF-CODE
Element: Manuf Code		Alpha 4
This 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
PO26.5 PO28.2
PO36.2 PO536
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.
IC10.2 IC11.1
IC330 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
ITE-MANUF-NBR
Element: Manuf Nbr		Alpha 35
This is the identifier that the manufacturer has assigned to an item.
IC10.2 IC11.1
IC330 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
ITE-HAZARD-CODE
Element: Hazard Code		Alpha 8
This field contains a short code describing why an item can be hazardous.
IC10.2 IC11.1
IC330 IC811
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
IC10.2 IC11.1
IC330 IC811
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.
IC10.2 IC11.1
IC330 IC811
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.
IC10.2 IC11.1
IC330 IC811
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.
IC10.2 IC11.1
IC330 IC811
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.
IC10.2 IC11.1
IC330 IC811
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
IC10.2 IC11.1
IC330 IC811
PO229 PO32.3
PO63.1 PO67.1
WH130
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
IC10.2 IC11.1
IC330 IC811
PO150 PO229
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
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
IC10.2 IC11.1
IC330 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
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
IC10.2 IC11.1
IC330 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
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
IC10.2 IC11.1
IC330 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
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
IC10.2 IC11.1
IC330 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
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
IC10.2 IC11.1
IC330 IC60.1
IC62.1 IC62.4
IC811
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
IC10.2 IC11.1
IC330 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
ITE-REPLACE-ITEM
Element: Item		Alpha 32
This field contains a valid item number designated as a replacement for this item.
IC10.2 IC11.1
IC330 IC811
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).
IC10.2 IC11.1
IC330 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
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).
IC10.2 IC11.1
IC330 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
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).
IC10.2 IC11.1
IC330 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
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).
IC10.2 IC11.1
IC330 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
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).
IC10.2 IC11.1
IC330 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
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).
IC10.2 IC11.1
IC330 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
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).
IC10.2 IC11.1
IC330 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
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).
IC10.2 IC11.1
IC330 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
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.
IC10.2 IC11.1
IC18.1 IC811
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.
IC10.2 IC11.1
IC811 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
ITE-MSDS-FLAG
Element: All Flag		Alpha 1
This 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
PO26.5 PO28.2
PO36.2 PO536
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
IC10.2 IC11.1
IC330 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
ITE-ALT-UOM
Element: Uom		Alpha 4 Occurs 10 Times
This field contains the alternate unit of measure for this item.
IC10.2 IC11.1
IC330 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
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.
IC10.2 IC11.1
IC811 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
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.
IC10.2 IC11.1
IC811 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
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
IC10.2 IC11.1
IC811 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536 WHD3.1
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.
9 = 9-Inactive
IC10.2 IC11.1
IC811 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
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.
9 = 9-Inactive
IC10.2 IC11.1
IC811 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
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.
9 = 9-Inactive
IC10.2 IC11.1
IC811 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
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.
9 = 9-Inactive
IC10.2 IC11.1
IC811 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
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.
IC10.2 IC11.1
IC330 IC811
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.
IC10.2 IC11.1
IC330 IC811
ITE-USE-IDENTIFIER
Element: 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
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
IC10.2 IC11.1
IC330 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
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
ICI4.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO26.8 PO28.2
PO36.2 PO536
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
ICI5.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO26.8 PO28.2
PO36.2 PO536
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
ICI6.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO26.8 PO28.2
PO36.2 PO536
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
ICI7.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO26.8 PO28.2
PO36.2 PO536
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
ICIC.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO26.8 PO28.2
PO36.2 PO536
ITE-INSP-REQ-FL
Element: All Flag		Alpha 1

N = No
Y = Yes
IC10.2 IC330
IC811
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.
IC10.2 IC11.1
IC330 IC811
ITE-ICSEGMENT
Element: Icsegment		Alpha 2
IC10.2 IC11.1
IC330 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
ITE-ICFAMILY
Element: Icfamily		Alpha 2
IC10.2 IC11.1
IC330 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
ITE-ICCLASS
Element: Icclass		Alpha 2
IC10.2 IC11.1
IC330 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
ITE-ICCOMMODITY
Element: Iccommodity		Alpha 2
IC10.2 IC11.1
IC330 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
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".
IC10.2 IC11.1
IC330 IC811
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".
IC10.2 IC11.1
IC330 IC811
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.
IC10.2 IC11.1
IC811 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
ITE-COMMODITY-CODE
Element: Commodity Code		Alpha 35
IC11.1 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
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
IC10.2 IC11.1
IC811
ITE-OE-RTN-DATE
Element: Date		Numeric 8 (yyyymmdd)
IC10.2 IC11.1
IC811
ITE-CREATED-BY
Element: Operator		Alpha 10
IC10.2 IC11.1
IC811 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
ITE-LAST-UPDT-DATE
Element: Date		Numeric 8 (yyyymmdd)
IC10.2 IC11.1
IC18.1 IC330
IC60.1 IC62.1
IC62.4 IC811
ICI4.1 ICI5.1
ICI6.1 ICI7.1
ICIC.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO26.8 PO28.2
PO36.2 PO536
WHD3.1
ITE-LAST-UPDT-TIME
Element: Time		Numeric 8
IC10.2 IC11.1
IC18.1 IC330
IC60.1 IC62.1
IC62.4 IC811
ICI4.1 ICI5.1
ICI6.1 ICI7.1
ICIC.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO26.8 PO28.2
PO36.2 PO536
WHD3.1
ITE-LAST-UPDATE-BY
Element: Operator		Alpha 10
IC10.2 IC11.1
IC18.1 IC330
IC60.1 IC62.1
IC62.4 IC811
ICI4.1 ICI5.1
ICI6.1 ICI7.1
ICIC.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO26.8 PO28.2
PO36.2 PO536
WHD3.1
ITE-DESCRIPTION3
Element: Description3		Alpha 350 (Lower Case)
IC10.2 IC11.1
IC330 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
ITE-EFFECT-DT
Element: Date		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
Element: Date		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
Element: A4comp Name		Alpha 80
IC11.1 IC811
ITE-LATEX-IND
Element: Boolean		Numeric 1

0 = Unspecified
1 = Package indicates Latex
2 = Package doesn't indicate Latex
3 = Not Applicable
IC11.1 IC811
ITE-HAS-EXP-DT
Element: Flag		Alpha 1

N = No
Y = Yes
IC11.1 IC811
ITE-CHARGEABLE-FL
Element: Flag		Alpha 1

N = No
Y = Yes
IC11.1 IC811
ITE-HCPCS
Element: Tax Off Ref		Alpha 7
IC11.1 IC811


ITEMMAST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ITESET1 ITEM-GROUP
ITEM
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX05.1
CX05.2 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX205 CX220
CX30.1 CX300
ITESET10 ITEM-GROUP
ICSEGMENT
ICFAMILY
ICCLASS
ICCOMMODITY
ITEM
KeyChange, Subset
WhereICSEGMENT !=Spaces
AndACTIVE-STATUS ="A"
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
ITESET11 ITEM-GROUP
MANUF-NBR
MANUF-CODE
MANUF-DIVISION
ITEM
KeyChange, Subset
WhereMANUF-NBR !=Spaces
AndACTIVE-STATUS ="A"
ITESET12 ITEM-GROUP
REPLACE-ITEM
ITEM
KeyChange, Subset
WhereREPLACE-ITEM !=Spaces
IC11.1
ITESET13 ITEM-GROUP
DESCRIPTION2
ITEM
KeyChange, Subset
WhereDESCRIPTION2 !=Spaces
IC30.1
ITESET2 ITEM-GROUP
DESCRIPTION
ITEM
KeyChange
IC30.1
ITESET3 ITEM-GROUP
GENERIC
ITEM
KeyChange, Subset
WhereGENERIC !=Spaces
AndACTIVE-STATUS ="A"
IC08.1 IC30.1
ITESET4 ITEM-GROUP
PURCH-MAJCL
PURCH-MINCL
ITEM
KeyChange, Subset
WherePURCH-MAJCL !=Spaces
AndACTIVE-STATUS ="A"
IC07.1 IC30.1
IC46.1
ITESET5 ITEM-GROUP
INVEN-MAJCL
INVEN-MINCL
ITEM
KeyChange, Subset
WhereINVEN-MAJCL !=Spaces
AndACTIVE-STATUS ="A"
IC06.1 IC30.1
IC46.1 RQ250
ITESET6 ITEM-GROUP
SALES-MAJCL
SALES-MINCL
ITEM
KeyChange, Subset
WhereSALES-MAJCL !=Spaces
AndACTIVE-STATUS ="A"
IC05.1 IC30.1
IC46.1
ITESET7 ITEM-GROUP
USER-FIELD1
ITEM
KeyChange, Subset
WhereUSER-FIELD1 !=Spaces
AndACTIVE-STATUS ="A"
IC30.1 IC46.1
ITESET8 ITEM-GROUP
MANUF-CODE
MANUF-DIVISION
MANUF-NBR
ITEM
KeyChange, Subset
WhereMANUF-CODE !=Spaces
AndACTIVE-STATUS ="A"
IC11.1 IC14.1
IC46.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
ITESET9 IC-OBJ-ID
KeyChange, Subset
WhereIC-OBJ-ID !=Zeroes
IC220 IC223
IC231 IC233
IC234 IC243
IC247 IC30.1
IC55.1 IC55.2
IC56.3 IC56.4
ICBL.1 ICBL.2
ICBL.4 MX123
MX223 MX500
PO253


ITEMMAST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Genericname ICGENERIC Required
When ITE-GENERIC !=Spaces
AndITE-ACTIVE-STATUS ="A"
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
Iciteuf ICITEUF Not Required, Delete Cascades
ITE-ITEM-GROUP->UFM-ITEM-GROUP
ITE-ITEM->UFM-ITEM
Icmanfcode ICMANFCODE Required
When ITE-MANUF-CODE !=Spaces
AndITE-ACTIVE-STATUS ="A"
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
AndITE-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
Itebod ITEBOD Not Required
Valid When IBA- =ITE-
ITE-ITEM-GROUP->IBA-ITEM-GROUP
ITE-ITEM->IBA-ITEM
Itemgroup ITEMGROUP Required
ITE-ITEM-GROUP->ITG-ITEM-GROUP
Itemtoitemcode ICITEMCODE Not Required
ITE-ITEM-GROUP->IIC-ITEM-GROUP
ITE-ICSEGMENT->IIC-ICSEGMENT
ITE-ICFAMILY->IIC-ICFAMILY
ITE-ICCLASS->IIC-ICCLASS
ITE-ICCOMMODITY->IIC-ICCOMMODITY
Procuregrp PROCUREGRP Required
ITE-ITEM-GROUP->PCG-ITEM-GROUP
Purchaseclass MINORCL Required
When ITE-PURCH-MAJCL !=Spaces
AndITE-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 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
AndITE-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


ITEMMAST FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Icaudit ICAUDIT
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
Icitemgtin ICITEMGTIN
ITE-ITEM-GROUP->GTI-ITEM-GROUP
ITE-ITEM->GTI-ITEM
  GTI-GTIN
Icmxval ICMXVAL Delete Cascades
ITE-IC-OBJ-ID->IMV-IC-OBJ-ID
  IMV-MATRIX-CAT
Itemcomments ITCOMMENT Delete Restricted
ITE-ITEM-GROUP->ICO-ITEM-GROUP
ITE-ITEM->ICO-ITEM
  ICO-LANGUAGE-CODE
  ICO-SEQ
Itemcompanion ITEMSUB
ITE-ITEM-GROUP->ITS-ITEM-GROUP
ITE-ITEM->ITS-ITEM
"C"->ITS-SUBTYPE
  ITS-SUB-ITEM
Itemsub ITEMSUB
ITE-ITEM-GROUP->ITS-ITEM-GROUP
ITE-ITEM->ITS-ITEM
"S"->ITS-SUBTYPE
  ITS-SUB-ITEM
Itemtoupc ITEMUPC
ITE-ITEM-GROUP->IPC-ITEM-GROUP
ITE-ITEM->IPC-ITEM
  IPC-UPC
Itemtoupn1 ITEMUPN1
ITE-ITEM-GROUP->IPN-ITEM-GROUP
ITE-ITEM->IPN-ITEM
  IPN-UPN-NBR
Itemtoupn2 ITEMUPN2
ITE-ITEM-GROUP->IP2-ITEM-GROUP
ITE-ITEM->IP2-ITEM
  IP2-UPN2-NBR
Poitemven POITEMVEN
PCG-PROCURE-GROUP->PIV-PROCURE-GROUP
ITE-ITEM->PIV-ITEM
  PIV-VENDOR
  PIV-VEN-ITEM
Taxcode TXTAXCODE
ITE-PURCH-TAX-CD->TAC-TAX-CODE
  TAC-COMPANY

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

Home
Contact Us



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