BINGRPDTL – Bin Group Detail

System: Inventory Control (IC)
Prefix: BGD
Primary key: COMPANY, LOCATION, BIN-GROUP, BIN-SEQ
Fields: 5
Updated by: 5 programs
Referenced by: 10 programs

BINGRPDTL is the Bin Group Detail table in Lawson Inventory Control (prefix BGD). It is indexed by COMPANY, LOCATION, BIN-GROUP, BIN-SEQ (BGDSET1); alternate indexes: BGDSET2. It is related 1:1 to ICBIN, BINGROUP and ICCOMPANY. It is updated by IC15.3, IC331, IC81.1, IC82.1 and IC840 and referenced by IC138, IC170, IC183, IC215, IC241, IC281, IC520, IC521 and 2 more. The table has 5 fields, 2 indexes and 3 documented relations.

About BINGRPDTL

The Bin Group Detail file contains the details for bin group records. It contains all valid bins associated with the bin group.

Fields (5)

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

Field / column	Type	Description & values	Updated by
`BGD-COMPANY` PK COMPANY	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
`BGD-LOCATION` PK LOCATION	Alpha 5	This field contains a valid stocking location within the company inventory.	IC15.3, IC331, IC81.1, IC82.1, IC840
`BGD-BIN-GROUP` PK BIN_GROUP	Alpha 7	This field contains a collection of bins with one name used for cycle counting.	IC15.3, IC331, IC81.1, IC82.1, IC840
`BGD-BIN` BIN	Alpha 7	This field contains a storage area for an item or any number of items.	IC15.3, IC331, IC81.1, IC82.1, IC840
`BGD-BIN-SEQ` PK BIN_SEQ	Numeric 6	—	IC15.3, IC183, IC331, IC81.1, IC82.1, IC840

Indexes (2)

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

Index	Keys	Flags	Condition	Used in
`BGDSET1`	`COMPANY`, `LOCATION`, `BIN-GROUP`, `BIN-SEQ`	Primary		IC15.3, IC170, IC215, IC281, IC331, IC81.1, IC82.1, IC83.1 +1 more
`BGDSET2`	`COMPANY`, `LOCATION`, `BIN-GROUP`, `BIN`	KeyChange		IC138, IC15.2, IC15.3, IC183, IC241, IC331, IC520, IC521 +4 more

Relations

One to one (3) — lookups and parents

Relation	Table	Rules	Field map
Bin	ICBIN	Required	`BGD-COMPANY` → `ICB-COMPANY`, `BGD-LOCATION` → `ICB-LOCATION`, `BGD-BIN` → `ICB-BIN`
Bingroup	BINGROUP	Required	`BGD-COMPANY` → `BGR-COMPANY`, `BGD-LOCATION` → `BGR-LOCATION`, `BGD-BIN-GROUP` → `BGR-BIN-GROUP`
Company	ICCOMPANY	Required	`BGD-COMPANY` → `ICC-COMPANY`

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

Referenced by (10)

IC138 Bin Replenishment Report
IC170 Freeze Selected Items
IC183 Par Level Load
IC215 Bin Listing
IC241 Bin Reorder Policy Listing
IC281 Par Inventory Worksheet
IC520 Handheld Item Master Interface
IC521 Bar Code Item Master Interface
IC598 Bin Label Export
IC83.1 Par Location Counts