|
|
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 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 API1.1 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
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
IC00.1 IC12.1 IC12.2 IC13.1 IC130 IC190
IC210 IC211 IC212 IC213 IC30.1 IC320
IC800 IC812 IC850 IC851 ICBL.1 ICBL.2
ICBL.4 ICI1.1 ICI8.1 ICIT.1 MX123 MX500
MA180 MA236 MA278 MA41.1 MA41.2 MA41.4
MA41.7 MA43.1 MA43.2 MA43.3 MA43.7 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 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 PO234 PO24.1 PO253
PO254 PO26.1 PO27.2 PO274 PO275 PO276
PO277 PO278 PO28.1 PO280 PO29.1 PO295
PO30.1 PO30.2 PO30.3 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 PO54.1 PO54.2
PO54.3 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 RQ13.2
RQ140 RQ230 RQ235 RQ250 RQ35.1 RQ39.1
RQ39.2 RQ39.3 RQ40.1 RQ41.1 RQ42.1 RQ44.1
RQ44.2 RQ50.1 RQ500 RQCP.1 RQD0.1 RQD1.1
RQIC.1 RQID.1 RQIF.1 RQIG.1 RQIH.1 RQIJ.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 IC16.1
IC516 IC08.1 IC07.1 IC06.1 IC05.1 IC14.1
MX223
UPDATED BY
IC11.1 IC18.1 IC330 IC811 ICI4.1 ICI5.1
ICI6.1 ICI7.1 ICIC.1 PO150 PO25.6 PO25.7
PO36.2 PO536 WHD3.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ITE-ITEM-GROUP Alpha 5 IC11.1 IC811
Element: Item Group This field contains the identifier for PO150 PO25.6
a group of items that can be shared by PO25.7 PO36.2
one or more companies. PO536
ITE-ITEM Alpha 32 IC11.1 IC811
Element: Item This field contains the item PO150 PO25.6
identifier. 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. IC11.1 IC330
IC811 PO150
PO25.6 PO25.7
PO253 PO36.2
PO536 PO63.1
WH110 WH126
WH132 WH20.2
WH221 WH222
WH224 WH226
WH520
ITE-DESCRIPTION2 Alpha 30 (Lower Case) BL241 BL243
Element: Description This field contains the second line of IC11.1 IC330
the description. IC811 PO150
PO25.6 PO25.7
PO26.1 PO36.2
PO536 POIE.1
WH110 WH226
ITE-STOCK-UOM Alpha 4 IC11.1 IC811
Element: Uom This field contains the valid stock PO150 PO25.6
unit of measure for this item. PO25.7 PO36.2
PO536 WH110
WH132 WH20.7
WH520
ITE-SEC-UOM Alpha 4 IC11.1 IC330
Element: Uom This field contains the secondary IC811
quantity unit of measure.
ITE-SEC-UOM-MULT Signed 13.7 IC11.1 IC811
Element: Uom Mult 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.
ITE-SEC-UOM-CONV Signed 10.5 IC11.1 IC811
Element: Alt Uom Conv This field contains the secondary unit
of measure conversion factor.
ITE-CTW-CODE Alpha 1 IC11.1 IC330
Element: Ctw Code This field indicates whether this item IC811 PO150
is a catch weight item. A catch weight PO25.6 PO25.7
item tracks two quantities with two PO32.3 PO36.2
different units of measure. The first PO536 PO63.1
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
ITE-CTW-VAR-PCT Signed 5.2 IC11.1 IC330
Element: Ctw Var Pct This field contains the catch weight 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 IC11.1 IC330
Element: Generic This field contains a user-defined IC811 PO150
general name for an item, used for PO25.6 PO25.7
searching for an item. PO36.2 PO536
ITE-FREIGHT-CLASS Alpha 4 IC11.1 IC330
Element: Freight Class This field contains the user-defined IC811
freight classification code. The
Warehouse system uses freight classes
for bill of lading processing.
ITE-PURCH-MAJCL Alpha 4 IC11.1 IC330
Element: Major Class This field contains the user-defined IC811 PO150
major purchasing class identifier. PO25.6 PO25.7
PO36.2 PO536
ITE-PURCH-MINCL Alpha 4 IC11.1 IC330
Element: Minor Class This field contains the user-defined IC811 PO150
minor purchasing class identifier. PO25.6 PO25.7
PO36.2 PO536
ITE-INVEN-MAJCL Alpha 4 IC11.1 IC330
Element: Major Class This field contains the user-defined IC811 PO150
major inventory class code. PO25.6 PO25.7
PO36.2 PO536
ITE-INVEN-MINCL Alpha 4 IC11.1 IC330
Element: Minor Class The user-defined minor inventory class IC811 PO150
code within the major class. PO25.6 PO25.7
PO36.2 PO536
ITE-SALES-MAJCL Alpha 4 IC11.1 IC330
Element: Major Class This field contains the sales major IC811
class code.
ITE-SALES-MINCL Alpha 4 IC11.1 IC330
Element: Minor Class This field contains the sales minor IC811
class code within the major class.
ITE-MANUF-CODE Alpha 4 IC11.1 IC330
Element: Manuf Code This field contains a user-defined code IC811 PO150
that indicates the manufacturer of an PO25.6 PO25.7
item. PO36.2 PO536
ITE-MANUF-DIVISION Alpha 4 IC11.1 IC330
Element: Manuf DivisionThis is a user defined code that IC811 PO150
indicates which division of a PO25.6 PO25.7
manufacturer is tied to an item. PO36.2 PO536
ITE-MANUF-NBR Alpha 15 IC11.1 IC330
Element: Manuf Nbr This is the identifier that the IC811 PO150
manufacturer has assigned to an item. PO25.6 PO25.7
PO36.2 PO536
ITE-HAZARD-CODE Alpha 8 IC11.1 IC330
Element: Hazard Code This field contains a short code IC811
describing why an item can be hazardous.
ITE-PURCH-TAX-FL Alpha 1 IC11.1 IC330
Element: Purch Tax Fl This flag specifies if this item is 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 IC11.1 IC330
Element: Tax Code This code is used to determine if this 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 IC11.1 IC330
Element: Prod Tax Cat This field contains a classification of IC811
items for determining taxes using the
VERTEX system in the Order Entry system.
ITE-HARMONIZE-CD Alpha 11
Element: Harmonize Cd This field contains the harmonize class
code.
ITE-WEIGHT Signed 9.3 IC11.1 IC330
Element: Weight This field contains the net unit weight IC811
of the item based on the stock unit of
measure.
ITE-CUBIC-FEET Signed 9.3 IC11.1 IC330
Element: Cubic Feet This field contains the net unit cubic IC811
measure of the item based on the stock
unit of measure.
ITE-NBR-DEC-QTY Numeric 1 BL120 BL121
Element: Nbr Dec Qty This field contains the number of BL122 BL125
decimal places that are entered and BL20.1 BL290
displayed for the cost field. BL80.1 IC11.1
0 = 0 Decimals IC330 IC811
1 = 1 Decimal PO229 PO32.3
2 = 2 Decimals PO63.1 PO67.1
3 = 3 Decimals WH130
4 = 4 Decimals
ITE-NBR-DEC-COST Numeric 1 IC11.1 IC330
Element: Nbr Dec Cost This field contains the number of IC811 PO150
decimal places that are entered and PO229 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-NBR-DEC-PRICE Numeric 1 BL120 BL121
Element: Nbr Dec Cost This field contains the number of BL122 BL125
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 IC11.1 IC330
3 = Three Decimals IC811 PO150
4 = Four Decimals PO25.6 PO25.7
5 = Five Decimals PO36.2 PO536
ITE-LOT-TRACK-FL Alpha 1 IC11.1 IC330
Element: All Flag This field contains the lot tracking IC811 PO150
field which indicates whether the item PO25.6 PO25.7
is tracked by a lot/sublot number. PO36.2 PO536
I = Issues
N = Not tracked
R = Receipts
ITE-SER-TRACK-FL Alpha 1 IC11.1 IC330
Element: Ser Track Fl This field determines if the item is to IC811 PO150
be tracked by a serial number. PO25.6 PO25.7
I = Issues PO36.2 PO536
N = Not tracked
R = Receipts
ITE-CERT-REQ-FL Alpha 1 IC11.1 IC330
Element: Cert Req Fl This field indicates whether a IC811 PO150
certification is required when this item PO25.6 PO25.7
is purchased. PO36.2 PO536
N = No
Y = Yes
ITE-KIT-ITEM-FL Alpha 1 IC11.1 IC330
Element: All Flag This field indicates whether a kit has IC811
been set up for this item.
N = No
Y = Yes
ITE-BRKN-CS-CHRG Alpha 1 IC11.1 IC330
Element: Brkn Cs Chrg This flag determines if there is a IC811 PO150
charge to break up a case to satisfy an PO25.6 PO25.7
order in the Order Entry system. PO36.2 PO536
Y = Yes
N = No
ITE-REPLACE-ITEM Alpha 32 IC11.1 IC330
Element: Item This field contains a valid item number IC811
designated as a replacement for this
item.
ITE-USER-FIELD1 Alpha 30 IC11.1 IC330
Element: User Field1 This is the first user-defined field. IC811 PO150
Set up the title of this field in PO25.6 PO25.7
Corporate Item Group (IC00.1). PO36.2 PO536
ITE-USER-FIELD2 Alpha 30 IC11.1 IC330
Element: User Field2 This is the second user-defined field. IC811 PO150
It can contain any data the user wants. PO25.6 PO25.7
The title of this field is set up in PO36.2 PO536
Corporate Item Group (IC00.1).
ITE-USER-FIELD3 Alpha 30 IC11.1 IC330
Element: User Field2 This is the third user-defined field. IC811 PO150
It can contain any data the user wants. PO25.6 PO25.7
The title of this field is set up in PO36.2 PO536
Corporate Item Group (IC00.1).
ITE-USER-FIELD4 Alpha 30 IC11.1 IC330
Element: User Field2 This is the fourth user-defined field. IC811 PO150
It can contain any data the user wants. PO25.6 PO25.7
The title of this field is set up in PO36.2 PO536
Corporate Item Group (IC00.1).
ITE-USER-FIELD5 Alpha 30 IC11.1 IC330
Element: User Field2 This is the fifth user-defined field. IC811 PO150
It can contain any data the user wants. PO25.6 PO25.7
The title of this field is set up in PO36.2 PO536
Corporate Item Group (IC00.1).
ITE-USER-FIELD-N1 Signed 18.5 IC11.1 IC330
Element: Intl Cost This is the first user-defined numeric IC811 PO150
field. It can contain any data the user PO25.6 PO25.7
wants. The title of this field is set up PO36.2 PO536
in Corporate Item Group (IC00.1).
ITE-USER-FIELD-N2 Signed 18.5 IC11.1 IC330
Element: Intl Cost This is the second user-defined numeric IC811 PO150
field. It can contain any data the user PO25.6 PO25.7
wants. The title of this field is set up PO36.2 PO536
in Corporate Item Group (IC00.1).
ITE-USER-FIELD-N3 Signed 18.5 IC11.1 IC330
Element: Intl Cost This is the third user-defined numeric IC811 PO150
field. It can contain any data the user PO25.6 PO25.7
wants. The title of this field is set up PO36.2 PO536
in Corporate Item Group (IC00.1).
ITE-SEQ Numeric 3 IC11.1 IC18.1
Element: Seq This field contains the last sequence IC811
number used for the item comments added
in IC18.1 (Item Comments) for this item.
ITE-ADDED-DATE Numeric 8 (yyyymmdd) IC11.1 IC811
Element: Added Date This field contains the date the Item PO150 PO25.6
Master record was originally added in PO25.7 PO36.2
IC11.1 (Item Master) or IC10.1 PO536
(Formats). The field defaults to the
system date when the record is added.
ITE-MSDS-FLAG Alpha 1 IC11.1 IC330
Element: All Flag This field indicates whether this item IC811 PO150
requires a Material Safety Data Sheet. PO25.6 PO25.7
N = No PO36.2 PO536
Y = Yes
ITE-ACTIVE-STATUS Alpha 1 IC11.1 IC330
Element: Active Status This status flag indicates whether this IC811 PO150
item is active or inactive. If inactive, PO25.6 PO25.7
no transactions can be entered using PO36.2 PO536
this item, but transactions that are in
process can be completed.
I = Inactive
A = Active
ITE-ALT-UOM Alpha 4 Occurs 10 Times IC11.1 IC330
Element: Uom This 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 IC11.1 IC811
Element: Alt Uom Conv This field contains the conversion PO150 PO25.6
factor from the alternate unit of PO25.7 PO36.2
measure to the stock unit of measure. PO536
ITE-ALT-UOM-MULT Signed 13.7 Occurs 10 Times IC11.1 IC811
Element: Uom Mult This field contains the multiplier for PO150 PO25.6
converting an alternate unit of measure PO25.7 PO36.2
to the stock unit of measure. It is 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 WHD3.1
X = X- Inventory Tracked
ITE-TRANS-FL Alpha 1 Occurs 10 Times IC11.1 IC811
Element: Trans Fl This flag indicates whether this PO150 PO25.6
alternate unit of measure is valid for PO25.7 PO36.2
inventory transactions. The flag 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 IC11.1 IC811
Element: Account Flag This field indicates whether this PO150 PO25.6
alternate unit of measure is valid for PO25.7 PO36.2
the sell quantity in the Order Entry 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 IC11.1 IC811
Element: Account Flag This field indicates whether this PO150 PO25.6
alternate unit of measure is valid for PO25.7 PO36.2
the sell price in the Order Entry 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 IC11.1 IC811
Element: Buy Fl This field indicates whether this PO150 PO25.6
alternate unit of measure is valid for PO25.7 PO36.2
the buy quantity in the Purchase Order 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 IC11.1 IC330
Element: 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 IC11.1 IC330
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 IC11.1 IC330
Element: Consignment FlThe consignment flag set to Y indicates IC811 PO150
that this item is not to be counted as PO25.6 PO25.7
part of the owned inventory. It will PO36.2 PO536
default to N and will be defaulted to
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 IC330 IC811
Element: All Flag N = No
Y = Yes
ITE-ICN-CODE Alpha 8 IC11.1 IC330
Element: Icn Code ICN stands for Intrastat Classification IC811
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.
ITE-ICSEGMENT Alpha 2 IC11.1 IC330
Element: Icsegment IC811 PO150
PO25.6 PO25.7
PO36.2 PO536
ITE-ICFAMILY Alpha 2 IC11.1 IC330
Element: Icfamily IC811 PO150
PO25.6 PO25.7
PO36.2 PO536
ITE-ICCLASS Alpha 2 IC11.1 IC330
Element: Icclass IC811 PO150
PO25.6 PO25.7
PO36.2 PO536
ITE-ICCOMMODITY Alpha 2 IC11.1 IC330
Element: Iccommodity IC811 PO150
PO25.6 PO25.7
PO36.2 PO536
ITE-ISS-ACCOUNT Numeric 6 IC11.1 IC330
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 IC11.1 IC330
Element: Sub Acct 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 IC811
Element: Obj Id This is the object identifier. It is PO150 PO25.6
used to relate commitments or posted PO25.7 PO36.2
transactions back to the originating PO536
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.
ITE-COMMODITY-CODE Alpha 35 IC11.1 PO150
Element: Commodity Code PO25.6 PO25.7
PO36.2 PO536
ITE-ALLOC-UOM Derived
Element: Alloc Uom This field is the allocation unit of
measure based on whether the item is a
catch weight or regular item.
ITE-HAZARD-FL Derived
Element: Hazard Fl 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 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
API1.1 BL04.1
BL10.1 BL120
BL121 BL122
BL123 BL125
BL130 BL140
BL141 BL15.1
BL20.1 BL20.3
...
ITESET10 ITEM-GROUP KeyChange, Subset IC11.1 IC16.1
ICSEGMENT Where ICSEGMENT != Spaces IC330 IC516
ICFAMILY And ACTIVE-STATUS = "A" IC811 PO150
ICCLASS PO25.6 PO25.7
ICCOMMODITY PO36.2 PO536
ITEM RQIC.1 RQIG.1
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
ITESET13 ITEM-GROUP KeyChange, Subset
DESCRIPTION2 Where DESCRIPTION2 != 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
PURCH-MINCL And ACTIVE-STATUS = "A"
ITEM
ITESET5 ITEM-GROUP KeyChange, Subset IC06.1 IC30.1
INVEN-MAJCL Where INVEN-MAJCL != Spaces RQ250
INVEN-MINCL And ACTIVE-STATUS = "A"
ITEM
ITESET6 ITEM-GROUP KeyChange, Subset BL85.2 IC05.1
SALES-MAJCL Where SALES-MAJCL != Spaces IC30.1
SALES-MINCL And ACTIVE-STATUS = "A"
ITEM
ITESET7 ITEM-GROUP KeyChange, Subset IC30.1
USER-FIELD1 Where USER-FIELD1 != Spaces
ITEM And ACTIVE-STATUS = "A"
ITESET8 ITEM-GROUP KeyChange, Subset IC14.1 PO150
MANUF-CODE Where MANUF-CODE != Spaces PO25.6 PO25.7
MANUF-DIVISIONAnd ACTIVE-STATUS = "A" PO36.2 PO536
MANUF-NBR
ITEM
ITESET9 IC-OBJ-ID KeyChange, Subset IC30.1 ICBL.1
Where IC-OBJ-ID != Zeroes ICBL.2 ICBL.4
MX123 MX223
MX500 PO253
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
Iciteuf ICITEUF Not Required, Delete Cascades
ITE-ITEM-GROUP -> UFM-ITEM-GROUP
ITE-ITEM -> UFM-ITEM
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
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
Taxcode TXTAXCODE
ITE-PURCH-TAX-CD -> TAC-TAX-CODE
TAC-COMPANY
|
