Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ITEMGROUP


                             ITEMGROUP FILE

                               Item Group

The Item Group file stores the names of valid item groups. This file allows
companies to share Item Master records or to keep them separate by company.

REFERENCED BY

AP125     AP126     AP131     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP21.1    AP23.1    AP25.1
AP25.2    AP26.1    AP27.1    AP30.4    API1.1    BL00.1
BL120     BL122     BL130     BL20.1    BL20.3    BL200
BL21.2    BL21.5    BL29.1    BL29.2    BL520     BL80.1
BL820     BL92.1    IC01.1    IC01.4    IC05.1    IC06.1
IC07.1    IC08.1    IC09.1    IC11.1    IC11.2    IC11.3
IC11.4    IC11.5    IC11.6    IC13.1    IC14.1    IC16.1
IC18.1    IC200     IC201     IC205     IC206     IC207
IC208     IC209     IC210     IC211     IC212     IC213
IC236     IC30.1    IC330     IC39.1    IC811     ICI4.1
ICI5.1    ICI6.1    ICI7.1    ICI8.1    ICIC.1    ICIG.1
MA180     MA41.1    MA41.2    MA41.4    MA41.7    MA43.1
MA43.2    MA43.3    MA43.7    MA530     MA531     MA60.2
MA60.3    MA60.5    MA61.1    MA66.2    MA66.3    MA67.2
MA67.3    MA68.2    MA68.3    MA68.5    MA70.1    MA75.1
MA80.1    MAI1.1    PD10.1    PD10.2    PD130     PD20.1
PD20.2    PD20.3    PO00.1    PO100     PO101     PO122
PO130     PO131     PO137     PO150     PO20.1    PO21.1
PO21.2    PO21.3    PO21.4    PO21.5    PO22.1    PO220
PO23.1    PO230     PO24.1    PO25.1    PO25.5    PO25.6
PO25.7    PO27.2    PO28.1    PO29.1    PO30.1    PO30.2
PO30.3    PO300     PO31.1    PO31.2    PO32.2    PO32.4
PO33.1    PO34.1    PO35.1    PO36.1    PO36.2    PO38.1
PO39.1    PO39.2    PO44.1    PO50.1    PO52.1    PO520
PO536     PO560     POA2.3    POCP.1    POI3.1    POID.1
POII.1    POIJ.1    RQ10.1    RQ10.2    RQ10.3    RQ11.1
RQ250     RQ35.1    RQ500     RQIA.1    RQID.1    RQIF.1
RQIH.1    RQIJ.1    WH02.1    WH130     WH20.2    WH20.7
WH224

UPDATED BY

IC00.1    IC00.2    IC00.3

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ITG-ITEM-GROUP         Alpha 5                                   IC00.1  IC00.2
Element: Item Group    This field contains the identifier for    IC00.3
                       a group of items that can be shared by
                       one or more companies.

ITG-DESCRIPTION        Alpha 30  (Lower Case)                    IC00.1
Element: Description   This field contains the description of
                       the item group.

ITG-AUDIT-ITEM-FL      Alpha 1                                   IC00.1
Element: All Flag      This field contains the option to audit
                       all changes made to items in the Item
                       Master file for an item group.
                       N = No
                       Y = Yes

ITG-DEF-DEC-COST       Numeric 1                                 IC00.1
Element: Def Dec Cost  This field contains the default value
                       for the number of decimal places in cost
                       fields.
                       0
                       1
                       2
                       3
                       4
                       5

ITG-DEF-DEC-PRICE      Numeric 1                                 IC00.1
Element: Def Dec Cost  This field contains the default value
                       for the number of decimal places in the
                       price fields.
                       0
                       1
                       2
                       3
                       4
                       5

ITG-COM-TYPE           Alpha 1 Occurs 10 Times                   IC00.2
Element: Com Type      This field contains valid item comment
                       types for this item group.

ITG-COM-TYPE-DESC      Alpha 10  (Lower Case)                    IC00.2
Element: Bin Type Desc Occurs 10 Times
                       This field contains descriptions of
                       comment types.

ITG-IC210.html">COM-OPT-IC210      Alpha 1 Occurs 10 Times                   IC00.3
Element: Com Opt Ic110 These fields determine which comment
                       types are printed on Item Master Listing
                       (IC210).
                       X = Print Comments

ITG-IC211.html">COM-OPT-IC211      Alpha 1 Occurs 10 Times                   IC00.3
Element: Com Opt Ic110 These fields determine which comment
                       types are printed on Item Location
                       Listing (IC211).
                       X = Print Comments

ITG-COM-OPT-IC110      Alpha 1 Occurs 10 Times                   IC00.3
Element: Com Opt Ic110 These fields determine which comment
                       types are printed on Intransit Shipping
                       (IC110).
                       X = Print Comments

ITG-DEF-ITEM-CR-FL     Alpha 1                                   IC00.1
Element: Def Item Cr FlDefault item create flag is needed for
                       the creation of new item numbers when
                       importing vendor catalogs in PO536 or
                       manually entering price agreements in
                       PO25. If no Item Create Flag is supplied
                       during the creation of an agreement,
                       this value will default.  Valid values
                       are, 1 to create the next sequential
                       item number, 2 to assign the item number
                       from another field, and 3 to manually
                       input the new item number.
                       1 = Sequential
                       2 = Assign
                       3 = Manual Input

ITG-DEF-ITEM-AS-FL     Alpha 1
Element: Item Asgn Fld If the item create flag is set to
                       assign, this indicates the field from
                       which the new item number is assigned.
                       " " = None
                       1 = VENDOR-ITEM
                       2 = MFG-ITEM
                       3 = UPC
                       4 = SKU
                       5 = HIBCC-UPN
                       6 = UCCEAN-UPN
                       7 = NDC

ITG-COMM-STRUCTURE     Alpha 20                                  IC00.1
Element: Comm Structure

                         ITEMGROUP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ITGSET1   ITEM-GROUP                                             AP125   AP126
                                                                 AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL00.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL200
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL80.1
                                                                 ...

                         ITEMGROUP FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        ICCOMPANY    Delete Restricted

                            ITG-ITEM-GROUP    -> ICC-ITEM-GROUP
                                                 ICC-COMPANY

Hazardcode     HAZARD       Delete Restricted

                            ITG-ITEM-GROUP    -> HAZ-ITEM-GROUP
                                                 HAZ-HAZARD-CODE

Icvaluom       ICVALUOM

                            ITG-ITEM-GROUP    -> ICV-ITEM-GROUP
                                                 ICV-VALID-UOM

Inv Class      MAJORCL      Delete Restricted

                            ITG-ITEM-GROUP    -> MAJ-ITEM-GROUP
                            "I"               -> MAJ-CLASS-TYPE
                                                 MAJ-MAJOR-CLASS

Itemmaster     ITEMMAST     Delete Restricted

                            ITG-ITEM-GROUP    -> ITE-ITEM-GROUP
                                                 ITE-ITEM

Purch Class    MAJORCL      Delete Restricted

                            ITG-ITEM-GROUP    -> MAJ-ITEM-GROUP
                            "P"               -> MAJ-CLASS-TYPE
                                                 MAJ-MAJOR-CLASS

Sales Class    MAJORCL      Delete Restricted

                            ITG-ITEM-GROUP    -> MAJ-ITEM-GROUP
                            "S"               -> MAJ-CLASS-TYPE
                                                 MAJ-MAJOR-CLASS