Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             ICITLLBL FILE

UPDATED BY

IC59.1    IC599     PO30.1    PO35.1    PO530

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

ILL-LABEL-TYPE       Numeric 3                                   IC59.1  PO30.1
Label Type           001 = Patient Labels                        PO35.1  PO530

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

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

ILL-LABEL-DESC       Alpha 50  (Lower Case)                      IC59.1  PO30.1
Label Desc                                                       PO35.1  PO530

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

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

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

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

ILL-NBR-OF-LABELS    Numeric 4                                   IC59.1  PO30.1
Nbr Of Labels                                                    PO35.1  PO530

ILL-PAR-CART-LOC     Alpha 5                                     PO30.1  PO35.1
Par Cart Loc                                                     PO530

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

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

                         ICITLLBL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

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