|
|
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
IC215
UPDATED BY
IC15.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BGD-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.
BGD-LOCATION Alpha 5 IC15.3
Element: Location This field contains a valid stocking
location within the company inventory.
BGD-BIN-GROUP Alpha 7 IC15.3
Element: Bin Group This field contains a collection of
bins with one name used for cycle
counting.
BGD-BIN Alpha 7 IC15.3
Element: Bin This field contains a storage area for
an item or any number of items.
BGD-BIN-SEQ Numeric 6 IC15.3
Element: Bin Seq
BINGRPDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BGDSET1 COMPANY IC15.3 IC215
LOCATION
BIN-GROUP
BIN-SEQ
BGDSET2 COMPANY KeyChange IC15.2 IC15.3
LOCATION
BIN-GROUP
BIN
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
|
