Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ICITEMCODE


                            ICITEMCODE FILE

REFERENCED BY

PD21.1

UPDATED BY

IC11.1    IC16.1    IC330     IC516     IC811     PO150
PO25.6    PO25.7    PO36.2    PO536

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

IIC-ITEM-GROUP         Alpha 5                                   IC11.1  IC16.1
Element: Item Group    This field contains the identifier for    IC330   IC516
                       a group of items that can be shared by    IC811   PO150
                       one or more companies.                    PO25.6  PO25.7
                                                                 PO36.2  PO536

IIC-ICSEGMENT          Alpha 2                                   IC11.1  IC16.1
Element: Icsegment     The ICSEGMENT is the first part of a      IC330   IC516
                       four part item hierarchy structure. The   IC811   PO150
                       ICSEGMENT is the top level of the         PO25.6  PO25.7
                       hierarchy. All levels of the hierarchy    PO36.2  PO536
                       are two characters.  This hierarchy also
                       can be used to store UNSPSC codes and
                       descriptions.

IIC-ICFAMILY           Alpha 2                                   IC11.1  IC16.1
Element: Icfamily      ICFAMILY is the second level of the       IC330   IC516
                       product hierarchy.  If the ICFAMILY       IC811   PO150
                       field has a 00 in it, this indicates      PO25.6  PO25.7
                       that this code is for describing the      PO36.2  PO536
                       segment.  If there is a 00 the code
                       parts below this should also be 00.

IIC-ICCLASS            Alpha 2                                   IC11.1  IC16.1
Element: Icclass       ICCLASS is the third level of the         IC330   IC516
                       hierarchy.  If this is 00 and the code    IC811   PO150
                       parts below this are 00, then this code   PO25.6  PO25.7
                       is for describing the ICFAMILY field      PO36.2  PO536
                       level.

IIC-ICCOMMODITY        Alpha 2                                   IC11.1  IC16.1
Element: Iccommodity   ICCOMMODITY is the fourth and last        IC330   IC516
                       level of the hierarchy.  All levels of    IC811   PO150
                       the hierarchy must be entered for a       PO25.6  PO25.7
                       item, it cannot split and only certain    PO36.2  PO536
                       levels used.  The hierarchy will remain
                       an optional field when entering items.
                       When this field contains 00, the code is
                       for describing the ICCLASS level of the
                       hierarchy.

IIC-DESC-LEVEL         Numeric 1                                 IC11.1  IC16.1
Element: Desc Level    The description level is an indicator     IC330   IC516
                       for what level of the hierarchy is being  IC811   PO150
                       described by the description.             PO25.6  PO25.7
                       1 = ICSEGMENT Description                 PO36.2  PO536
                       2 = ICFAMILY Description
                       3 = ICCLASS Description
                       4 = ICCOMMODITY Description

IIC-ICCODE-SDESC       Alpha 20                                  IC11.1  IC16.1
Element: Iccode Sdesc  The sdesc is a shortened description. It  IC330   IC516
                       based on the long description.  It is     IC811   PO150
                       needed for screens that cannot display    PO25.6  PO25.7
                       the long description.                     PO36.2  PO536

IIC-ICCODE-LDESC       Alpha 80                                  IC11.1  IC16.1
Element: Iccode Ldesc  This is the correct description for the   IC330   IC516
                       level of the hierarchy that is indicated  IC811   PO150
                       by the description level field.  This     PO25.6  PO25.7
                       should be the full description.           PO36.2  PO536

IIC-ICCODE-ACTIVE      Alpha 1                                   IC11.1  IC16.1
Element: Iccode Active This code defines whether any item is     IC330   IC516
                       currently using this code.  As long as    IC811   PO150
                       this code is on one item it is            PO25.6  PO25.7
                       considered active.  The exception to is   PO36.2  PO536
                       for codes that contain 00 which is used
                       for describing levels of the codes.
                       Y = Code is used for an item
                       N = Code is not currently used

                         ICITEMCODE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IICSET1   ITEM-GROUP                                             IC11.1  IC16.1
          ICSEGMENT                                              IC330   IC516
          ICFAMILY                                               IC811   PD21.1
          ICCLASS                                                PO150   PO25.6
          ICCOMMODITY                                            PO25.7  PO36.2
                                                                 PO536

IICSET2   ITEM-GROUP    Subset
          ICSEGMENT     Where DESC-LEVEL    = 1
                        And   ICCODE-ACTIVE = "Y"

IICSET3   ITEM-GROUP    Subset
          ICSEGMENT     Where DESC-LEVEL    = 2
          ICFAMILY      And   ICCODE-ACTIVE = "Y"

IICSET4   ITEM-GROUP    Subset
          ICSEGMENT     Where DESC-LEVEL    = 3
          ICFAMILY      And   ICCODE-ACTIVE = "Y"
          ICCLASS

IICSET5   ITEM-GROUP    Subset
          ICSEGMENT     Where DESC-LEVEL    = 4
          ICFAMILY      And   ICCODE-ACTIVE = "Y"
          ICCLASS
          ICCOMMODITY

                         ICITEMCODE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Itemcodetoitem ITEMMAST

                            IIC-ITEM-GROUP     -> ITE-ITEM-GROUP  (ITESET10)
                            IIC-ICSEGMENT      -> ITE-ICSEGMENT
                            IIC-ICFAMILY       -> ITE-ICFAMILY
                            IIC-ICCLASS        -> ITE-ICCLASS
                            IIC-ICCOMMODITY    -> ITE-ICCOMMODITY
                                                  ITE-ITEM