Lawson Insight Technical Documentation |
|
BINGRPDTL
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
IC170 IC215 IC281 IC83.1 IC138 IC241
IC520 IC521 IC598
UPDATED BY
IC15.3 IC331 IC81.1 IC82.1 IC840
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BGD-COMPANY Numeric 4 IC15.3 IC331
Element: Company The company number represents an IC81.1 IC82.1
established company and is entered on IC840
all function codes.
BGD-LOCATION Alpha 5 IC15.3 IC331
Element: Location Code This field contains a valid stocking IC81.1 IC82.1
location within the company inventory. IC840
BGD-BIN-GROUP Alpha 7 IC15.3 IC331
Element: Bin Group This field contains a collection of IC81.1 IC82.1
bins with one name used for cycle IC840
counting.
BGD-BIN Alpha 7 IC15.3 IC331
Element: Bin This field contains a storage area for IC81.1 IC82.1
an item or any number of items. IC840
BGD-BIN-SEQ Numeric 6 IC15.3 IC331
Element: Bin Seq IC81.1 IC82.1
IC840
BINGRPDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BGDSET1 COMPANY IC15.3 IC170
LOCATION IC215 IC281
BIN-GROUP IC331 IC81.1
BIN-SEQ IC82.1 IC83.1
IC840
BGDSET2 COMPANY KeyChange IC138 IC15.2
LOCATION IC15.3 IC241
BIN-GROUP IC331 IC520
BIN IC521 IC598
IC81.1 IC82.1
IC840
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
|