BINGROUP

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 IC175 IC198 IC215 IC270 IC598
IC93.2 IC138 IC170 IC241 IC70.1


UPDATED BY
IC15.3 IC331 IC81.1 IC82.1 IC840

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BGR-COMPANY
Element: Company
Numeric 4
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.
IC15.3 IC331
IC81.1 IC82.1
IC840
BGR-LOCATION
Element: Location
Alpha 5
This field contains a valid stock location within the inventory.
IC15.3 IC331
IC81.1 IC82.1
IC840
BGR-BIN-GROUP
Element: Bin Group
Alpha 7
This field contains a collection of bins under one name used for cycle counting.
IC15.3 IC331
IC81.1 IC82.1
IC840
BGR-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field contains the description of the bin group.
IC15.3 IC81.1
IC82.1 IC840
BGR-BIN-SEQ
Element: Bin Seq
Numeric 6
IC15.3 IC331
IC81.1 IC82.1
IC840


BINGROUP FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BGRSET1 COMPANY
LOCATION
BIN-GROUP
IC02.1 IC15.3
IC175 IC198
IC215 IC270
IC331 IC598
IC81.1 IC82.1
IC840 IC93.2
BGRSET2 COMPANY
BIN-GROUP
LOCATION
IC138 IC170
IC241 IC70.1


BINGROUP FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Thu Jun 09 02:18:24 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.