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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 SET2
INVEN_MAJCL		Alpha 4—IC59.1, MA531, PO30.1, PO30.2, PO30.3, PO30.4, PO35.1, PO52.1
#ILL-INVEN-MINCL SET2
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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ILLSET1
  1. COMPANY
  2. LOCATION
  3. LABEL-TYPE
  4. USER-ID
  5. ITEM
  6. UPDATE-DATE
  7. UPDATE-TIME
PrimaryIC59.1, IC599, MA531, PO30.1, PO30.2, PO30.3, PO30.4, PO35.1 +1 more
ILLSET2
  1. COMPANY
  2. LOCATION
  3. LABEL-TYPE
  4. USER-ID
  5. INVEN-MAJCL
  6. INVEN-MINCL
  7. ITEM
  8. UPDATE-DATE
  9. UPDATE-TIME
KeyChange—

Programs

Updated by (9)