|
|
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
UPDATED BY
IC15.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BGR-COMPANY Numeric 4 IC15.3
Element: Company 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.
BGR-LOCATION Alpha 5 IC15.3
Element: Location This field contains a valid stock
location within the inventory.
BGR-BIN-GROUP Alpha 7 IC15.3
Element: Bin Group This field contains a collection of
bins under one name used for cycle
counting.
BGR-DESCRIPTION Alpha 30 (Lower Case) IC15.3
Element: Description This field contains the description of
the bin group.
BGR-BIN-SEQ Numeric 6 IC15.3
Element: Bin Seq
BINGROUP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BGRSET1 COMPANY IC02.1 IC15.3
LOCATION IC215
BIN-GROUP
BGRSET2 COMPANY
BIN-GROUP
LOCATION
BINGROUP FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company ICCOMPANY Required
BGR-COMPANY -> ICC-COMPANY (ICCSET1)
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
|
