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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#ILB-COMPANY PKCOMPANY | Numeric 4 | Identifies 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 PKLOCATION | Alpha 5 | This field contains a valid stocking location within the company inventory. | IC38.1 |
#ILB-ITEM PKITEM | Alpha 32 | This field contains the item identifier. | IC38.1 |
#ILB-BIN PKBIN | Alpha 7 | This field contains a storage area for an item or any number of items. | IC38.1 |
#ILB-UOM PKUOM | Alpha 4 | This is a valid tracking unit of measure for this bin for this item. | IC38.1 |
#ILB-REPL-FROM-BINREPL_FROM_BIN | Alpha 7 | This field contains the replenishment from bin. This bin number is in the replenishment from location. | IC38.1 |
#ILB-ORDER-POLICYORDER_POLICY | Alpha 3 | This field contains the method of reordering.
| IC38.1 |
#ILB-REORD-PT-CDREORD_PT_CD | Alpha 1 | This field contains the reorder point code, which indicates how the reorder point quantity is to be determined.
| IC38.1 |
#ILB-REORD-QTY-CDREORD_QTY_CD | Alpha 1 | This field contains the reorder quantity code, which determines how to order the quantity.
| IC38.1 |
#ILB-REORDER-POINTREORDER_POINT | Signed 13.4 | This 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-QTYREORDER_QTY | Signed 13.4 | This 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-MULTORDER_MULT | Numeric 4 | This field contains the order multiple. The reorder quantity is a multiple of this quantity. | IC38.1 |
#ILB-MAX-ORDERMAX_ORDER | Signed 13.4 | This field contains the maximum level of inventory needed. | IC38.1 |
Indexes (1)
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
ILBSET1 |
| Primary | CX100, IC138, IC241, IC38.1 |
Relations
One to one (3) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Iccompany | ICCOMPANY | Required |
| |||||||
| Iclocation | ICLOCATION | Required |
| |||||||
| Itemmast | ITEMMAST | Required |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Sohdetail | SOHDETAIL |
|
Programs
Updated by (1)
- IC38.1 Bin Reorder Policy