 |
Lawson Insight Technical Documentation |
|
ICBIN FILE
Bin Numbers
The Bin Numbers file is a master list of valid bin numbers in a location used
for tracking items by bin.
REFERENCED BY
BL140 CXCP.1 DR100 IC02.1 IC10.1 IC10.2
IC12.1 IC12.2 IC120 IC125 IC130 IC134
IC138 IC140 IC141 IC142 IC145 IC150
IC151 IC152 IC170 IC175 IC20.1 IC20.2
IC21.1 IC21.2 IC211 IC215 IC22.1 IC22.2
IC223 IC224 IC225 IC226 IC227 IC228
IC23.1 IC23.2 IC23.3 IC23.4 IC23.5 IC237
IC24.1 IC24.2 IC25.1 IC26.1 IC26.2 IC262
IC28.1 IC281 IC29.1 IC29.2 IC29.3 IC295
IC31.1 IC320 IC330 IC36.1 IC38.1 IC40.1
IC40.2 IC41.1 IC42.3 IC45.1 IC500 IC520
IC521 IC522 IC523 IC524 IC525 IC526
IC527 IC530 IC531 IC574 IC61.1 IC62.1
IC62.2 IC67.1 IC68.1 IC68.2 IC68.3 IC72.1
IC73.1 IC74.1 IC812 IC820 IC83.1 IC850
IC90.1 IC95.1 IC95.2 IC95.3 ICI2.1 PC120
SEA1.1 MA63.1 PO16.1 PO228 PO64.1 POIJ.1
RQ11.1 RQ12.1 RQ13.1 RQ39.1 RQ39.2 RQ39.3
SEA3.1 WH110 WH126 WH130 WH22.1 WH220
WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6
WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4
WH34.5 IC01.3 IC51.1
UPDATED BY
IC15.2 IC81.1 IC82.1 IC840
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ICB-COMPANY Numeric 4 IC15.2 IC81.1
Company The company number represents an IC82.1 IC840
established company and is entered on
all function codes.
ICB-LOCATION Alpha 5 IC15.2 IC81.1
Location Code This field contains a valid stocking IC82.1 IC840
location within the company inventory.
ICB-BIN Alpha 7 IC15.2 IC81.1
Bin This field contains a storage area for IC82.1 IC840
an item or any number of items.
ICB-BIN-TYPE Alpha 1 IC15.2 IC81.1
Bin Usage Type This field indicates how the bin is IC82.1 IC840
used (for example, for inspection).
ICB-STORAGE-CODE Alpha 5 IC15.2 IC24.1
Bin Storage Code This field contains a code assigned to IC81.1 IC82.1
describe the physical characteristics of IC840
a bin.
ICBIN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ICBSET1 COMPANY BL140 CXCP.1
LOCATION DR100 IC02.1
BIN IC10.1 IC10.2
IC12.1 IC12.2
IC120 IC125
IC130 IC134
IC138 IC140
IC141 IC142
IC145 IC15.2
IC15.3 IC150
IC151 IC152
IC170 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC211 IC215
...
ICBSET3 COMPANY KeyChange IC01.3
BIN-TYPE
BIN
LOCATION
ICBSET4 COMPANY KeyChange IC10.1 IC10.2
LOCATION IC330 IC51.1
STORAGE-CODE
BIN
ICBIN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Binstorage BINSTORAGE Required
When ICB-STORAGE-CODE != Spaces
ICB-COMPANY -> BST-COMPANY
ICB-LOCATION -> BST-LOCATION
ICB-STORAGE-CODE -> BST-STORAGE-CODE
Company ICCOMPANY Required
ICB-COMPANY -> ICC-COMPANY
Location ICLOCATION Required
ICB-COMPANY -> ICL-COMPANY
ICB-LOCATION -> ICL-LOCATION
ICBIN FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Stockonhand SOHDETAIL Delete Restricted
ICB-COMPANY -> SDT-COMPANY
ICB-LOCATION -> SDT-LOCATION
ICB-BIN -> SDT-BIN
SDT-ITEM
SDT-UOM
SDT-LOT
SDT-SUBLOT
|