Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ICUSRFLDEF


                            ICUSRFLDEF FILE

REFERENCED BY

DR100     IC11.1    IC12.1    IC13.1    IC141     IC142
IC20.1    IC20.2    IC21.1    IC21.2    IC22.1    IC22.2
IC23.1    IC23.2    IC24.1    IC24.2    IC29.1    IC320
IC83.1    PO10.1    PO13.1    POII.1    POIJ.1    RQ10.1
RQ10.3    RQ11.1    RQ13.2    RQ35.1    RQ500     RQIB.1
RQIF.1    RQIJ.1

UPDATED BY

IC00.1    IC01.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ICU-COMPANY            Numeric 4                                 IC00.1  IC01.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.

ICU-ITEM-GROUP         Alpha 5                                   IC00.1  IC01.1
Element: 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
Element: User Fld Type T = ICTRANS
                       D = ICTRANSDTL
                       L = ITEMLOC
                       M = ITEMMAST
                       S = ITEMSUB

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

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

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

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

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

                         ICUSRFLDEF FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

ICUSET2   COMPANY                                                DR100   IC11.1
          USER-FLD-TYPE                                          IC12.1  IC13.1
          ITEM-GROUP                                             IC141   IC142
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC29.1  IC320
                                                                 IC83.1  PO10.1
                                                                 PO13.1  POII.1
                                                                 POIJ.1  RQ10.1
                                                                 RQ10.3  RQ11.1
                                                                 RQ13.2  RQ35.1
                                                                 RQ500   RQIB.1
                                                                 ...

ICUSET3   ITEM-GROUP                                             DR100   IC11.1
          USER-FLD-TYPE                                          IC12.1  IC13.1
          COMPANY                                                IC141   IC142
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC29.1  IC83.1
                                                                 PO10.1  PO13.1
                                                                 POII.1  POIJ.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ13.2
                                                                 RQ35.1  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 ...