BINGRPDTL FILE

                            Bin Group Detail

The Bin Group Detail file contains the details for bin group records. It
contains all valid bins associated with the bin group.

REFERENCED BY

IC170     IC215     IC281     IC83.1    IC138     IC241
IC520     IC521

UPDATED BY

IC15.3    IC81.1    IC82.1    IC840

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

BGD-COMPANY          Numeric 4                                   IC15.3  IC81.1
Company              The company number represents an            IC82.1  IC840
                     established company and is entered on
                     all function codes.

BGD-LOCATION         Alpha 5                                     IC15.3  IC81.1
Location Code        This field contains a valid stock           IC82.1  IC840
                     location within the company inventory.


BGD-BIN-GROUP        Alpha 7                                     IC15.3  IC81.1
Bin Group            This field contains a collection of         IC82.1  IC840
                     bins with one name used for cycle
                     counting.

BGD-SEQ              Numeric 3                                   IC15.3  IC81.1
Sequence Number      This field contains a unique number         IC82.1  IC840
                     assigned to each bin within the bin
                     group. This number is used to keep the
                     bins in the order they were entered.

BGD-BIN              Alpha 7                                     IC15.3  IC81.1
Bin                  This field contains a storage area for      IC82.1  IC840
                     an item or any number of items.

                         BINGRPDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BGDSET1   COMPANY                                                IC15.3  IC170
          LOCATION                                               IC215   IC281
          BIN-GROUP                                              IC81.1  IC82.1
          SEQ                                                    IC83.1  IC840

BGDSET2   COMPANY       KeyChange                                IC138   IC15.2
          LOCATION                                               IC15.3  IC241
          BIN-GROUP                                              IC520   IC521
          BIN                                                    IC81.1  IC82.1
                                                                 IC840

                         BINGRPDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Bin            ICBIN        Required

                            BGD-COMPANY      -> ICB-COMPANY
                            BGD-LOCATION     -> ICB-LOCATION
                            BGD-BIN          -> ICB-BIN

Bingroup       BINGROUP     Required

                            BGD-COMPANY      -> BGR-COMPANY
                            BGD-LOCATION     -> BGR-LOCATION
                            BGD-BIN-GROUP    -> BGR-BIN-GROUP

Company        ICCOMPANY    Required

                            BGD-COMPANY      -> ICC-COMPANY