Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             ICITLLBL FILE

UPDATED BY

IC59.1    IC599

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ILL-COMPANY          Numeric 4                                   IC59.1
Company              The company number represents an
                     established company and is entered on
                     all function codes.

ILL-LOCATION         Alpha 5                                     IC59.1
Location Code        This field contains a valid stocking
                     location within the company inventory.

ILL-LABEL-TYPE       Numeric 3                                   IC59.1
Label Type           Identifies the label type.
                     001 = Patient Labels

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

ILL-ITEM             Alpha 32                                    IC59.1
Item Number          This field contains the item
                     identifier.

ILL-LABEL-DESC       Alpha 50  (Lower Case)                      IC59.1
Label Desc           Contains the item description for the
                     label.

ILL-INVEN-MAJCL      Alpha 4                                     IC59.1
Inventory Major      The user defined Major Inventory Class
Class                code.

ILL-INVEN-MINCL      Alpha 4                                     IC59.1
Inventory Minor      The user defined Minor Inventory Class
Class                code within the major class.

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

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

ILL-NBR-OF-LABELS    Numeric 4                                   IC59.1
Nbr Of Labels        The number of labels needed to be
                     printed.

ILL-PAR-CART-LOC     Alpha 5
Par Cart Loc         Par Cart Location.

ILL-UPDATE-DATE      Numeric 8  (yyyymmdd)                       IC59.1
Update Date          This field contains the date the record
                     was updated.

ILL-UPDATE-TIME      Numeric 6                                   IC59.1
Update Time          This field contains the system time
                     when the record was updated.

                         ICITLLBL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ILLSET1   COMPANY                                                IC59.1  IC599
          LOCATION
          LABEL-TYPE
          USER-ID
          ITEM
          UPDATE-DATE
          UPDATE-TIME

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