BINSTORAGE – Bin Storage Code
- System
- Inventory Control (IC)
- Prefix
BST- Primary key
COMPANY,LOCATION,STORAGE-CODE- Fields
- 10
- Updated by
- 3 programs
- Referenced by
- 7 programs
BINSTORAGE is the Bin Storage Code table in Lawson Inventory Control (prefix BST). It is indexed by COMPANY, LOCATION, STORAGE-CODE (BSTSET1). It is related 1:1 to ICCOMPANY and ICLOCATION. It is updated by IC10.2, IC15.1 and IC15.2 and referenced by IC12.1, IC215, IC330, IC51.1, IC511, IC512 and IC812. The table has 10 fields, 1 index and 2 documented relations.
About BINSTORAGE
The Bin Storage Code file contains information about the physical storage capacities of a specific type of bin. These storage codes can be assigned to bins with the same physical attributes.
Fields (10)
Column = COBOL field name without the BST- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
BST-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.1 |
BST-LOCATION PKLOCATION | Alpha 5 | This field contains a valid stocking location within the company inventory. | IC15.1 |
BST-STORAGE-CODE PKSTORAGE_CODE | Alpha 5 | This field contains a code assigned to describe the physical characteristics of a bin. | IC15.1 |
BST-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This field contains the description for the bin storage code. | IC15.1 |
BST-CUBIC-FEETCUBIC_FEET | Signed 9.3 | This field contains the number of cubic feet of storage space within the bin. | IC15.1 |
BST-WEIGHTWEIGHT | Signed 9.3 | This field contains the total amount of weight the bin can handle for storage. | IC15.1 |
BST-QUANTITYQUANTITY | Signed 13.4 | This field contains the number of items the bin can hold. | IC15.1 |
BST-ACTIVE-STATUSACTIVE_STATUS | Alpha 1 | This field is used to limit the use of a storage code. If the status is inactive, the bin storage code cannot be added to the Item Location record.
| IC15.1 |
BST-USED-FLUSED_FL | Alpha 1 | This field indicates whether a bin storage code has been used in the Item Location file. Once it has been used, it cannot be deleted.
| IC10.2, IC15.1, IC15.2 |
BST-UOMUOM | Alpha 4 | This is the valid stock unit of measure for this item. | IC15.1 |
Indexes (1)
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 |
|---|---|---|---|---|
BSTSET1 | COMPANY, LOCATION, STORAGE-CODE | Primary | IC10.1, IC10.2, IC12.1, IC15.1, IC15.2, IC215, IC330, IC51.1 +3 more |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Company | ICCOMPANY | Required | BST-COMPANY → ICC-COMPANY | |
| Location | ICLOCATION | Required | BST-COMPANY → ICL-COMPANY, BST-LOCATION → ICL-LOCATION |