Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BINGRPDTL


                             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     IC598

UPDATED BY

IC15.3    IC331     IC81.1    IC82.1    IC840

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

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

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

BGD-BIN-SEQ            Numeric 6                                 IC15.3  IC331
Element: Bin Seq                                                 IC81.1  IC82.1
                                                                 IC840

                         BINGRPDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

BGDSET2   COMPANY       KeyChange                                IC138   IC15.2
          LOCATION                                               IC15.3  IC241
          BIN-GROUP                                              IC331   IC520
          BIN                                                    IC521   IC598
                                                                 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