Lawson Insight Technical Documentation

                              ICICTUF FILE

UPDATED BY

IC20.1    IC20.2    IC21.1    IC21.2    IC22.1    IC22.2
IC23.1    IC23.2    IC24.1    IC24.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

UFT-COMPANY            Numeric 4                                 IC20.1  IC20.2
Element: Company       Identifies the AP company if the          IC21.1  IC21.2
                       resource type = V.  Identifies the HR     IC22.1  IC22.2
                       company if the resource type = E.  It is  IC23.1  IC23.2
                       blank for type A, P or Q resources.       IC24.1  IC24.2

UFT-LOCATION           Alpha 5                                   IC20.1  IC20.2
Element: Location Code This field contains a valid stocking      IC21.1  IC21.2
                       location within the company inventory.    IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2

UFT-DOC-TYPE           Alpha 2                                   IC20.1  IC20.2
Element: Document Type This field contains the type of           IC21.1  IC21.2
                       transaction.                              IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2

UFT-SYSTEM-CD          Alpha 2                                   IC20.1  IC20.2
Element: System Code   This field indicates on what system the   IC21.1  IC21.2
                       transaction originated.                   IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2

UFT-DOCUMENT           Alpha 10  (Right Justified)               IC20.1  IC20.2
Element: Document ID   This field identifies the document from   IC21.1  IC21.2
                       which this transaction record was         IC22.1  IC22.2
                       created.                                  IC23.1  IC23.2
                                                                 IC24.1  IC24.2

UFT-SHIPMENT-NBR       Numeric 10                                IC20.1  IC20.2
Element: Shipment NumbeThis field contains the shipment          IC21.1  IC21.2
                       number.  One order can have several       IC22.1  IC22.2
                       shipment numbers if the items of the      IC23.1  IC23.2
                       order were not shipped at the same time.  IC24.1  IC24.2


UFT-LINE-NBR           Numeric 6                                 IC20.1  IC20.2
Element: Line Number   This field contains the line number.      IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2

UFT-COMPONENT-SEQ      Numeric 3                                 IC20.1  IC20.2
Element: Sequence NumbeThis field contains the component         IC21.1  IC21.2
                       sequence number.                          IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2

UFT-ICT-USR-FLD-01     Alpha 20                                  IC20.1  IC20.2
Element: Ict Usr Fld 01                                          IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2

UFT-ICT-USR-FLD-02     Alpha 20                                  IC20.1  IC20.2
Element: Ict Usr Fld 02                                          IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2

UFT-ICT-USR-FLD-03     Alpha 20                                  IC20.1  IC20.2
Element: Ict Usr Fld 03                                          IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2

UFT-ICT-USR-FLD-04     Alpha 20                                  IC20.1  IC20.2
Element: Ict Usr Fld 04                                          IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2

UFT-ICT-USR-FLD-05     Alpha 20                                  IC20.1  IC20.2
Element: Ict Usr Fld 05                                          IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2

                         ICICTUF FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

UFTSET1   COMPANY                                                IC20.1  IC20.2
          LOCATION                                               IC21.1  IC21.2
          DOC-TYPE                                               IC22.1  IC22.2
          SYSTEM-CD                                              IC23.1  IC23.2
          DOCUMENT                                               IC24.1  IC24.2
          SHIPMENT-NBR
          LINE-NBR
          COMPONENT-SEQ