Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BINGROUP


                             BINGROUP FILE

                               Bin Group

The Bin Group file is for defining valid groups of bins. These groups are
used in the physical inventory module for selection of bins to be counted.
This file contains bin group descriptions and the last sequence number used in
assigning bins in the group.

REFERENCED BY

IC02.1    IC215     IC270     IC598     IC138     IC170
IC241     IC70.1

UPDATED BY

IC15.3    IC331     IC81.1    IC82.1    IC840

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BGR-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.

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

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

BGR-DESCRIPTION        Alpha 30  (Lower Case)                    IC15.3  IC81.1
Element: Description   This field contains the description of    IC82.1  IC840
                       the bin group.

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

                         BINGROUP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BGRSET1   COMPANY                                                IC02.1  IC15.3
          LOCATION                                               IC215   IC270
          BIN-GROUP                                              IC331   IC598
                                                                 IC81.1  IC82.1
                                                                 IC840

BGRSET2   COMPANY                                                IC138   IC170
          BIN-GROUP                                              IC241   IC70.1
          LOCATION

                         BINGROUP FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        ICCOMPANY    Required

                            BGR-COMPANY      -> ICC-COMPANY

Location       ICLOCATION   Required

                            BGR-COMPANY      -> ICL-COMPANY
                            BGR-LOCATION     -> ICL-LOCATION

                         BINGROUP FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Bingrpdtl      BINGRPDTL    Delete Cascades

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