ICITLLBL – Item Location Label

System
Inventory Control (IC)
Prefix
ILL
Primary key
COMPANY, LOCATION, LABEL-TYPE, USER-ID, ITEM, UPDATE-DATE, UPDATE-TIME
Fields
14
Updated by
9 programs
Referenced by
0 programs

ICITLLBL is the Item Location Label table in Lawson Inventory Control (prefix ILL). It is indexed by COMPANY, LOCATION, LABEL-TYPE, USER-ID, ITEM, UPDATE-DATE, UPDATE-TIME (ILLSET1); alternate indexes: ILLSET2. It is updated by IC59.1, IC599, MA531, PO30.1, PO30.2, PO30.3, PO30.4, PO35.1 and 1 more. The table has 14 fields, 2 indexes and 0 documented relations.

About ICITLLBL

No description in the Lawson data dictionary.

Fields (14)

Column = COBOL field name without the ILL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
ILL-COMPANY PK
COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.IC59.1, MA531, PO30.1, PO30.2, PO30.3, PO30.4, PO35.1, PO52.1
ILL-LOCATION PK
LOCATION		Alpha 5This field contains a valid stocking location within the company inventory.IC59.1, MA531, PO30.1, PO30.2, PO30.3, PO30.4, PO35.1, PO52.1
ILL-LABEL-TYPE PK
LABEL_TYPE		Numeric 3Identifies the label type.
  • 001 Patient Labels
IC59.1, MA531, PO30.1, PO30.2, PO30.3, PO30.4, PO35.1, PO52.1
ILL-USER-ID PK
USER_ID		Alpha 10 (Lower Case)—IC59.1, MA531, PO30.1, PO30.2, PO30.3, PO30.4, PO35.1, PO52.1
ILL-ITEM PK
ITEM		Alpha 32This field contains the item identifier.IC59.1, MA531, PO30.1, PO30.2, PO30.3, PO30.4, PO35.1, PO52.1
ILL-LABEL-DESC
LABEL_DESC		Alpha 50 (Lower Case)Contains the item description for the label.IC59.1, MA531, PO30.1, PO30.2, PO30.3, PO30.4, PO35.1, PO52.1
ILL-INVEN-MAJCL
INVEN_MAJCL		Alpha 4—IC59.1, MA531, PO30.1, PO30.2, PO30.3, PO30.4, PO35.1, PO52.1
ILL-INVEN-MINCL
INVEN_MINCL		Alpha 4—IC59.1, MA531, PO30.1, PO30.2, PO30.3, PO30.4, PO35.1, PO52.1
ILL-MANUF-NBR
MANUF_NBR		Alpha 35This is the identifier that the manufacturer has assigned to an item.IC59.1, MA531, PO30.1, PO30.2, PO30.3, PO30.4, PO35.1, PO52.1
ILL-CHARGE-NBR
CHARGE_NBR		Alpha 80The number used by the patient billing system to charge patients for items used.IC59.1, MA531, PO30.1, PO30.2, PO30.3, PO30.4, PO35.1, PO52.1
ILL-NBR-OF-LABELS
NBR_OF_LABELS		Numeric 4The number of labels needed to be printed.IC59.1, MA531, PO30.1, PO30.2, PO30.3, PO30.4, PO35.1, PO52.1
ILL-PAR-CART-LOC
PAR_CART_LOC		Alpha 5Par Cart Location.MA531, PO30.1, PO30.2, PO30.3, PO30.4, PO35.1, PO52.1
ILL-UPDATE-DATE PK
UPDATE_DATE		Numeric 8 (yyyymmdd)This field contains the date the record was updated.IC59.1, MA531, PO30.1, PO30.2, PO30.3, PO30.4, PO35.1, PO52.1
ILL-UPDATE-TIME PK
UPDATE_TIME		Numeric 6This field contains the system time when the record was updated.IC59.1, MA531, PO30.1, PO30.2, PO30.3, PO30.4, PO35.1, PO52.1

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ILLSET1COMPANY, LOCATION, LABEL-TYPE, USER-ID, ITEM, UPDATE-DATE, UPDATE-TIMEPrimaryIC59.1, IC599, MA531, PO30.1, PO30.2, PO30.3, PO30.4, PO35.1 +1 more
ILLSET2COMPANY, LOCATION, LABEL-TYPE, USER-ID, INVEN-MAJCL, INVEN-MINCL, ITEM, UPDATE-DATE, UPDATE-TIMEKeyChange—

Programs

Updated by (9)