|
ITEMMAST FILE
Item Master
The Item Master file stores static information about each item. Every item
has one Item Master record which contains data such as description, classes,
units of measure, and weight. This data is shared by all Item Location records
for this item.
REFERENCED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.4 API1.1 CXCP.1 DR100
DR25.1 DR40.1 DR42.1 IC00.1 IC110 IC12.1
IC12.2 IC120 IC125 IC13.1 IC130 IC134
IC135 IC138 IC140 IC141 IC142 IC143
IC145 IC150 IC151 IC152 IC170 IC175
IC179 IC182 IC183 IC19.1 IC190 IC191
IC192 IC20.1 IC20.2 IC21.1 IC21.2 IC210
IC211 IC212 IC213 IC219 IC22.1 IC22.2
IC220 IC221 IC222 IC223 IC224 IC225
IC226 IC227 IC228 IC229 IC23.1 IC23.2
IC23.3 IC23.4 IC23.5 IC230 IC232 IC233
IC234 IC237 IC238 IC239 IC24.1 IC24.2
IC240 IC241 IC242 IC243 IC244 IC25.1
IC26.1 IC26.2 IC260 IC262 IC27.1 IC270
IC28.1 IC280 IC281 IC282 IC283 IC285
IC287 IC29.1 IC29.2 IC29.3 IC295 IC30.1
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 IC51.1 IC519
IC52.1 IC520 IC521 IC522 IC523 IC524
IC525 IC526 IC527 IC53.1 IC530 IC531
IC55.1 IC55.2 IC550 IC574 IC589 IC59.1
IC590 IC598 IC61.1 IC65.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 IC95.1 IC95.2 IC95.3 ICI1.1
ICI8.1 ICIT.1 PC10.1 PC120 PC20.1 PC540
PC810 SEA1.1 MA180 MA236 MA278 MA41.1
MA41.2 MA41.7 MA43.1 MA43.2 MA43.3 MA43.9
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 MA67.1 MA67.2 MA70.1 MA75.1
MA80.1 MAI1.1 PO100 PO101 PO115 PO122
PO125 PO13.1 PO130 PO131 PO132 PO133
PO135 PO136 PO137 PO139 PO15.1 PO15.2
PO16.1 PO16.2 PO190 PO20.1 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO213 PO215 PO216
PO22.1 PO220 PO223 PO224 PO225 PO227
PO228 PO229 PO23.1 PO23.6 PO23.7 PO230
PO233 PO26.1 PO27.2 PO274 PO275 PO276
PO277 PO28.1 PO280 PO29.1 PO295 PO30.1
PO30.2 PO30.3 PO300 PO31.1 PO31.2 PO32.1
PO32.2 PO32.3 PO33.1 PO34.1 PO35.1 PO38.1
PO39.1 PO39.2 PO44.1 PO45.1 PO50.1 PO52.1
PO520 PO54.4 PO550 PO560 PO63.1 PO64.1
PO67.1 PO72.1 PO813 PO94.1 POAP.1 POI3.1
POI6.1 POI7.1 POID.1 POIE.1 POIH.1 POII.1
POIJ.1 MM280 MM80.1 MM80.2 RQ10.1 RQ10.2
RQ10.3 RQ11.1 RQ111 RQ12.1 RQ13.1 RQ140
RQ230 RQ235 RQ250 RQ35.1 RQ39.1 RQ39.2
RQ39.3 RQ40.1 RQ42.1 RQ44.1 RQ44.2 RQ50.1
RQ500 RQ780 RQCP.1 RQD0.1 RQD1.1 RQIC.1
RQID.1 RQIE.1 RQIF.1 RQIG.1 RQIH.1 RQIJ.1
SEA3.1 SEA4.1 WH110 WH120 WH126 WH130
WH132 WH140 WH190 WH20.1 WH20.2 WH20.3
WH20.4 WH20.5 WH20.6 WH20.7 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 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 WO10.1 WO120 WO130 WO131 WO132
WO133 WO140 WO20.1 WO215 WO220 WO232
WO235 WO250 WO251 WO252 WO255 WO256
WO280 WO30.1 WO30.2 WO300 WO32.1 WO32.2
WO32.3 WO32.4 WO32.5 WO35.1 WO40.1 WO40.2
WO40.3 WO40.4 WO40.5 WO40.6 WO41.1 WO41.2
WO41.3 WO41.4 WO42.1 WO42.2 WO42.3 WO42.4
WO42.5 WO45.1 WO510 WO80.1 WO81.1 WO81.2
WO82.1 WOD1.1 WOEX.1 WOSP.1 IC16.1 IC516
IC08.1 IC07.1 IC06.1 IC05.1 IC14.1
UPDATED BY
IC10.2 IC11.1 IC18.1 IC330 IC60.1 IC62.1
IC811 ICI4.1 ICI5.1 ICI6.1 ICI7.1 PO150
PO25.6 PO25.7 PO36.2 PO536 PO737 WHD3.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ITE-ITEM-GROUP Alpha 5 IC10.2 IC11.1
Element: Item Group This field contains the identifier for IC811 PO150
a group of items that can be shared by PO25.6 PO25.7
one or more companies. PO36.2 PO536
ITE-ITEM Alpha 32 IC10.2 IC11.1
Element: Item Number This field contains the item IC811 PO150
identifier. PO25.6 PO25.7
PO36.2 PO536
ITE-DESCRIPTION Alpha 30 (Lower Case) IC10.2 IC11.1
Element: Description This field contains the first line of IC270 IC330
the description. IC811 PO150
PO25.6 PO25.7
PO36.2 PO536
PO63.1 WH110
WH126 WH132
WH20.2 WH221
WH222 WH224
WH226 WH520
WO132 WO280
ITE-DESCRIPTION2 Alpha 30 (Lower Case) IC10.2 IC11.1
Element: Description This field contains the second line of IC270 IC330
the description. IC811 PO150
PO25.6 PO25.7
PO26.1 PO36.2
PO536 POIE.1
WH110 WH226
ITE-STOCK-UOM Alpha 4 IC10.2 IC11.1
Element: Unit of Measure IC243 IC811
PO150 PO25.6
PO25.7 PO36.2
PO536 WH110
WH132 WH20.7
WH520
ITE-SEC-UOM Alpha 4 IC11.1 IC811
Element: Unit of MeasurThis field contains the secondary
quantity unit of measure.
ITE-SEC-UOM-MULT Signed 13.7 IC11.1 IC811
Unit of Measure This field contains the multiplier for
Multiplier the secondary quantity unit of measure.
It is used to convert the stock-on-hand
quantity to the secondary quantity or
visa versa. This field is calculated
using the secondary conversion factor.
ITE-SEC-UOM-CONV Signed 10.5 IC11.1 IC811
AlternateUOM This field contains the secondary unit
Conversion Factor of measure conversion factor.
ITE-CTW-CODE Alpha 1 IC10.2 IC11.1
Element: Catch Weight CThis field indicates whether this item IC330 IC811
is a catch weight item. A catch weight PO150 PO25.6
item tracks two quantities with two PO25.7 PO32.3
different units of measure. The first PO36.2 PO536
quantity is the stock quantity (for PO63.1
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 Signed 5.2 IC10.2 IC11.1
Element: Bus Percent This field contains the catch weight IC330 IC811
variance percent. It is used to give a
warning message if the stock and
secondary quantities on a catch weight
transaction are outside this variance
percent.
ITE-GENERIC Alpha 10 IC10.2 IC11.1
Element: Generic Name This field contains a user-defined IC330 IC811
general name for an item, used for PO150 PO25.6
searching for an item. PO25.7 PO36.2
PO536
ITE-FREIGHT-CLASS Alpha 4 IC10.2 IC11.1
Element: Freight Class This field contains the user-defined IC330 IC811
freight classification code. The
Warehouse system uses freight classes
for bill of lading processing.
ITE-PURCH-MAJCL Alpha 4 IC10.2 IC11.1
Element: Major Class This field contains the user-defined IC330 IC811
major purchasing class identifier. PO150 PO25.6
PO25.7 PO36.2
PO536
ITE-PURCH-MINCL Alpha 4 IC10.2 IC11.1
Element: Minor Class This field contains the user-defined IC330 IC811
minor purchasing class identifier. PO150 PO25.6
PO25.7 PO36.2
PO536
ITE-INVEN-MAJCL Alpha 4 IC10.2 IC11.1
Element: Major Class This field contains the user-defined IC330 IC811
major inventory class code. PO150 PO25.6
PO25.7 PO36.2
PO536
ITE-INVEN-MINCL Alpha 4 IC10.2 IC11.1
Element: Minor Class The user-defined minor inventory class IC330 IC811
code within the major class. PO150 PO25.6
PO25.7 PO36.2
PO536
ITE-SALES-MAJCL Alpha 4 IC10.2 IC11.1
Element: Major Class This field contains the sales major IC330 IC811
class code.
ITE-SALES-MINCL Alpha 4 IC10.2 IC11.1
Element: Minor Class This field contains the sales minor IC330 IC811
class code within the major class.
ITE-MANUF-CODE Alpha 4 IC10.2 IC11.1
Element: Manufacturer'sThis field contains a user-defined code IC330 IC811
that indicates the manufacturer of an PO150 PO25.6
item. PO25.7 PO36.2
PO536
ITE-MANUF-DIVISION Alpha 4 IC10.2 IC11.1
Manufacturer's This is a user defined code that IC330 IC811
Division indicates which division of a PO150 PO25.6
manufacturer is tied to an item. PO25.7 PO36.2
PO536
ITE-MANUF-NBR Alpha 15 IC10.2 IC11.1
Manufacturer's Item This is the identifier that the IC330 IC811
Number manufacturer has assigned to an item. PO150 PO25.6
PO25.7 PO36.2
PO536 PO737
ITE-HAZARD-CODE Alpha 8 IC10.2 IC11.1
Element: Hazard Code This field contains a short code IC330 IC811
describing why an item can be hazardous.
ITE-PURCH-TAX-FL Alpha 1 IC10.2 IC11.1
Element: Purchasing TaxThis flag specifies if this item is IC330 IC811
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 Alpha 10 IC10.2 IC11.1
Element: Tax Code This code is used to determine if this IC330 IC811
item is taxable when purchased and to
extract tax data from the Tax file based
on this tax code.
ITE-PROD-TAX-CAT Alpha 15 IC10.2 IC11.1
Element: Product Tax CaThis field contains a classification of IC330 IC811
items for determining taxes using the
VERTEX system in the Order Entry system.
ITE-HARMONIZE-CD Alpha 11
Element: Harmonize CodeThis field contains the harmonize class
code.
ITE-WEIGHT Signed 9.3 IC10.2 IC11.1
Element: Unit Weight This field contains the net unit weight IC330 IC811
of the item based on the stock unit of
measure.
ITE-CUBIC-FEET Signed 9.3 IC10.2 IC11.1
Element: Cubic Feet This field contains the net unit cubic IC330 IC811
measure of the item based on the stock
unit of measure.
ITE-NBR-DEC-QTY Numeric 1 IC10.2 IC11.1
Nbr of Decimals for This field contains the number of IC330 IC811
Quantity decimal places that are entered and PO229 PO230
displayed for the cost field. PO32.3 PO63.1
0 = 0 Decimals PO67.1 WH130
1 = 1 Decimal
2 = 2 Decimals
3 = 3 Decimals
4 = 4 Decimals
ITE-NBR-DEC-COST Numeric 1 IC10.2 IC11.1
Number of Decimals This field contains the number of IC330 IC811
for Cost decimal places that are entered and PO150 PO229
displayed for the unit cost field. PO25.6 PO25.7
0 = No Decimals PO36.2 PO536
1 = One Decimal
2 = Two decimals
3 = Three Decimals
4 = Four decimals
5 = Five decimals
ITE-NBR-DEC-PRICE Numeric 1 IC10.2 IC11.1
Number of Decimals This field contains the number of IC330 IC811
for Cost decimal places that are entered and PO150 PO25.6
displayed for the unit cost field. PO25.7 PO36.2
0 = No Decimals PO536
1 = One Decimal
2 = Two Decimals
3 = Three Decimals
4 = Four Decimals
5 = Five Decimals
ITE-LOT-TRACK-FL Alpha 1 IC10.2 IC11.1
Element: All Flag This field contains the lot tracking IC330 IC811
field which indicates whether the item PO150 PO25.6
is tracked by a lot/sublot number. PO25.7 PO36.2
N = No PO536 WH130
Y = Yes
ITE-SER-TRACK-FL Alpha 1 IC10.2 IC11.1
Element: Serial TrackinThis field determines if the item is to IC330 IC811
be tracked by a serial number. PO150 PO25.6
I = Issues PO25.7 PO36.2
N = Not tracked PO536 WH130
R = Receipts
ITE-CERT-REQ-FL Alpha 1 IC10.2 IC11.1
Certification This field indicates whether a IC330 IC811
Required Flag certification is required when this item PO150 PO25.6
is purchased. PO25.7 PO36.2
N = No PO536
Y = Yes
ITE-KIT-ITEM-FL Alpha 1 IC10.2 IC11.1
Element: All Flag This field indicates whether a kit has IC330 IC60.1
been set up for this item. IC62.1 IC811
N = No
Y = Yes
ITE-BRKN-CS-CHRG Alpha 1 IC10.2 IC11.1
Element: Broken Case ChThis flag determines if there is a IC330 IC811
charge to break up a case to satisfy an PO150 PO25.6
order in the Order Entry system. PO25.7 PO36.2
Y = Yes PO536
N = No
ITE-REPLACE-ITEM Alpha 32 IC10.2 IC11.1
Element: Item Number This field contains a valid item number IC330 IC811
designated as a replacement for this
item.
ITE-USER-FIELD1 Alpha 30 IC10.2 IC11.1
Item Mster User This is the first user-defined field. IC330 IC811
Defined Field1 Set up the title of this field in IC00.1 PO150 PO25.6
(Corporate Item Group). PO25.7 PO36.2
PO536
ITE-USER-FIELD2 Alpha 10 (Lower Case) IC10.2 IC11.1
Item Mster User This is the second user-defined field. IC330 IC811
Defined Field2 It can contain any data the user wants. PO150 PO25.6
The title of this field is set up in PO25.7 PO36.2
IC00.1 (Corporate Item Group). PO536
ITE-USER-FIELD3 Alpha 10 (Lower Case) IC10.2 IC11.1
Item Mster User This is the third user-defined field. IC330 IC811
Defined Field2 It can contain any data the user wants. PO150 PO25.6
The title of this field is set up in PO25.7 PO36.2
IC00.1 (Corporate Item Group). PO536
ITE-USER-FIELD4 Alpha 10 (Lower Case) IC10.2 IC11.1
Item Mster User This is the fourth user-defined field. IC330 IC811
Defined Field2 It can contain any data the user wants. PO150 PO25.6
The title of this field is set up in PO25.7 PO36.2
IC00.1 (Corporate Item Group). PO536
ITE-USER-FIELD5 Alpha 10 (Lower Case) IC10.2 IC11.1
Item Mster User This is the fifth user-defined field. IC330 IC811
Defined Field2 It can contain any data the user wants. PO150 PO25.6
The title of this field is set up in PO25.7 PO36.2
IC00.1 (Corporate Item Group). PO536
ITE-USER-FIELD-N1 Signed 13.5 IC10.2 IC11.1
User Defined This is the first user-defined numeric IC330 IC811
Numeric Field 1 field. It can contain any data the PO150 PO25.6
user wants. The title of this field is PO25.7 PO36.2
set up in IC00.1 (Corporate Item Group). PO536
ITE-USER-FIELD-N2 Signed 13.5 IC10.2 IC11.1
User Defined This is the second user-defined numeric IC330 IC811
Numeric Field 1 field. It can contain any data the PO150 PO25.6
user wants. The title of this field is PO25.7 PO36.2
set up in IC00.1 (Corporate Item Group). PO536
ITE-USER-FIELD-N3 Signed 13.5 IC10.2 IC11.1
User Defined This is the third user-defined numeric IC330 IC811
Numeric Field 1 field. It can contain any data the PO150 PO25.6
user wants. The title of this field is PO25.7 PO36.2
set up in IC00.1 (Corporate Item Group). PO536
ITE-SEQ Numeric 3 IC10.2 IC11.1
Element: Sequence NumbeThis field contains the last sequence IC18.1 IC811
number used for the item comments added
in IC18.1 (Item Comments) for this item.
ITE-ADDED-DATE Numeric 8 (yyyymmdd) IC10.2 IC11.1
Element: Date This field contains the date the Item IC330 IC811
Master record was originally added in PO150 PO25.6
IC11.1 (Item Master) or IC10.1 PO25.7 PO36.2
(Formats). The field defaults to the PO536
system date when the record is added.
ITE-MSDS-FLAG Alpha 1 IC10.2 IC11.1
Element: All Flag This field indicates whether this item IC330 IC811
requires a Material Safety Data Sheet. PO150 PO25.6
N = No PO25.7 PO36.2
Y = Yes PO536
ITE-ACTIVE-STATUS Alpha 1 IC10.2 IC11.1
Element: Status This status flag indicates whether this IC330 IC811
item is active or inactive. If inactive, PO150 PO25.6
no transactions can be entered using PO25.7 PO36.2
this item, but transactions that are in PO536
process can be completed.
I = Inactive
A = Active
ITE-ALT-UOM Alpha 4 Occurs 10 Times IC10.2 IC11.1
Element: Unit of MeasurThis field contains the alternate unit IC811 PO150
of measure for this item. PO25.6 PO25.7
PO36.2 PO536
ITE-ALT-UOM-CONV Signed 10.5 Occurs 10 Times IC10.2 IC11.1
AlternateUOM This field contains the conversion IC811 PO150
Conversion Factor factor from the alternate unit of PO25.6 PO25.7
measure to the stock unit of measure. PO36.2 PO536
ITE-ALT-UOM-MULT Signed 13.7 Occurs 10 Times IC10.2 IC11.1
Unit of Measure This field contains the multiplier for IC811 PO150
Multiplier converting an alternate unit of measure PO25.6 PO25.7
to the stock unit of measure. It is PO36.2 PO536
calculated by IC11.1 (Item Master) based
on the conversion factor and the
relationship between the stock and
alternate units of measure.
ITE-TRACKING-FL Alpha 1 Occurs 10 Times IC10.2 IC11.1
Element: All Flag This field indicates whether quantities IC811 PO150
are tracked by this alternate unit of PO25.6 PO25.7
measure. PO36.2 PO536
X = X- Inventory Tracked WHD3.1
ITE-TRANS-FL Alpha 1 Occurs 10 Times IC10.2 IC11.1
Element: Account Flag This flag indicates whether this IC811 PO150
alternate unit of measure is valid for PO25.6 PO25.7
inventory transactions. The flag PO36.2 PO536
settings consist of the following.
Blank = Cannot be used.
1 = Valid. Default on transaction.
2 = Valid.
ITE-SELL-FL Alpha 1 Occurs 10 Times IC10.2 IC11.1
Element: Account Flag This field indicates whether this IC811 PO150
alternate unit of measure is valid for PO25.6 PO25.7
the sell quantity in the Order Entry PO36.2 PO536
system. The flag settings consist of the
following.
Blank = Cannot be used.
1 = Valid. Default on entry.
2 = Valid.
ITE-SELL-PRICE-FL Alpha 1 Occurs 10 Times IC10.2 IC11.1
Element: Account Flag This field indicates whether this IC811 PO150
alternate unit of measure is valid for PO25.6 PO25.7
the sell price in the Order Entry PO36.2 PO536
system. The flag settings consist of the
following.
Blank = Cannot be used.
1 = Valid. Default on entry.
2 = Valid.
ITE-BUY-FL Alpha 1 Occurs 10 Times IC10.2 IC11.1
Element: Account Flag This field indicates whether this IC811 PO150
alternate unit of measure is valid for PO25.6 PO25.7
the buy quantity in the Purchase Order PO36.2 PO536
system. The flag settings consist of the
following.
Blank = Cannot be used.
1 = Valid. Default on entry.
2 = Valid.
ITE-PACKING-WEIGHT Signed 9.3 Occurs 10 Times IC10.2 IC11.1
Element: Unit Weight This field contains the packed weight IC811
of an item in the alternate unit of
measure.
ITE-PACKING-CUBIC Signed 9.3 Occurs 10 Times IC10.2 IC11.1
Element: Cubic Feet This field contains the cubic measure IC811
of the packed alternate unit of measure.
ITE-USE-IDENTIFIER Alpha 1 IC11.1 IC330
Element: Use IdentifierD = Drugs IC811 PO150
M = Instrument PO25.6 PO25.7
R = Reusable PO36.2 PO536
P = Pharmacy
I = Inventory
N = Nonstock
X = Special
S = Service
L = Implant
U = Analytics
ITE-CONSIGNMENT-FL Alpha 1 IC10.2 IC11.1
Element: Consignment FlThe consignment flag set to Y indicates IC330 IC811
that this item is not to be counted as PO150 PO25.6
part of the owned inventory. It will PO25.7 PO36.2
default to N and will be defaulted to PO536
the ITEMLOC record with the same flag.
N = No
Y = Yes
ITE-UPC-EXISTS Numeric 1 ICI4.1 PO150
Element: Upc Exists This is a flag to indicate that UPC PO25.6 PO25.7
numbers exist for this item. PO36.2 PO536
0 = No
1 = Yes
ITE-UPN1-EXISTS Numeric 1 ICI5.1 PO150
Element: Upn1 Exists This is a flag to indicate that UPN1 PO25.6 PO25.7
numbers exist for this item. PO36.2 PO536
0 = No
1 = Yes
ITE-UPN2-EXISTS Numeric 1 ICI6.1 PO150
Element: Upn2 Exists This is a flag to indicate that UPN2 PO25.6 PO25.7
numbers exist for this item. PO36.2 PO536
0 = No
1 = Yes
ITE-SKU-EXISTS Numeric 1 ICI7.1 PO150
Element: Sku Exists This is a flag to indicate that SKU PO25.6 PO25.7
numbers exist for this item. PO36.2 PO536
0 = No
1 = Yes
ITE-NDC-EXISTS Numeric 1 PO150 PO25.6
Element: Ndc Exists This is a flag to indicate that NDC PO25.7 PO36.2
numbers exist for this item. PO536
0 = No
1 = Yes
ITE-INSP-REQ-FL Alpha 1 IC10.2 IC330
Element: All Flag N = No IC811
Y = Yes
ITE-ICN-CODE Alpha 8 IC10.2 IC11.1
Element: Icn Code ICN stands for Intrastat Classification IC330 IC811
Nomenclature. ICN code is a combination
of the 2digit Harmonize System Chapter
code, 2digit Harmonize Heading, 2digit
Harmonize Subheading, and 2digit
combined nomenclature code. The
Harmonize System of classification codes
is designed to identify items for
international trade. The ICN code
entered on IC11 will be validated
against the code listing in
INSTCMDTY(IN03). When a code is added
there will also be a check to make sure
there is a alternate uom defined for the
item that is associated with the code in
IN.
ITE-ICSEGMENT Alpha 2 IC10.2 IC11.1
Element: Icsegment IC811 PO150
PO25.6 PO25.7
PO36.2 PO536
ITE-ICFAMILY Alpha 2 IC10.2 IC11.1
Element: Icfamily IC811 PO150
PO25.6 PO25.7
PO36.2 PO536
ITE-ICCLASS Alpha 2 IC10.2 IC11.1
Element: Icclass IC811 PO150
PO25.6 PO25.7
PO36.2 PO536
ITE-ICCOMMODITY Alpha 2 IC10.2 IC11.1
Element: Iccommodity IC811 PO150
PO25.6 PO25.7
PO36.2 PO536
ITE-ISS-ACCOUNT Numeric 6 IC10.2 IC11.1
Element: Account This is a default account number for IC811
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 Numeric 4 IC10.2 IC11.1
Element: Subaccount This is the default sub account number IC811
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 Numeric 1
Element: Cap Tech Flag 0 = None
1 = Capital
2 = Technical
3 = Both
ITE-ALLOC-UOM Derived
Allocation Unit of This field is the allocation unit of
Measure measure based on whether the item is a
catch weight or regular item.
ITE-HAZARD-FL Derived
Element: Hazard Flag This field is used to display an "X" if
the item is hazardous.
ITE-TRACK-1 Derived
Element: Track 1 This field is used to determine if this
item is tracked by more than one unit of
measure.
ITE-TRACK-2 Derived
Element: Track 2 This field is used to determine if this
item is tracked by more than one unit of
measure.
ITE-TRACK-3 Derived
Element: Track 3 This field is used to determine if this
item is tracked by more than one unit of
measure.
ITE-TRACK-4 Derived
Element: Track 4 This field is used to determine if this
item is tracked by more than one unit of
measure.
ITE-TRACK-5 Derived
Element: Track 5 This field is used to determine if this
item is tracked by more than one unit of
measure.
ITE-TRACK-6 Derived
Element: Track 6 This field is used to determine if this
item is tracked by more than one unit of
measure.
ITE-VALUE-1 Derived
Element: Value 1 This field is used to determine if this
item is tracked by this unit of measure.
1 = Tracked by this unit of measure.
0 = Not tracked by this unit of measure.
ITE-VALUE-2 Derived
Element: Value 2 This field is used to determine if this
item is tracked by this unit of measure.
1 = Tracked by this unit of measure.
0 = Not tracked by this unit of measure.
ITE-VALUE-3 Derived
Element: Value 3 This field is used to determine if this
item is tracked by this unit of measure.
1 = Tracked by this unit of measure.
0 = Not tracked by this unit of measure.
ITE-VALUE-4 Derived
Element: Value 4 This field is used to determine if this
item is tracked by this unit of measure.
1 = Tracked by this unit of measure.
0 = Not tracked by this unit of measure.
ITE-VALUE-5 Derived
Element: Value 5 This field is used to determine if this
item is tracked by this unit of measure.
1 = Tracked by this unit of measure.
0 = Not tracked by this unit of measure.
ITE-VALUE-6 Derived
Element: Value 6 This field is used to determine if this
item is tracked by this unit of measure.
1 = Tracked by this unit of measure.
0 = Not tracked by this unit of measure.
ITE-MULT-UOMS Derived
Element: Mult Uoms This field contains the value of the
number of units of measure this item is
tracked by.
ITE-ITEM-CODE-USED Derived
Element: Item Code Used
ITE-SIEBEL-ITEM-FL Alpha 1 IC11.1
Element: Siebel Item FlY
N
ITEMMAST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ITESET1 ITEM-GROUP AP125 AP126
ITEM AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
CXCP.1 DR100
DR25.1 DR40.1
DR42.1 IC00.1
IC10.1 IC10.2
IC11.1 IC11.2
IC11.3 IC11.4
IC11.5 IC110
...
ITESET10 ITEM-GROUP KeyChange, Subset IC10.2 IC11.1
ICSEGMENT Where ICSEGMENT != Spaces IC16.1 IC46.1
ICFAMILY And ACTIVE-STATUS = "A" IC516 IC811
ICCLASS RQIC.1 RQIG.1
ICCOMMODITY
ITEM
ITESET11 ITEM-GROUP KeyChange, Subset
MANUF-NBR Where MANUF-NBR != Spaces
MANUF-CODE And ACTIVE-STATUS = "A"
MANUF-DIVISION
ITEM
ITESET12 ITEM-GROUP KeyChange, Subset IC11.1
REPLACE-ITEM Where REPLACE-ITEM != Spaces
ITEM
ITESET2 ITEM-GROUP KeyChange IC30.1
DESCRIPTION
ITEM
ITESET3 ITEM-GROUP KeyChange, Subset IC08.1 IC30.1
GENERIC Where GENERIC != Spaces
ITEM And ACTIVE-STATUS = "A"
ITESET4 ITEM-GROUP KeyChange, Subset IC07.1 IC30.1
PURCH-MAJCL Where PURCH-MAJCL != Spaces IC46.1 SEA1.1
PURCH-MINCL And ACTIVE-STATUS = "A" SEA3.1
ITEM
ITESET5 ITEM-GROUP KeyChange, Subset IC06.1 IC30.1
INVEN-MAJCL Where INVEN-MAJCL != Spaces IC46.1 SEA1.1
INVEN-MINCL And ACTIVE-STATUS = "A" RQ250 SEA3.1
ITEM
ITESET6 ITEM-GROUP KeyChange, Subset IC05.1 IC30.1
SALES-MAJCL Where SALES-MAJCL != Spaces IC46.1 SEA1.1
SALES-MINCL And ACTIVE-STATUS = "A" SEA3.1
ITEM
ITESET7 ITEM-GROUP KeyChange, Subset IC30.1 IC46.1
USER-FIELD1 Where USER-FIELD1 != Spaces
ITEM And ACTIVE-STATUS = "A"
ITESET8 ITEM-GROUP KeyChange, Subset IC14.1 IC46.1
MANUF-CODE Where MANUF-CODE != Spaces PO150 PO25.6
MANUF-DIVISIONAnd ACTIVE-STATUS = "A" PO25.7 PO36.2
MANUF-NBR PO536
ITEM
ITEMMAST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Genericname ICGENERIC Required
When ITE-GENERIC != Spaces
And ITE-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
Icmanfcode ICMANFCODE Required
When 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
Inventoryclass MINORCL Required
When 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
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
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 Item ITEMMAST Required
When ITE-REPLACE-ITEM != Spaces
ITE-ITEM-GROUP -> ITE-ITEM-GROUP
ITE-REPLACE-ITEM -> ITE-ITEM
Salesclass MINORCL Required
When ITE-SALES-MAJCL != Spaces
And ITE-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 RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
Itemtopharitem PHARITEM
ITE-ITEM-GROUP -> PHI-ITEM-GROUP
ITE-ITEM -> PHI-ITEM
PHI-COMPANY
PHI-LOCATION
PHI-NDC-NBR
PHI-UPC
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
Taxcode TXTAXCODE
ITE-PURCH-TAX-CD -> TAC-TAX-CODE
TAC-COMPANY
|