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     AP25.1    AP25.2    AP26.1
AP27.1    AP30.4    BL00.1    BL120     BL122     BL130
BL20.1    BL20.3    BL200     BL21.2    BL21.5    BL29.1
BL29.2    BL520     BL80.1    BL820     BL92.1    DR100
IC01.1    IC01.4    IC05.1    IC06.1    IC07.1    IC08.1
IC09.1    IC10.1    IC10.2    IC11.1    IC11.2    IC11.3
IC11.4    IC11.5    IC11.6    IC110     IC13.1    IC14.1
IC141     IC142     IC153     IC16.1    IC18.1    IC191
IC200     IC201     IC205     IC206     IC207     IC208
IC209     IC210     IC211     IC212     IC213     IC236
IC260     IC28.1    IC30.1    IC330     IC34.1    IC35.1
IC36.1    IC39.1    IC60.1    IC60.2    IC60.3    IC61.1
IC65.1    IC811     IC83.1    ICI4.1    ICI5.1    ICI6.1
ICI7.1    ICI8.1    ICIC.1    ICIG.1    PC08.1    MA180
MA530     MA531     MA60.2    MA60.3    MA60.5    MA61.1
MA66.2    MA66.3    MA67.1    MA67.2    MA70.1    MA75.1
MA80.1    MAI1.1    OE10.1    OE10.2    OE10.3    OE10.4
OE10.5    OE10.6    OE10.7    OE10.8    OE11.1    OE11.4
OE11.8    OE11.9    OE110     OE111     OE112     OE113
OE114     OE116     OE129     OE13.2    OE13.3    OE13.5
OE13.6    OE14.4    OE229     OE30.1    OE30.2    OE30.3
OE30.4    OE30.5    OE30.6    OE30.7    OE30.9    OE510
OE530     OE55.1    OE55.2    OE81.1    OE810     OE830
OE90.1    OE90.2    PO00.1    PO100     PO101     PO122
PO130     PO131     PO137     PO150     PO20.1    PO21.2
PO21.3    PO21.4    PO21.5    PO22.1    PO220     PO23.1
PO230     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    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    POIE.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     WO131     WODM.2

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
Default Nbr            This field contains the default value
Decimals for Cost      for the number of decimal places in cost
                       fields.
                       0
                       1
                       2
                       3
                       4
                       5

ITG-DEF-DEC-PRICE      Numeric 1                                 IC00.1
Default Nbr            This field contains the default value
Decimals for Cost      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: Comment 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 DescrOccurs 10 Times
                       This field contains descriptions of
                       comment types.

ITG-IC210.html">COM-OPT-IC210      Alpha 1 Occurs 10 Times                   IC00.3
Comment Option for     These fields determine which comment
IC110                  types are printed on Item Master Listing
                       (IC210).
                       X = Print Comments

ITG-IC211.html">COM-OPT-IC211      Alpha 1 Occurs 10 Times                   IC00.3
Comment Option for     These fields determine which comment
IC110                  types are printed on Item Location
                       Listing (IC211).
                       X = Print Comments

ITG-IC110.html">COM-OPT-IC110      Alpha 1 Occurs 10 Times                   IC00.3
Comment Option for     These fields determine which comment
IC110                  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 " " = None
                       1 = VENDOR-ITEM
                       2 = MFG-ITEM
                       3 = UPC
                       4 = SKU
                       5 = HIBCC-UPN
                       6 = UCCEAN-UPN
                       7 = NDC

                         ITEMGROUP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ITGSET1   ITEM-GROUP                                             AP125   AP126
                                                                 AP131   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 BL00.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL200   BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL80.1  BL820
                                                                 BL92.1  DR100
                                                                 IC00.1  IC00.2
                                                                 IC00.3  IC00.5
                                                                 IC01.1  IC01.4
                                                                 ...

                         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