ITEMASTOUT FILE UPDATED BY IC10.2 IC11.1 IC311 IC811 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY ITO-ITEM-GROUP Alpha 5 IC10.2 IC11.1 Item Group This field contains the identifier for IC811 a group of items that can be shared by one or more companies. ITO-COMPANY Numeric 4 IC10.2 IC11.1 Company The company number represents an IC811 established company and is entered on all function codes. ITO-ITEM Alpha 32 IC10.2 IC11.1 Item Number This field contains the item IC811 identifier. ITO-CREATION-DATE Numeric 8 (yyyymmdd) IC10.2 IC11.1 Creation Date This is the date that this line was IC811 added to the requisition. ITO-CREATION-TIME Numeric 6 (hhmmss) IC10.2 IC11.1 Creation Time The creation time. IC811 ITO-RECORD-TYPE Alpha 1 IC10.2 IC11.1 Record Type This field identifies the type of IC811 record defined. Valid values are: S=Summary D=Detail ITO-RECORD-STAT Numeric 1 IC10.2 IC11.1 Record Stat IC811 ITO-DESCRIPTION Alpha 30 (Lower Case) IC10.2 IC11.1 Description This field contains the description. IC811 ITO-DESCRIPTION2 Alpha 30 (Lower Case) IC10.2 IC11.1 Second Description This field contains the second line of IC811 the description. ITO-STOCK-UOM Alpha 4 IC10.2 IC11.1 Stocking Unit of This is the stock unit of measure for IC811 Measure the item. ITO-SEC-UOM Alpha 4 IC10.2 IC11.1 Secondary Unit of This field contains the secondary IC811 Measure quantity unit of measure. ITO-SEC-UOM-MULT Signed 13.7 IC10.2 IC11.1 Secondary UOM This field contains the secondary IC811 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 IC10.2 IC11.1 Secondary UOM This is the secondary unit of measure IC811 ConversionFactor conversion factor. ITO-CTW-CODE Alpha 1 IC10.2 IC11.1 Catch Weight Code This code indicates if this item is a IC811 catch weight item. A catch weight item tracks two quantities, with two different units of measure. ITO-CTW-VAR-PCT Signed 5.2 IC10.2 IC11.1 Catch Weight This field is the catch weight variance IC811 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 IC10.2 IC11.1 Generic Name A user-defined general name for an IC811 item, used for searching for an item. ITO-FREIGHT-CLASS Alpha 4 IC10.2 IC11.1 Freight Class The user definable freight IC811 classification code. This is used in the Order Entry system to categorize items on the Bill of Lading. ITO-PURCH-MAJCL Alpha 4 IC10.2 IC11.1 Major Purchasing The user defined Major Purchasing Class IC811 Class identifier. ITO-PURCH-MINCL Alpha 4 IC10.2 IC11.1 Minor Purchasing The user defined Minor purchasing Class IC811 Class identifier. ITO-INVEN-MAJCL Alpha 4 IC10.2 IC11.1 Inventory Major The user defined Major Inventory Class IC811 Class code. ITO-INVEN-MINCL Alpha 4 IC10.2 IC11.1 Inventory Minor The user defined Minor Inventory Class IC811 Class code within the major class. ITO-SALES-MAJCL Alpha 4 IC10.2 IC11.1 Sales Major Class This field contains the sales major IC811 class code. ITO-SALES-MINCL Alpha 4 IC10.2 IC11.1 Sales Minor Class This field contains the sales minor IC811 class code within the major class. ITO-MANUF-CODE Alpha 4 IC10.2 IC11.1 Manufacturer's Code This field contains a user defined code IC811 that indicates the manufacturer of an item. ITO-MANUF-DIVISION Alpha 4 IC10.2 IC11.1 Manufacturer's This is a user defined code that IC811 Division indicates which division of a manufacturer is tied to an item. ITO-MANUF-NUMBER Alpha 15 IC10.2 IC11.1 Manuf Number IC811 ITO-HAZARD-CODE Alpha 8 IC10.2 IC11.1 Hazard Code This field contains a short code IC811 describing why an item can be hazardous. ITO-PURCH-TAX-FL Alpha 1 IC10.2 IC11.1 Purchasing Tax Flag This field indicates if this item is IC811 taxable when it is purchased for this location. Valid values are: N = Nontaxable. Default value. Y = Taxable. ITO-PURCH-TAX-CD Alpha 10 IC10.2 IC11.1 Purchasing Tax This code is used to determine if this IC811 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 IC10.2 IC11.1 Purch Tax Cat IC811 ITO-HARMONIZE-CD Alpha 11 IC10.2 IC11.1 Harmonize Code Harmonize Class code. IC811 ITO-UPC Alpha 13 IC10.2 IC11.1 Universal Product Universal Product Code IC811 Code ITO-WEIGHT Signed 9.3 IC10.2 IC11.1 Unit Weight This field contains the unit weight of IC811 the item based on the stocking UOM. ITO-CUBIC-FEET Signed 9.3 IC10.2 IC11.1 Cubic Feet This field contains the unit cubit feet IC811 of the item based on the stocking UOM. ITO-NBR-DEC-QTY Numeric 1 IC10.2 IC11.1 Nbr of Decimals for Number of decimals to be entered and IC811 Quantity displayed for the cost field. ITO-NBR-DEC-COST Numeric 1 IC10.2 IC11.1 Number of Decimals Number of decimals to be entered and IC811 for Cost displayed for the unit cost field. ITO-NBR-DEC-PRICE Numeric 1 IC10.2 IC11.1 Number of Decimals Number of decimals to be entered and IC811 for Price displayed for the unit cost field. ITO-LOT-TRACK-FL Alpha 1 IC10.2 IC11.1 Lot Tracking Flag IC811 ITO-SER-TRACK-FL Alpha 1 IC10.2 IC11.1 Serial Tracking Flag IC811 ITO-CERT-REQ-FL Alpha 1 IC10.2 IC11.1 Certification This flag indicates whether a IC811 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 IC10.2 IC11.1 Kit Item Flag IC811 ITO-REUSE-FL Alpha 1 IC10.2 IC11.1 Reuse Fl This flag indicates that this item is a IC811 reusable item. It can be used then reconditioned and used again. ITO-BRKN-CS-CHRG Alpha 1 IC10.2 IC11.1 Broken Case Charge This flag determines if there is a IC811 charge if a broken case is required to satisfy an order in Order Entry. ITO-REPLACE-ITEM Alpha 32 IC10.2 IC11.1 Replacement Item IC811 ITO-USER-FIELD1 Alpha 30 IC10.2 IC11.1 Item Mster User This is the first user definable field. IC811 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) IC10.2 IC11.1 Item Mster User This is the second user definable field. IC811 Defined Field2 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) IC10.2 IC11.1 Item Mster User This field is the third user definable IC811 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) IC10.2 IC11.1 Item Mster User This field is the fourth user definable IC811 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) IC10.2 IC11.1 User Mster User This field is the fifth user definable IC811 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 IC10.2 IC11.1 User Defined This field is the first user definable IC811 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 IC10.2 IC11.1 User Defined This field is the second user definable IC811 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 IC10.2 IC11.1 User Defined This field is the third user definable IC811 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) IC10.2 IC11.1 Date Item was Added IC811 ITO-MSDS-FLAG Alpha 1 IC10.2 IC11.1 Material Safety This flag indicates if this item IC811 DataSheet Flag requires a Material Safety Data Sheet. ITO-ACTIVE-STATUS Alpha 1 IC10.2 IC11.1 Status The status of the account. If Inactive, IC811 no posting can be done to the account. ITO-ALT-UOM Alpha 4 Occurs 6 Times IC10.2 IC11.1 Alternate Unit of These are the alternate units of measure IC811 Measure for this item. ITO-ALT-UOM-CONV Signed 10.5 Occurs 6 Times IC10.2 IC11.1 AlternateUOM This is the conversion factor from the IC811 Conversion Factor alternate unit of measure to the stock unit of measure. ITO-ALT-UOM-MULT Signed 13.7 Occurs 6 Times IC10.2 IC11.1 Alternate UOM This is the multiplier for converting IC811 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 6 Times IC10.2 IC11.1 Tracking Flag This flag specifies if quantities are to IC811 be tracked by this alternate unit of measure. ITO-TRANS-FL Alpha 1 Occurs 6 Times IC10.2 IC11.1 Transaction Flag This flag specifies if this alternate IC811 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 6 Times IC10.2 IC11.1 Selling Flag This flag specifies if this alternate IC811 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 6 Times IC10.2 IC11.1 Sell Price Flag This flag specifies if this alternate IC811 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 6 Times IC10.2 IC11.1 Buying Flag This flag specifies if this alternate IC811 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 6 Times IC10.2 IC11.1 Packing Weight This is the packed weight of an item in IC811 the alternate unit of measure. ITO-PACKING-CUBIC Signed 9.3 Occurs 6 Times IC10.2 IC11.1 Packing Cubic This is the cubic measure of the packed IC811 alternate unit of measure. ITO-INSP-REQ-FL Alpha 1 IC10.2 IC11.1 Inspection Required This flag indicates whether this item IC811 Flag has to be inspected when received via PO. 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 |