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

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

UFT-COMPANY          Numeric 4                                   IC20.1  IC20.2
Company              The company number represents an            IC21.1  IC21.2
                     established company and is entered on       IC22.1  IC22.2
                     all function codes.                         IC23.1  IC23.2
                                                                 IC24.1

UFT-LOCATION         Alpha 5                                     IC20.1  IC20.2
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

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

UFT-SYSTEM-CD        Alpha 2                                     IC20.1  IC20.2
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

UFT-DOCUMENT         Alpha 10  (Right Justified)                 IC20.1  IC20.2
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

UFT-SHIPMENT-NBR     Numeric 10                                  IC20.1  IC20.2
Shipment Number      This 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


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

UFT-COMPONENT-SEQ    Numeric 3                                   IC20.1  IC20.2
Component Sequence   This field contains the component           IC21.1  IC21.2
Number               sequence number.                            IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1

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

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

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

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

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

                         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
          SHIPMENT-NBR
          LINE-NBR
          COMPONENT-SEQ