Lawson Insight Technical Documentation

                             ICITLLBL FILE

UPDATED BY

IC59.1    IC599     MA531     PO30.1    PO30.2    PO30.3
PO35.1    PO52.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ILL-COMPANY          Numeric 4                                   IC59.1  MA531
Company              The company number represents an            PO30.1  PO30.2
                     established company and is entered on       PO30.3  PO35.1
                     all function codes.                         PO52.1


ILL-LOCATION         Alpha 5                                     IC59.1  MA531
Location Code        This field contains a valid stocking        PO30.1  PO30.2
                     location within the company inventory.      PO30.3  PO35.1
                                                                 PO52.1

ILL-LABEL-TYPE       Numeric 3                                   IC59.1  MA531
Label Type           Identifies the label type.                  PO30.1  PO30.2
                     001 = Patient Labels                        PO30.3  PO35.1
                                                                 PO52.1

ILL-USER-ID          Alpha 10  (Lower Case)                      IC59.1  MA531
User ID Name         Contains the user ID of the person who      PO30.1  PO30.2
                     last changed this record.                   PO30.3  PO35.1
                                                                 PO52.1

ILL-ITEM             Alpha 32                                    IC59.1  MA531
Item Number          This field contains the item                PO30.1  PO30.2
                     identifier.                                 PO30.3  PO35.1
                                                                 PO52.1

ILL-LABEL-DESC       Alpha 50  (Lower Case)                      IC59.1  MA531
Label Desc           Contains the item description for the       PO30.1  PO30.2
                     label.                                      PO30.3  PO35.1
                                                                 PO52.1

ILL-INVEN-MAJCL      Alpha 4                                     IC59.1  MA531
Inventory Major      The user defined Major Inventory Class      PO30.1  PO30.2
Class                code.                                       PO30.3  PO35.1
                                                                 PO52.1

ILL-INVEN-MINCL      Alpha 4                                     IC59.1  MA531
Inventory Minor      The user defined Minor Inventory Class      PO30.1  PO30.2
Class                code within the major class.                PO30.3  PO35.1
                                                                 PO52.1

ILL-MANUF-NBR        Alpha 15                                    IC59.1  MA531
Manufacturer's Item  This is the identifier that the             PO30.1  PO30.2
Number               manufacturer has assigned to an item.       PO30.3  PO35.1
                                                                 PO52.1

ILL-CHARGE-NBR       Alpha 10                                    IC59.1  MA531
Charge Nbr           The number used by the patient billing      PO30.1  PO30.2
                     system to charge patients for items         PO30.3  PO35.1
                     used.                                       PO52.1

ILL-NBR-OF-LABELS    Numeric 4                                   IC59.1  MA531
Nbr Of Labels        The number of labels needed to be           PO30.1  PO30.2
                     printed.                                    PO30.3  PO35.1
                                                                 PO52.1

ILL-PAR-CART-LOC     Alpha 5                                     MA531   PO30.1
Par Cart Loc         Par Cart Location.                          PO30.2  PO30.3
                                                                 PO35.1  PO52.1

ILL-UPDATE-DATE      Numeric 8  (yyyymmdd)                       IC59.1  MA531
Update Date          This field contains the date the record     PO30.1  PO30.2
                     was updated.                                PO30.3  PO35.1
                                                                 PO52.1

ILL-UPDATE-TIME      Numeric 6                                   IC59.1  MA531
Update Time          This field contains the system time         PO30.1  PO30.2
                     when the record was updated.                PO30.3  PO35.1
                                                                 PO52.1

                         ICITLLBL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ILLSET1   COMPANY                                                IC59.1  IC599
          LOCATION                                               MA531   PO30.1
          LABEL-TYPE                                             PO30.2  PO30.3
          USER-ID                                                PO35.1  PO52.1
          ITEM
          UPDATE-DATE
          UPDATE-TIME

ILLSET2   COMPANY       KeyChange
          LOCATION
          LABEL-TYPE
          USER-ID
          INVEN-MAJCL
          INVEN-MINCL
          ITEM
          UPDATE-DATE
          UPDATE-TIME