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     IC51.1    IC812

UPDATED BY

IC10.2    IC15.1    IC15.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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


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

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

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

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

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

BST-ACTIVE-STATUS    Alpha 1                                     IC15.1
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
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
Unit of Measure      This 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
                                                                 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