ITEMASTOUT

UPDATED BY
IC11.1 IC311

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ITO-ITEM-GROUP
Element: Item Group
Alpha 5
This field contains the identifier for a group of items that can be shared by one or more companies.
IC11.1
ITO-COMPANY
Element: Company
Numeric 4
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.
IC11.1
ITO-ITEM
Element: Item
Alpha 32
This field contains the item identifier.
IC11.1
ITO-CREATION-DATE
Element: Creation Date
Numeric 8 (yyyymmdd)
This is the date that this line was added to the requisition.
IC11.1
ITO-CREATION-TIME
Element: Creation Time
Numeric 6 (hhmmss)
The creation time.
IC11.1
ITO-RECORD-TYPE
Element: Record Type
Alpha 1
This field identifies the type of record defined. Valid values are: S = Summary D = Detail
IC11.1
ITO-RECORD-STAT
Element: Record Stat
Numeric 1
IC11.1
ITO-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
IC11.1
ITO-DESCRIPTION2
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
IC11.1
ITO-STOCK-UOM
Element: Uom
Alpha 4
This field contains the valid stock unit of measure for this item.
IC11.1
ITO-SEC-UOM
Element: Uom
Alpha 4
This field contains the valid stock unit of measure for this item.
IC11.1
ITO-SEC-UOM-MULT
Element: Uom Mult
Signed 13.7
This field contains the multiplier for converting this unit of measure to the stock unit of measure.
IC11.1
ITO-SEC-UOM-CONV
Element: Alt Uom Conv
Signed 10.5
This is the conversion factor from the alternate unit of measure to the stock unit of measure.
IC11.1
ITO-CTW-CODE
Element: Ctw Code
Alpha 1
This code indicates if this item is a catch weight item. A catch weight item tracks two quantities, with two different units of measure.
IC11.1
ITO-CTW-VAR-PCT
Element: Ctw Var Pct
Signed 5.2
This field is the catch weight variance 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.
IC11.1
ITO-GENERIC
Element: Generic
Alpha 10
A user-defined general name for an item, used for searching for an item.
IC11.1
ITO-FREIGHT-CLASS
Element: Freight Class
Alpha 4
The user definable freight classification code. This is used in the Order Entry system to categorize items on the Bill of Lading.
IC11.1
ITO-PURCH-MAJCL
Element: Major Class
Alpha 4
IC11.1
ITO-PURCH-MINCL
Element: Minor Class
Alpha 4
IC11.1
ITO-INVEN-MAJCL
Element: Major Class
Alpha 4
IC11.1
ITO-INVEN-MINCL
Element: Minor Class
Alpha 4
IC11.1
ITO-SALES-MAJCL
Element: Major Class
Alpha 4
IC11.1
ITO-SALES-MINCL
Element: Minor Class
Alpha 4
IC11.1
ITO-MANUF-CODE
Element: Manuf Code
Alpha 4
This field contains a user defined code that indicates the manufacturer of an item.
IC11.1
ITO-MANUF-DIVISION
Element: Manuf Division
Alpha 4
This is a user defined code that indicates which division of a manufacturer is tied to an item.
IC11.1
ITO-MANUF-NUMBER
Element: Manuf Nbr
Alpha 35
IC11.1
ITO-HAZARD-CODE
Element: Hazard Code
Alpha 8
This field contains a short code describing why an item can be hazardous.
IC11.1
ITO-PURCH-TAX-FL
Element: Purch Tax Fl
Alpha 1
This field indicates if this item is taxable when it is purchased for this location. Valid values are: N = Nontaxable. Default value. Y = Taxable.
IC11.1
ITO-PURCH-TAX-CD
Element: Tax Code
Alpha 10
This field contains a code representing specific tax information. This must be valid Tax Code.
IC11.1
ITO-PURCH-TAX-CAT
Element: Purch Tax Cat
Alpha 15
IC11.1
ITO-HARMONIZE-CD
Element: Harmonize Cd
Alpha 11
Harmonize Class code.
IC11.1
ITO-UPC
Element: Upc
Alpha 15
Universal Product Code.
IC11.1
ITO-WEIGHT
Element: Weight
Signed 9.3
This field contains the unit weight of the item based on the stocking UOM.
IC11.1
ITO-CUBIC-FEET
Element: Cubic Feet
Signed 9.3
This field contains the unit cubic feet of the item based on the stocking UOM.
IC11.1
ITO-NBR-DEC-QTY
Element: Nbr Dec Qty
Numeric 1
Number of decimals to be entered and displayed for the cost field.
IC11.1
ITO-NBR-DEC-COST
Element: Nbr Dec Cost
Numeric 1
Number of decimals to be entered and displayed for the unit cost field.
IC11.1
ITO-NBR-DEC-PRICE
Element: Nbr Dec Cost
Numeric 1
Number of decimals to be entered and displayed for the unit cost field.
IC11.1
ITO-LOT-TRACK-FL
Element: All Flag
Alpha 1
IC11.1
ITO-SER-TRACK-FL
Element: Ser Track Fl
Alpha 1
IC11.1
ITO-CERT-REQ-FL
Element: Cert Req Fl
Alpha 1
This flag indicates whether a 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.
IC11.1
ITO-KIT-ITEM-FL
Element: All Flag
Alpha 1
IC11.1
ITO-REUSE-FL
Element: Reuse Fl
Alpha 1
This flag indicates that this item is a reusable item. It can be used then reconditioned and used again.
IC11.1
ITO-BRKN-CS-CHRG
Element: Brkn Cs Chrg
Alpha 1
This flag determines if there is a charge if a broken case is required to satisfy an order in Order Entry.
IC11.1
ITO-REPLACE-ITEM
Element: Item
Alpha 32
This field contains the item identifier.
IC11.1
ITO-USER-FIELD1
Element: User Field1
Alpha 30
This is the first user definable field. It can be used to capture any data that the user wants. The title of the field is setup in IC00.
IC11.1
ITO-USER-FIELD2
Element: User Field2
Alpha 30
This is the second user definable 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.
IC11.1
ITO-USER-FIELD3
Element: User Field2
Alpha 30
This is the second user definable 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.
IC11.1
ITO-USER-FIELD4
Element: User Field2
Alpha 30
This is the second user definable 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.
IC11.1
ITO-USER-FIELD5
Element: User Field2
Alpha 30
This is the second user definable 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.
IC11.1
ITO-USER-FIELD-N1
Element: Intl Cost
Signed 18.5
IC11.1
ITO-USER-FIELD-N2
Element: Intl Cost
Signed 18.5
IC11.1
ITO-USER-FIELD-N3
Element: Intl Cost
Signed 18.5
IC11.1
ITO-ADDED-DATE
Element: Added Date
Numeric 8 (yyyymmdd)
IC11.1
ITO-MSDS-FLAG
Element: All Flag
Alpha 1
IC11.1
ITO-ACTIVE-STATUS
Element: Active Status
Alpha 1
The status of the account. If Inactive, no posting can be done to the account.
IC11.1
ITO-ALT-UOM
Element: Uom
Alpha 4 Occurs 10 Times
This field contains the valid stock unit of measure for this item.
IC11.1
ITO-ALT-UOM-CONV
Element: Alt Uom Conv
Signed 10.5 Occurs 10 Times
This is the conversion factor from the alternate unit of measure to the stock unit of measure.
IC11.1
ITO-ALT-UOM-MULT
Element: Uom Mult
Signed 13.7 Occurs 10 Times
This field contains the multiplier for converting this unit of measure to the stock unit of measure.
IC11.1
ITO-TRACKING-FL
Element: All Flag
Alpha 1 Occurs 10 Times
IC11.1
ITO-TRANS-FL
Element: Trans Fl
Alpha 1 Occurs 10 Times
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.
IC11.1
ITO-SELL-FL
Element: Account Flag
Alpha 1 Occurs 10 Times
IC11.1
ITO-SELL-PRICE-FL
Element: Account Flag
Alpha 1 Occurs 10 Times
IC11.1
ITO-BUY-FL
Element: Buy Fl
Alpha 1 Occurs 10 Times
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.
IC11.1
ITO-PACKING-WEIGHT
Element: Weight
Signed 9.3 Occurs 10 Times
This field contains the unit weight of the item based on the stocking UOM.
IC11.1
ITO-PACKING-CUBIC
Element: Cubic Feet
Signed 9.3 Occurs 10 Times
This field contains the unit cubic feet of the item based on the stocking UOM.
IC11.1
ITO-INSP-REQ-FL
Element: All Flag
Alpha 1
IC11.1
ITO-ICN-CODE
Element: Icn Code
Alpha 8
IC11.1
ITO-CONSIGNMENT-FL
Element: Consignment Fl
Alpha 1
IC11.1


ITEMASTOUT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ITOSET1 ITEM-GROUP
COMPANY
ITEM
CREATION-DATE
CREATION-TIME
IC311
ITOSET2 ITEM-GROUP
ITEM
INVEN-MAJCL
INVEN-MINCL
COMPANY
CREATION-DATE
CREATION-TIME
ITOSET3 ITEM-GROUP
ITEM
RECORD-STAT
COMPANY
CREATION-DATE
CREATION-TIME


File created: Thu Jun 09 02:18:56 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.