Lawson Insight Technical Documentation

                            ICUSRFLDEF FILE

REFERENCED BY

IC11.1    IC12.1    IC13.1    IC20.1    IC20.2    IC21.1
IC21.2    IC22.1    IC22.2    IC23.1    IC23.2    IC24.1
IC29.1    IC320     PO10.1    PO13.1    POII.1    POIJ.1
RQ10.1    RQ500     RQIB.1    RQIF.1

UPDATED BY

IC00.1    IC01.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ICU-COMPANY          Numeric 4                                   IC00.1  IC01.1
Company              The company number represents an
                     established company and is entered on
                     all function codes.


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

ICU-USER-FLD-TYPE    Alpha 1                                     IC00.1  IC01.1
User Fld Type        T = ICTRANS
                     D = ICTRANSDTL
                     L = ITEMLOC
                     M = ITEMMAST
                     S = ITEMSUB

ICU-DATA-TYPE-01     Alpha 1                                     IC00.1  IC01.1
Data Type 01

ICU-DATA-TYPE-02     Alpha 1                                     IC00.1  IC01.1
Data Type 02

ICU-DATA-TYPE-03     Alpha 1                                     IC00.1  IC01.1
Data Type 03

ICU-DATA-TYPE-04     Alpha 1                                     IC00.1  IC01.1
Data Type 04

ICU-DATA-TYPE-05     Alpha 1                                     IC00.1  IC01.1
Data Type 05

                         ICUSRFLDEF FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ICUSET1   USER-FLD-TYPE                                          IC00.1  IC01.1
          COMPANY
          ITEM-GROUP

ICUSET2   COMPANY                                                IC11.1  IC12.1
          USER-FLD-TYPE                                          IC13.1  IC20.1
          ITEM-GROUP                                             IC20.2  IC21.1
                                                                 IC21.2  IC22.1
                                                                 IC22.2  IC23.1
                                                                 IC23.2  IC24.1
                                                                 IC29.1  IC320
                                                                 PO10.1  PO13.1
                                                                 POII.1  POIJ.1
                                                                 RQ10.1  RQ500
                                                                 RQIB.1  RQIF.1

ICUSET3   ITEM-GROUP                                             IC11.1  IC12.1
          USER-FLD-TYPE                                          IC13.1  IC20.1
          COMPANY                                                IC20.2  IC21.1
                                                                 IC21.2  IC22.1
                                                                 IC22.2  IC23.1
                                                                 IC23.2  IC24.1
                                                                 IC29.1  PO10.1
                                                                 PO13.1  POII.1
                                                                 POIJ.1  RQ10.1
                                                                 RQ500   RQIB.1
                                                                 RQIF.1