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
Element: 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
Element: 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
Element: 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
Element: User                                                    PO30.1  PO30.2
                                                                 PO30.3  PO35.1
                                                                 PO52.1

ILL-ITEM               Alpha 32                                  IC59.1  MA531
Element: 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
Element: 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
Element: Major Class                                             PO30.1  PO30.2
                                                                 PO30.3  PO35.1
                                                                 PO52.1

ILL-INVEN-MINCL        Alpha 4                                   IC59.1  MA531
Element: Minor Class                                             PO30.1  PO30.2
                                                                 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
Element: 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
Element: 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
Element: Par Cart Loc  Par Cart Location.                        PO30.2  PO30.3
                                                                 PO35.1  PO52.1

ILL-UPDATE-DATE        Numeric 8  (yyyymmdd)                     IC59.1  MA531
Element: Date                                                    PO30.1  PO30.2
                                                                 PO30.3  PO35.1
                                                                 PO52.1

ILL-UPDATE-TIME        Numeric 6                                 IC59.1  MA531
Element: 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