|
|
ITEMASTOUT FILE
UPDATED BY
IC11.1 IC311
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ITO-ITEM-GROUP Alpha 5 IC11.1
Element: 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
Element: Company Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
ITO-ITEM Alpha 32 IC11.1
Element: Item Number This field contains the item
identifier.
ITO-CREATION-DATE Numeric 8 (yyyymmdd) IC11.1
Element: Creation Date This is the date that this line was
added to the requisition.
ITO-CREATION-TIME Numeric 6 (hhmmss) IC11.1
Element: Creation Time The creation time.
ITO-RECORD-TYPE Alpha 1 IC11.1
Element: Record Type This field identifies the type of
record defined.
Valid values are:
S = Summary
D = Detail
ITO-RECORD-STAT Numeric 1 IC11.1
Element: Record Stat
ITO-DESCRIPTION Alpha 30 (Lower Case) IC11.1
Element: Description This field displays the description.
ITO-DESCRIPTION2 Alpha 30 (Lower Case) IC11.1
Element: Description This field contains the second line of
the description.
ITO-STOCK-UOM Alpha 4 IC11.1
Element: Unit of MeasurThis is the stock unit of measure for
the item.
ITO-SEC-UOM Alpha 4 IC11.1
Element: Unit of MeasurThis field contains the secondary
quantity unit of measure.
ITO-SEC-UOM-MULT Signed 13.7 IC11.1
Unit of Measure 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
AlternateUOM This is the secondary unit of measure
Conversion Factor conversion factor.
ITO-CTW-CODE Alpha 1 IC11.1
Element: Catch Weight CThis 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
Element: Generic Name A user-defined general name for an
item, used for searching for an item.
ITO-FREIGHT-CLASS Alpha 4 IC11.1
Element: 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
Element: Major Class The user defined Major Purchasing Class
identifier.
ITO-PURCH-MINCL Alpha 4 IC11.1
Element: Minor Class The user defined Minor purchasing Class
identifier.
ITO-INVEN-MAJCL Alpha 4 IC11.1
Element: Major Class The user defined Major Inventory Class
code.
ITO-INVEN-MINCL Alpha 4 IC11.1
Element: Minor Class The user defined Minor Inventory Class
code within the major class.
ITO-SALES-MAJCL Alpha 4 IC11.1
Element: Major Class This field contains the sales major
class code.
ITO-SALES-MINCL Alpha 4 IC11.1
Element: Minor Class This field contains the sales minor
class code within the major class.
ITO-MANUF-CODE Alpha 4 IC11.1
Element: Manufacturer'sThis 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
Element: Manuf Number
ITO-HAZARD-CODE Alpha 8 IC11.1
Element: Hazard Code This field contains a short code
describing why an item can be hazardous.
ITO-PURCH-TAX-FL Alpha 1 IC11.1
Element: Purchasing TaxThis 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
Element: Tax Code This code is used to determine if this
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
Element: Purch Tax Cat
ITO-HARMONIZE-CD Alpha 11 IC11.1
Element: Harmonize CodeHarmonize Class code.
ITO-UPC Alpha 15 IC11.1
Universal Product Universal Product Code.
Code
ITO-WEIGHT Signed 9.3 IC11.1
Element: Unit Weight This field contains the unit weight of
the item based on the stocking UOM.
ITO-CUBIC-FEET Signed 9.3 IC11.1
Element: 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 Cost displayed for the unit cost field.
ITO-LOT-TRACK-FL Alpha 1 IC11.1
Element: All Flag
ITO-SER-TRACK-FL Alpha 1 IC11.1
Element: 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
Element: All Flag
ITO-REUSE-FL Alpha 1 IC11.1
Element: 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
Element: Broken Case ChThis 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
Element: Item Number
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 30 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 30 IC11.1
Item Mster User This field is the third user definable
Defined Field2 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 30 IC11.1
Item Mster User This field is the fourth user definable
Defined Field2 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 30 IC11.1
Item Mster User This field is the fifth user definable
Defined Field2 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 18.5 IC11.1
Element: Intl Cost This field is the first user definable
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 18.5 IC11.1
Element: Intl Cost This field is the second user definable
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 18.5 IC11.1
Element: Intl Cost This field is the third user definable
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
Element: Date Item was Added
ITO-MSDS-FLAG Alpha 1 IC11.1
Element: All Flag This flag indicates if this item
requires a Material Safety Data Sheet.
ITO-ACTIVE-STATUS Alpha 1 IC11.1
Element: 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
Element: Unit of MeasurThese are the alternate units of 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
Unit of Measure 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
Element: All 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
Element: Transaction FlThis 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
Element: Account 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
Element: Account 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
Element: 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
Element: Unit 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
Element: Cubic Feet This is the cubic measure of the packed
alternate unit of measure.
ITO-INSP-REQ-FL Alpha 1 IC11.1
Element: All Flag This flag indicates whether this item
has to be inspected when received via
PO.
ITO-ICN-CODE Alpha 8 IC11.1
Element: Icn Code
ITO-CONSIGNMENT-FL Alpha 1 IC11.1
Element: Consignment Fl
ITEMASTOUT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ITOSET1 ITEM-GROUP IC311
COMPANY
ITEM
CREATION-DATE
CREATION-TIME
ITOSET2 ITEM-GROUP
ITEM
INVEN-MAJCL
INVEN-MINCL
COMPANY
CREATION-DATE
CREATION-TIME
ITOSET3 ITEM-GROUP
ITEM
RECORD-STAT
COMPANY
CREATION-DATE
CREATION-TIME
|
