Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BINSTORAGE


                            BINSTORAGE FILE

                            Bin Storage Code

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.

REFERENCED BY

IC12.1    IC215     IC330     IC51.1    IC812

UPDATED BY

IC10.2    IC15.1    IC15.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BST-COMPANY            Numeric 4                                 IC15.1
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

BST-LOCATION           Alpha 5                                   IC15.1
Element: Location Code This field contains a valid stocking
                       location within the company inventory.

BST-STORAGE-CODE       Alpha 5                                   IC15.1
Element: Bin Storage CoThis field contains a code assigned to
                       describe the physical characteristics of
                       a bin.

BST-DESCRIPTION        Alpha 30  (Lower Case)                    IC15.1
Element: Description   This field contains the description for
                       the bin storage code.

BST-CUBIC-FEET         Signed 9.3                                IC15.1
Element: Cubic Feet    This field contains the number of cubic
                       feet of storage space within the bin.

BST-WEIGHT             Signed 9.3                                IC15.1
Element: Unit Weight   This field contains the total amount of
                       weight the bin can handle for storage.

BST-QUANTITY           Signed 13.4                               IC15.1
Element: Quantity      This field contains the number of items
                       the bin can hold.

BST-ACTIVE-STATUS      Alpha 1                                   IC15.1
Element: Status        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.
                       A = Active
                       I = Inactive

BST-USED-FL            Alpha 1                                   IC10.2  IC15.1
Element: Used          This field indicates whether a bin        IC15.2
                       storage code has been used in the Item
                       Location file. Once it has been used, it
                       cannot be deleted.
                       N = No
                       Y = Yes

BST-UOM                Alpha 4                                   IC15.1
Element: Unit of MeasurThis is the valid stock unit of measure
                       for this item.

                         BINSTORAGE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BSTSET1   COMPANY                                                IC10.1  IC10.2
          LOCATION                                               IC12.1  IC15.1
          STORAGE-CODE                                           IC15.2  IC215
                                                                 IC330   IC51.1
                                                                 IC812

                         BINSTORAGE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        ICCOMPANY    Required

                            BST-COMPANY     -> ICC-COMPANY

Location       ICLOCATION   Required

                            BST-COMPANY     -> ICL-COMPANY
                            BST-LOCATION    -> ICL-LOCATION