|
|
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 AP25.1 AP25.2 AP26.1
AP27.1 AP30.4 BL04.1 BL10.1 BL120 BL121
BL122 BL123 BL125 BL130 BL140 BL141
BL15.1 BL20.1 BL20.3 BL204 BL21.2 BL21.5
BL210 BL215 BL220 BL230 BL240 BL241
BL243 BL245 BL246 BL247 BL248 BL29.1
BL29.2 BL290 BL30.3 BL30.5 BL31.1 BL31.2
BL31.3 BL31.5 BL31.7 BL32.2 BL32.3 BL32.4
BL33.1 BL330 BL331 BL340 BL341 BL40.1
BL40.2 BL40.3 BL42.1 BL42.2 BL45.3 BL46.3
BL47.3 BL48.3 BL520 BL80.1 BL820 BL85.1
BL85.2 BL90.1 BL92.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
IC235 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 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 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 MA53.5 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 OE10.1 OE10.2 OE10.3
OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1
OE11.4 OE11.8 OE11.9 OE110 OE111 OE112
OE113 OE114 OE116 OE129 OE13.1 OE13.2
OE13.3 OE13.4 OE13.5 OE13.6 OE130 OE14.4
OE16.1 OE229 OE230 OE254 OE270 OE271
OE280 OE281 OE282 OE283 OE286 OE287
OE293 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5
OE30.6 OE30.7 OE30.9 OE330 OE510 OE530
OE54.1 OE55.1 OE55.2 OE81.1 OE81.3 OE810
OE830 OE86.1 OE90.1 OE90.2 PO100 PO101
PO115 PO122 PO125 PO13.1 PO130 PO131
PO132 PO133 PO135 PO136 PO137 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 PO53.2 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 RQ10.1 RQ10.2
RQ10.3 RQ11.1 RQ111 RQ12.1 RQ13.1 RQ13.2
RQ140 RQ230 RQ235 RQ35.1 RQ39.1 RQ39.2
RQ39.3 RQ40.1 RQ42.1 RQ44.1 RQ44.2 RQ50.1
RQ500 RQCP.1 RQIC.1 RQID.1 RQIF.1 RQIG.1
RQIH.1 RQIJ.1 SA04.1 SA100 SA110 SA250
SA251 SA252 SA253 SA254 SA255 SA256
SA258 SA300 SA80.3 SA90.3 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 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 WOEX.1 WOSP.1 IC16.1 IC516
IC08.1 IC07.1 IC06.1 RQ250 IC05.1 IC14.1
UPDATED BY
IC10.2 IC11.1 IC18.1 IC330 IC60.1 IC62.1
IC62.4 IC780 IC811 ICI4.1 ICI5.1 ICI6.1
ICI7.1 ICIC.1 PO150 PO25.6 PO25.7 PO36.2
PO536
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) BL241 BL243
Element: Description This field contains the first line of BL341 BL42.1
the description. IC10.2 IC11.1
IC270 IC330
IC811 OE114
OE130 OE287
OE293 OE330
PO150 PO25.6
PO25.7 PO36.2
PO536 PO63.1
SA04.1 SA258
WH110 WH126
WH132 WH20.2
WH221 WH222
WH224 WH226
WH520 WO132
WO280
ITE-DESCRIPTION2 Alpha 30 (Lower Case) BL241 BL243
Element: Description This field contains the second line of IC10.2 IC11.1
the description. IC270 IC330
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 MeasurThis is the stock unit of measure for IC243 IC811
the item. OE130 OE230
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
Catch Weight This field contains the catch weight IC330 IC811
Variance Percent 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
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 BL120 BL121
Nbr of Decimals for This field contains the number of BL122 BL125
Quantity decimal places that are entered and BL20.1 BL290
displayed for the cost field. BL80.1 IC10.2
0 = 0 Decimals IC11.1 IC330
1 = 1 Decimal IC811 OE114
2 = 2 Decimals OE30.3 OE510
3 = 3 Decimals PO229 PO230
4 = 4 Decimals PO32.3 PO63.1
PO67.1 SA250
SA251 SA252
SA253 SA254
SA255 SA256
WH130
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 OE30.3 PO150
displayed for the unit cost field. PO229 PO25.6
0 = No Decimals PO25.7 PO36.2
1 = One Decimal PO536
2 = Two decimals
3 = Three Decimals
4 = Four decimals
5 = Five decimals
ITE-NBR-DEC-PRICE Numeric 1 BL120 BL121
Number of Decimals This field contains the number of BL122 BL125
for Cost decimal places that are entered and BL20.1 BL241
displayed for the unit cost field. BL290 BL341
0 = No Decimals BL40.1 BL40.2
1 = One Decimal BL40.3 BL80.1
2 = Two Decimals IC10.2 IC11.1
3 = Three Decimals IC330 IC811
4 = Four Decimals OE114 OE30.3
5 = Five Decimals PO150 PO25.6
PO25.7 PO36.2
PO536
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 OE114 OE330
is tracked by a lot/sublot number. PO150 PO25.6
I = Issues PO25.7 PO36.2
N = Not tracked PO536 WH130
R = Receipts
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. OE114 OE330
I = Issues PO150 PO25.6
N = Not tracked PO25.7 PO36.2
R = Receipts PO536 WH130
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 IC62.4
N = No IC811
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 30 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 30 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 30 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 30 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 18.5 IC10.2 IC11.1
Element: Intl Cost This is the first user-defined numeric IC330 IC811
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 18.5 IC10.2 IC11.1
Element: Intl Cost This is the second user-defined numeric IC330 IC811
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 18.5 IC10.2 IC11.1
Element: Intl Cost This is the third user-defined numeric IC330 IC811
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 Item was 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 IC11.1 IC811
Element: All Flag This field indicates whether quantities PO150 PO25.6
are tracked by this alternate unit of PO25.7 PO36.2
measure. PO536
X = X- Inventory Tracked
ITE-TRANS-FL Alpha 1 Occurs 10 Times IC10.2 IC11.1
Element: Transaction FlThis 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: Buying 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
M = Instrument
R = Reusable
P = Pharmacy
L = Implant
U = Analytics
N = Narcotic
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 ICIC.1 PO150
Element: Ndc Exists This is a flag to indicate that NDC PO25.6 PO25.7
numbers exist for this item. PO36.2 PO536
0 = No
1 = Yes
ITE-INSP-REQ-FL Alpha 1 IC10.2 IC330
Element: All Flag This flag indicates whether this item IC811
has to be inspected when received via
PO.
N = No
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-IC-OBJ-ID Numeric 12 IC11.1 IC780
Object
Identification
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
ITEMMAST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ITESET1 ITEM-GROUP AP125 AP126
ITEM AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
BL04.1 BL10.1
BL120 BL121
BL122 BL123
BL125 BL130
BL140 BL141
BL15.1 BL20.1
BL20.3 BL204
BL21.2 BL21.5
BL210 BL215
BL220 BL230
BL240 BL241
...
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 OE55.2
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"
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
ITEM
ITESET6 ITEM-GROUP KeyChange, Subset BL85.2 IC05.1
SALES-MAJCL Where SALES-MAJCL != Spaces IC30.1 IC46.1
SALES-MINCL And ACTIVE-STATUS = "A" SEA1.1 OE55.2
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
ITESET9 IC-OBJ-ID Subset
Where IC-OBJ-ID != Zeroes
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
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
Oediagdtl OEDIAGDTL
ITE-ITEM -> ODL-ITEM
ITE-ITEM-GROUP -> ODL-ITEM-GROUP
ODL-DIAGRAM-ID
ODL-SEQ-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
|
