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     IC812

UPDATED BY

IC15.1    IC15.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BST-COMPANY            Numeric 4                                 IC15.1
Element: Company       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.

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

BST-STORAGE-CODE       Alpha 5                                   IC15.1
Element: Storage Code  This 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: 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: Active 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                                   IC15.1  IC15.2
Element: Used Fl       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.
                       N = No
                       Y = Yes

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

                         BINSTORAGE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BSTSET1   COMPANY                                                IC12.1  IC15.1
          LOCATION                                               IC15.2  IC215
          STORAGE-CODE                                           IC330   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