BINGRPDTL

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
IC170 IC215 IC281 IC83.1 IC138 IC183
IC241 IC520 IC521 IC598


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

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BGD-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
BGD-LOCATION
Element: Location		Alpha 5
This field contains a valid stocking location within the company inventory.
IC15.3 IC331
IC81.1 IC82.1
IC840
BGD-BIN-GROUP
Element: Bin Group		Alpha 7
This field contains a collection of bins with one name used for cycle counting.
IC15.3 IC331
IC81.1 IC82.1
IC840
BGD-BIN
Element: Bin		Alpha 7
This field contains a storage area for an item or any number of items.
IC15.3 IC331
IC81.1 IC82.1
IC840
BGD-BIN-SEQ
Element: Bin Seq		Numeric 6
IC15.3 IC183
IC331 IC81.1
IC82.1 IC840


BINGRPDTL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BGDSET1 COMPANY
LOCATION
BIN-GROUP
BIN-SEQ
IC15.3 IC170
IC215 IC281
IC331 IC81.1
IC82.1 IC83.1
IC840
BGDSET2 COMPANY
LOCATION
BIN-GROUP
BIN
KeyChange
IC138 IC15.2
IC15.3 IC183
IC241 IC331
IC520 IC521
IC598 IC81.1
IC82.1 IC840


BINGRPDTL FILE RELATIONS


ONE TO ONE RELATIONS

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

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

Home
Contact Us



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