|
|
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 The company number represents an
established company and is entered on
all function codes.
ITO-ITEM Alpha 32 IC11.1
Element: Item Number This field contains the item
identifier.
ITO-CREATION-DATE Numeric 8 (yyyymmdd) IC11.1
Element: Date
ITO-CREATION-TIME Numeric 6 (hhmmss) IC11.1
Element: Sys 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
ITO-STOCK-UOM Alpha 4 IC11.1
Element: Unit of Measure
ITO-SEC-UOM Alpha 4 IC11.1
Element: Unit of Measure
ITO-SEC-UOM-MULT Signed 13.7 IC11.1
Unit of Measure
Multiplier
ITO-SEC-UOM-CONV Signed 10.5 IC11.1
AlternateUOM
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
Element: Bus 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
ITO-PURCH-MINCL Alpha 4 IC11.1
Element: Minor Class
ITO-INVEN-MAJCL Alpha 4 IC11.1
Element: Major Class
ITO-INVEN-MINCL Alpha 4 IC11.1
Element: Minor Class
ITO-SALES-MAJCL Alpha 4 IC11.1
Element: Major Class
ITO-SALES-MINCL Alpha 4 IC11.1
Element: Minor 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
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 cubic 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
for Cost
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 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
Defined Field2
ITO-USER-FIELD4 Alpha 10 (Lower Case) IC11.1
Item Mster User
Defined Field2
ITO-USER-FIELD5 Alpha 10 (Lower Case) IC11.1
Item Mster User
Defined Field2
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
Numeric Field 1
ITO-USER-FIELD-N3 Signed 13.5 IC11.1
User Defined
Numeric Field 1
ITO-ADDED-DATE Numeric 8 (yyyymmdd) IC11.1
Element: Date
ITO-MSDS-FLAG Alpha 1 IC11.1
Element: All Flag
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 Measure
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
Multiplier
ITO-TRACKING-FL Alpha 1 Occurs 10 Times IC11.1
Element: All Flag
ITO-TRANS-FL Alpha 1 Occurs 10 Times IC11.1
Element: Account Flag
ITO-SELL-FL Alpha 1 Occurs 10 Times IC11.1
Element: Account Flag
ITO-SELL-PRICE-FL Alpha 1 Occurs 10 Times IC11.1
Element: Account Flag
ITO-BUY-FL Alpha 1 Occurs 10 Times IC11.1
Element: Account Flag
ITO-PACKING-WEIGHT Signed 9.3 Occurs 10 Times IC11.1
Element: Unit Weight
ITO-PACKING-CUBIC Signed 9.3 Occurs 10 Times IC11.1
Element: Cubic Feet
ITO-INSP-REQ-FL Alpha 1 IC11.1
Element: All Flag
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
|
