|
|
ITEMASTOUT FILE
UPDATED BY
IC11.1
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 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 displays the description.
ITO-STOCK-UOM Alpha 4 IC11.1
Element: Uom This field contains the valid stock
unit of measure for this item.
ITO-SEC-UOM Alpha 4 IC11.1
Element: Uom This field contains the valid stock
unit of measure for this item.
ITO-SEC-UOM-MULT Signed 13.7 IC11.1
Element: Uom Mult This field contains the multiplier for
converting this unit of measure to the
stock unit of measure.
ITO-SEC-UOM-CONV Signed 10.5 IC11.1
Element: Alt Uom Conv This is the conversion factor from the
alternate unit of measure to the stock
unit of measure.
ITO-CTW-CODE Alpha 1 IC11.1
Element: Ctw 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
Element: Ctw Var Pct 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.
ITO-GENERIC Alpha 10 IC11.1
Element: Generic 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: Manuf Code This field contains a user defined code
that indicates the manufacturer of an
item.
ITO-MANUF-DIVISION Alpha 4 IC11.1
Element: Manuf DivisionThis is a user defined code that
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: Purch Tax Fl 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
Element: Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
ITO-PURCH-TAX-CAT Alpha 15 IC11.1
Element: Purch Tax Cat
ITO-HARMONIZE-CD Alpha 11 IC11.1
Element: Harmonize Cd Harmonize Class code.
ITO-UPC Alpha 15 IC11.1
Element: Upc Universal Product Code.
ITO-WEIGHT Signed 9.3 IC11.1
Element: 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
Element: Nbr Dec Qty Number of decimals to be entered and
displayed for the cost field.
ITO-NBR-DEC-COST Numeric 1 IC11.1
Element: Nbr Dec Cost Number of decimals to be entered and
displayed for the unit cost field.
ITO-NBR-DEC-PRICE Numeric 1 IC11.1
Element: Nbr Dec Cost Number of decimals to be entered and
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: Ser Track Fl
ITO-CERT-REQ-FL Alpha 1 IC11.1
Element: Cert Req Fl 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.
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: Brkn Cs Chrg 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
Element: Item This field contains the item
identifier.
ITO-USER-FIELD1 Alpha 30 IC11.1
Element: User Field1 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.
ITO-USER-FIELD2 Alpha 30 IC11.1
Element: User Field2 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.
ITO-USER-FIELD3 Alpha 30 IC11.1
Element: User Field2 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.
ITO-USER-FIELD4 Alpha 30 IC11.1
Element: User Field2 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.
ITO-USER-FIELD5 Alpha 30 IC11.1
Element: User Field2 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.
ITO-USER-FIELD-N1 Signed 18.5 IC11.1
Element: Intl Cost
ITO-USER-FIELD-N2 Signed 18.5 IC11.1
Element: Intl Cost
ITO-USER-FIELD-N3 Signed 18.5 IC11.1
Element: Intl Cost
ITO-ADDED-DATE Numeric 8 (yyyymmdd) IC11.1
Element: Added Date
ITO-MSDS-FLAG Alpha 1 IC11.1
Element: All Flag
ITO-ACTIVE-STATUS Alpha 1 IC11.1
Element: Active 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: Uom This field contains the valid stock
unit of measure for this item.
ITO-ALT-UOM-CONV Signed 10.5 Occurs 10 Times IC11.1
Element: Alt Uom Conv This is the conversion factor from the
alternate unit of measure to the stock
unit of measure.
ITO-ALT-UOM-MULT Signed 13.7 Occurs 10 Times IC11.1
Element: Uom Mult This field contains the multiplier for
converting this unit of measure to the
stock unit of measure.
ITO-TRACKING-FL Alpha 1 Occurs 10 Times IC11.1
Element: All Flag
ITO-TRANS-FL Alpha 1 Occurs 10 Times IC11.1
Element: Trans Fl 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
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: Buy Fl 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: Weight This field contains the unit weight of
the item based on the stocking UOM.
ITO-PACKING-CUBIC Signed 9.3 Occurs 10 Times IC11.1
Element: Cubic Feet This field contains the unit cubic feet
of the item based on the stocking UOM.
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
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
|
