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 IC138 IC170 IC241
IC70.1
UPDATED BY
IC15.3 IC81.1 IC82.1 IC840 IC886
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BGR-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.
BGR-LOCATION Alpha 5 IC15.3 IC81.1
Location Code This field contains a valid stock IC82.1 IC840
location within the inventory.
BGR-BIN-GROUP Alpha 7 IC15.3 IC81.1
Bin Group This field contains a collection of IC82.1 IC840
bins under one name used for cycle
counting.
BGR-DESCRIPTION Alpha 30 (Lower Case) IC15.3 IC81.1
Description This field contains the description of IC82.1 IC840
the bin group.
BGR-SEQ Numeric 3 IC886
Sequence This field contains a unique number
assigned to each bin within the bin
group. The number is used to keep the
bins in the order they were entered. The
count sheet prints the selected items in
bin group sequence. This field is the
last sequence number in the bin group.
BGR-BIN-SEQ Numeric 6 IC15.3 IC81.1
Bin Seq IC82.1 IC840
IC886
BINGROUP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BGRSET1 COMPANY IC02.1 IC15.3
LOCATION IC215 IC270
BIN-GROUP IC81.1 IC82.1
IC840 IC886
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
BGD-SEQ
|
