BINGROUP – Bin Group
- System
- Inventory Control (IC)
- Prefix
BGR- Primary key
COMPANY,LOCATION,BIN-GROUP- Fields
- 5
- Updated by
- 5 programs
- Referenced by
- 11 programs
BINGROUP is the Bin Group table in Lawson Inventory Control (prefix BGR). It is indexed by COMPANY, LOCATION, BIN-GROUP (BGRSET1); alternate indexes: BGRSET2. It is related 1:1 to ICCOMPANY and ICLOCATION and 1:M to BINGRPDTL. It is updated by IC15.3, IC331, IC81.1, IC82.1 and IC840 and referenced by IC02.1, IC138, IC170, IC175, IC198, IC215, IC241, IC270 and 3 more. The table has 5 fields, 2 indexes and 3 documented relations.
About BINGROUP
The Bin Group file is for defining valid groups of bins. These groups are used in the physical inventory module for selection of bins to be counted. This file contains bin group descriptions and the last sequence number used in assigning bins in the group.
Fields (5)
Column = COBOL field name without the BGR- 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 |
|---|---|---|---|
#BGR-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. | IC15.3, IC331, IC81.1, IC82.1, IC840 |
#BGR-LOCATION PKLOCATION | Alpha 5 | This field contains a valid stock location within the inventory. | IC15.3, IC331, IC81.1, IC82.1, IC840 |
#BGR-BIN-GROUP PKBIN_GROUP | Alpha 7 | This field contains a collection of bins under one name used for cycle counting. | IC15.3, IC331, IC81.1, IC82.1, IC840 |
#BGR-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This field contains the description of the bin group. | IC15.3, IC81.1, IC82.1, IC840 |
#BGR-BIN-SEQBIN_SEQ | Numeric 6 | — | IC15.3, IC331, IC81.1, IC82.1, IC840 |
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
BGRSET1 |
| Primary | IC02.1, IC15.3, IC175, IC198, IC215, IC270, IC331, IC598 +4 more | |
BGRSET2 |
| IC138, IC170, IC241, IC70.1 |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Company | ICCOMPANY | Required |
| |||||||
| Location | ICLOCATION | Required |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Bingrpdtl | BINGRPDTL | Delete Cascades |
|
Programs
Updated by (5)
- IC15.3 Bin Groups
- IC331 Par Cart Mass Changes
- IC81.1 Cart, Par Location
- IC82.1 Par Location Item Mass Change
- IC840 Cart Par Location Conversion