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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#BGD-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 |
#BGD-LOCATION PKLOCATION | Alpha 5 | This field contains a valid stocking location within the company inventory. | IC15.3, IC331, IC81.1, IC82.1, IC840 |
#BGD-BIN-GROUP PKBIN_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 SET2BIN | 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 PKBIN_SEQ | Numeric 6 | — | IC15.3, IC183, 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 |
|---|---|---|---|---|
BGDSET1 |
| Primary | IC15.3, IC170, IC215, IC281, IC331, IC81.1, IC82.1, IC83.1 +1 more | |
BGDSET2 |
| KeyChange | IC138, IC15.2, IC15.3, IC183, IC241, IC331, IC520, IC521 +4 more |
Relations
One to one (3) — lookups and parents
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