ITEMASTOUT FILE
UPDATED BY
IC11.1 IC311
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ITO-ITEM-GROUP Alpha 5 IC11.1
Item Group This field contains the identifier for
a group of items that can be shared by
one or more companies.
ITO-COMPANY Numeric 4 IC11.1
Company The company number represents an
established company and is entered on
all function codes.
ITO-ITEM Alpha 32 IC11.1
Item Number This field contains the item
identifier.
ITO-CREATION-DATE Numeric 8 (yyyymmdd) IC11.1
Creation Date This is the date that this line was
added to the requisition.
ITO-CREATION-TIME Numeric 6 (hhmmss) IC11.1
Creation Time The creation time.
ITO-RECORD-TYPE Alpha 1 IC11.1
Record Type This field identifies the type of
record defined.
Valid values are:
S = Summary
D = Detail
ITO-RECORD-STAT Numeric 1 IC11.1
Record Stat
ITO-DESCRIPTION Alpha 30 (Lower Case) IC11.1
Description This field displays the description.
ITO-DESCRIPTION2 Alpha 30 (Lower Case) IC11.1
Second Description This field contains the second line of
the description.
ITO-STOCK-UOM Alpha 4 IC11.1
Stocking Unit of This is the stock unit of measure for
Measure the item.
ITO-SEC-UOM Alpha 4 IC11.1
Secondary Unit of This field contains the secondary
Measure quantity unit of measure.
ITO-SEC-UOM-MULT Signed 13.7 IC11.1
Secondary UOM This field contains the secondary
Multiplier quantity unit of measure multiplier. It
is used to convert the stock on hand
quantity to the secondary quantity or
visa versa.
ITO-SEC-UOM-CONV Signed 10.5 IC11.1
Secondary UOM This is the secondary unit of measure
ConversionFactor conversion factor.
ITO-CTW-CODE Alpha 1 IC11.1
Catch Weight Code This code indicates if this item is a
catch weight item. A catch weight item
tracks two quantities, with two
different units of measure.
ITO-CTW-VAR-PCT Signed 5.2 IC11.1
Catch Weight This field is the catch weight variance
Variance Percent percent. It is used to give a warning
message if the stocking and secondary
quantities on a catch weight transaction
are outside a conversion variance
percent.
ITO-GENERIC Alpha 10 IC11.1
Generic Name A user-defined general name for an
item, used for searching for an item.
ITO-FREIGHT-CLASS Alpha 4 IC11.1
Freight Class The user definable freight
classification code. This is used in
the Order Entry system to categorize
items on the Bill of Lading.
ITO-PURCH-MAJCL Alpha 4 IC11.1
Major Purchasing The user defined Major Purchasing Class
Class identifier.
ITO-PURCH-MINCL Alpha 4 IC11.1
Minor Purchasing The user defined Minor purchasing Class
Class identifier.
ITO-INVEN-MAJCL Alpha 4 IC11.1
Inventory Major The user defined Major Inventory Class
Class code.
ITO-INVEN-MINCL Alpha 4 IC11.1
Inventory Minor The user defined Minor Inventory Class
Class code within the major class.
ITO-SALES-MAJCL Alpha 4 IC11.1
Sales Major Class This field contains the sales major
class code.
ITO-SALES-MINCL Alpha 4 IC11.1
Sales Minor Class This field contains the sales minor
class code within the major class.
ITO-MANUF-CODE Alpha 4 IC11.1
Manufacturer's Code This field contains a user defined code
that indicates the manufacturer of an
item.
ITO-MANUF-DIVISION Alpha 4 IC11.1
Manufacturer's This is a user defined code that
Division indicates which division of a
manufacturer is tied to an item.
ITO-MANUF-NUMBER Alpha 15 IC11.1
Manuf Number
ITO-HAZARD-CODE Alpha 8 IC11.1
Hazard Code This field contains a short code
describing why an item can be hazardous.
ITO-PURCH-TAX-FL Alpha 1 IC11.1
Purchasing Tax Flag This field indicates if this item is
taxable when it is purchased for this
location. Valid values are:
N = Nontaxable. Default value.
Y = Taxable.
ITO-PURCH-TAX-CD Alpha 10 IC11.1
Purchasing Tax This code is used to determine if this
Table Code item is taxable when purchased at this
location and to extract the tax data
from the Tax file based on this tax
code.
ITO-PURCH-TAX-CAT Alpha 15 IC11.1
Purch Tax Cat
ITO-HARMONIZE-CD Alpha 11 IC11.1
Harmonize Code Harmonize Class code.
ITO-UPC Alpha 15 IC11.1
Universal Product Universal Product Code.
Code
ITO-WEIGHT Signed 9.3 IC11.1
Unit Weight This field contains the unit weight of
the item based on the stocking UOM.
ITO-CUBIC-FEET Signed 9.3 IC11.1
Cubic Feet This field contains the unit cubit feet
of the item based on the stocking UOM.
ITO-NBR-DEC-QTY Numeric 1 IC11.1
Nbr of Decimals for Number of decimals to be entered and
Quantity displayed for the cost field.
ITO-NBR-DEC-COST Numeric 1 IC11.1
Number of Decimals Number of decimals to be entered and
for Cost displayed for the unit cost field.
ITO-NBR-DEC-PRICE Numeric 1 IC11.1
Number of Decimals Number of decimals to be entered and
for Price displayed for the unit cost field.
ITO-LOT-TRACK-FL Alpha 1 IC11.1
Lot Tracking Flag
ITO-SER-TRACK-FL Alpha 1 IC11.1
Serial Tracking Flag
ITO-CERT-REQ-FL Alpha 1 IC11.1
Certification This flag indicates whether a
Required Flag certification is required for this line
when it is purchased. This field value
is passed to the PO when the PO line is
created. Valid values are:
"N" = Certification not required.
"Y" = Certification required.
ITO-KIT-ITEM-FL Alpha 1 IC11.1
Kit Item Flag
ITO-REUSE-FL Alpha 1 IC11.1
Reuse Fl This flag indicates that this item is a
reusable item. It can be used then
reconditioned and used again.
ITO-BRKN-CS-CHRG Alpha 1 IC11.1
Broken Case Charge This flag determines if there is a
charge if a broken case is required to
satisfy an order in Order Entry.
ITO-REPLACE-ITEM Alpha 32 IC11.1
Replacement Item
ITO-USER-FIELD1 Alpha 30 IC11.1
Item Mster User This is the first user definable field.
Defined Field1 It can be used to capture any data that
the user wants. The title of the field
is setup in IC00.
ITO-USER-FIELD2 Alpha 10 (Lower Case) IC11.1
Item Mster User This is the second user definable
Defined Field2 field. This field can be used to enter
any data that the user wants to capture
for this item. The title of the field
is setup in IC00.
ITO-USER-FIELD3 Alpha 10 (Lower Case) IC11.1
Item Mster User This field is the third user definable
Defined Field3 field. It can be used to capture any
data that the user wants. The name of
the field is determined in IC00.
ITO-USER-FIELD4 Alpha 10 (Lower Case) IC11.1
Item Mster User This field is the fourth user definable
Defined Field4 field. It can be used to capture any
data that the user wants. The name of
the field is determined in IC00.
ITO-USER-FIELD5 Alpha 10 (Lower Case) IC11.1
User Mster User This field is the fifth user definable
Defined Field5 field. It can be used to capture any
data that the user wants. The name of
the field is determined in IC00.
ITO-USER-FIELD-N1 Signed 13.5 IC11.1
User Defined This field is the first user definable
Numeric Field 1 numeric field. It can be used to
capture any numeric data that the user
wants. The name of the field is
determined in IC00.
ITO-USER-FIELD-N2 Signed 13.5 IC11.1
User Defined This field is the second user definable
Numeric Field 2 numeric field. This field can be used
to capture any numeric data that the
user wants. The name of the field is
determined in IC00.
ITO-USER-FIELD-N3 Signed 13.5 IC11.1
User Defined This field is the third user definable
Numeric Field 3 numeric field. This field can be used
to capture any data that the user wants.
The name of the field is determined in
IC00.
ITO-ADDED-DATE Numeric 8 (yyyymmdd) IC11.1
Date Item was Added
ITO-MSDS-FLAG Alpha 1 IC11.1
Material Safety This flag indicates if this item
DataSheet Flag requires a Material Safety Data Sheet.
ITO-ACTIVE-STATUS Alpha 1 IC11.1
Status The status of the account. If Inactive,
no posting can be done to the account.
ITO-ALT-UOM Alpha 4 Occurs 10 Times IC11.1
Alternate Unit of These are the alternate units of measure
Measure for this item.
ITO-ALT-UOM-CONV Signed 10.5 Occurs 10 Times IC11.1
AlternateUOM This is the conversion factor from the
Conversion Factor alternate unit of measure to the stock
unit of measure.
ITO-ALT-UOM-MULT Signed 13.7 Occurs 10 Times IC11.1
Alternate UOM This is the multiplier for converting
Multiplier an alternate unit of measure to the
stock unit of measure. It is calculated
by the Item Master maintenance program
(IC11) based on the conversion factor
and the relationship between the stock
oand alternate units of measure.
ITO-TRACKING-FL Alpha 1 Occurs 10 Times IC11.1
Tracking Flag This flag specifies if quantities are to
be tracked by this alternate unit of
measure.
ITO-TRANS-FL Alpha 1 Occurs 10 Times IC11.1
Transaction Flag This flag specifies if this alternate
unit of measure is valid for inventory
transactions. Valid values are:
Blank = Cannot be used.
1 = Valid, default on transaction.
2 = Valid.
ITO-SELL-FL Alpha 1 Occurs 10 Times IC11.1
Selling Flag This flag specifies if this alternate
unit of measure is valid for the sell
quantity in the Lawson Order Entry
system. Valid values are:
Blank = Cannot be used.
1 = Valid, default on entry.
2 = Valid.
ITO-SELL-PRICE-FL Alpha 1 Occurs 10 Times IC11.1
Sell Price Flag This flag specifies if this alternate
unit of measure is valid for the sell
price in the Lawson Order Entry system.
Valid values are:
Blank = Cannot be used.
1 = Valid, default on entry.
2 = Valid.
ITO-BUY-FL Alpha 1 Occurs 10 Times IC11.1
Buying Flag This flag specifies if this alternate
unit of measure is valid for the buy
quantity in the Lawson Purchase Order
system. Valid values are:
Blank = Cannot be used.
1 = Valid, default on entry.
2 = Valid.
ITO-PACKING-WEIGHT Signed 9.3 Occurs 10 Times IC11.1
Packing Weight This is the packed weight of an item in
the alternate unit of measure.
ITO-PACKING-CUBIC Signed 9.3 Occurs 10 Times IC11.1
Packing Cubic This is the cubic measure of the packed
alternate unit of measure.
ITO-INSP-REQ-FL Alpha 1 IC11.1
Inspection Required This flag indicates whether this item
Flag has to be inspected when received via
PO.
ITO-ICN-CODE Alpha 8 IC11.1
Icn Code
ITEMASTOUT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ITOSET1 ITEM-GROUP IC11.1 IC311
COMPANY
ITEM
CREATION-DATE
CREATION-TIME
ITOSET2 ITEM-GROUP Duplicates
ITEM
INVEN-MAJCL
INVEN-MINCL
ITOSET3 ITEM-GROUP Duplicates
ITEM
RECORD-STAT
|
