ITEMLOCBIN – Item Location Bin Reorder File

System
Inventory Control (IC)
Prefix
ILB
Primary key
COMPANY, LOCATION, ITEM, BIN, UOM
Fields
13
Updated by
1 program
Referenced by
3 programs

ITEMLOCBIN is the Item Location Bin Reorder File table in Lawson Inventory Control (prefix ILB). It is indexed by COMPANY, LOCATION, ITEM, BIN, UOM (ILBSET1). It is related 1:1 to ICCOMPANY, ICLOCATION and ITEMMAST and 1:M to SOHDETAIL. It is updated by IC38.1 and referenced by CX100, IC138 and IC241. The table has 13 fields, 1 index and 4 documented relations.

About ITEMLOCBIN

The Item Location Bin Reorder File contains the reorder parameters for replenishing an item at a bin within a location. This reorder data is used to calculate bin to bin replenishment within a location. For example, a picking bin could be set up to be automatically replenished from a bulk bin once the picking bin's stock goes below a specific reorder point.

Fields (13)

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

Field / columnTypeDescription & valuesUpdated by
ILB-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.IC38.1
ILB-LOCATION PK
LOCATION		Alpha 5This field contains a valid stocking location within the company inventory.IC38.1
ILB-ITEM PK
ITEM		Alpha 32This field contains the item identifier.IC38.1
ILB-BIN PK
BIN		Alpha 7This field contains a storage area for an item or any number of items.IC38.1
ILB-UOM PK
UOM		Alpha 4This is a valid tracking unit of measure for this bin for this item.IC38.1
ILB-REPL-FROM-BIN
REPL_FROM_BIN		Alpha 7This field contains the replenishment from bin. This bin number is in the replenishment from location.IC38.1
ILB-ORDER-POLICY
ORDER_POLICY		Alpha 3This field contains the method of reordering.
  • FOP Fixed Order Point Method
IC38.1
ILB-REORD-PT-CD
REORD_PT_CD		Alpha 1This field contains the reorder point code, which indicates how the reorder point quantity is to be determined.
  • F Fixed Order Point Quantity
IC38.1
ILB-REORD-QTY-CD
REORD_QTY_CD		Alpha 1This field contains the reorder quantity code, which determines how to order the quantity.
  • F Fixed Order Quantity
  • D Difference up to Reorder Point
  • M Order up to Max Level
IC38.1
ILB-REORDER-POINT
REORDER_POINT		Signed 13.4This field contains the reorder point. Reordering for this item is triggered to occur when the item stock-on-hand quantity falls below this reorder point.IC38.1
ILB-REORDER-QTY
REORDER_QTY		Signed 13.4This field contains the normal reorder quantity for the item at this location. This field is maintained by the user or the system, based on reorder quantity code.IC38.1
ILB-ORDER-MULT
ORDER_MULT		Numeric 4This field contains the order multiple. The reorder quantity is a multiple of this quantity.IC38.1
ILB-MAX-ORDER
MAX_ORDER		Signed 13.4This field contains the maximum level of inventory needed.IC38.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
ILBSET1COMPANY, LOCATION, ITEM, BIN, UOMPrimaryCX100, IC138, IC241, IC38.1

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
IccompanyICCOMPANYRequiredILB-COMPANY → ICC-COMPANY
IclocationICLOCATIONRequiredILB-COMPANY → ICL-COMPANY, ILB-LOCATION → ICL-LOCATION
ItemmastITEMMASTRequiredICC-ITEM-GROUP → ITE-ITEM-GROUP, ILB-ITEM → ITE-ITEM

One to many (1) — child tables

RelationTableRulesConditionField map
SohdetailSOHDETAILILB-COMPANY → SDT-COMPANY, ILB-LOCATION → SDT-LOCATION, ILB-ITEM → SDT-ITEM, ILB-BIN → SDT-BIN, → SDT-UOM, → SDT-LOT, → SDT-SUBLOT

Programs

Updated by (1)

Referenced by (3)