|
|
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
BL820 BL92.1 BL940 CX05.1 CX05.2 CX100
CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1
CX300 CX506 CX805 CXCP.1 DR100 IC02.1
IC10.1 IC10.2 IC116 IC12.1 IC120 IC134
IC138 IC140 IC141 IC142 IC145 IC150
IC151 IC152 IC16.1 IC170 IC175 IC20.1
IC20.2 IC21.1 IC21.2 IC215 IC22.1 IC22.2
IC223 IC224 IC225 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
IC29.1 IC29.2 IC29.3 IC295 IC31.1 IC38.1
IC40.1 IC40.2 IC41.1 IC42.3 IC45.1 IC500
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 SEA1.1 OE10.1 OE10.2 OE10.3 OE10.4
OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4
OE11.8 OE11.9 OE110 OE113 OE114 OE129
OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5
OE15.7 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5
OE30.6 OE30.7 OE30.9 OE510 OE81.1 OE81.3
OE810 OE830 OE90.1 OE920 OE950 PO30.1
PO31.1 PO32.2 PO33.1 PO34.1 PO35.1 PO39.1
PO530 RQ10.1 RQ10.2 RQ10.3 RQ11.1 RQ12.1
RQ125 RQ13.1 RQ15.1 RQ20.1 RQ20.2 RQ20.4
RQ240 RQ35.1 RQ39.1 RQ39.2 RQ39.3 RQ42.1
RQ50.1 RQ500 RQ961 SEA3.1 WH110 WH126
WH130 WH132 WH190 WH20.1 WH20.2 WH20.3
WH20.4 WH20.5 WH20.6 WH20.7 WH22.1 WH220
WH222 WH30.1 WH30.2 WH30.3 WH31.1 WH31.2
WH31.3 WH32.1 WH32.2 WH32.3 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 WH40.1
WH40.2 WH520 WH830 WH961 WO10.1 WO120
WO130 WO131 WO132 WO133 WO140 WO20.1
WO215 WO220 WO232 WO235 WO250 WO251
WO252 WO255 WO256 WO30.1 WO30.2 WO300
WO32.1 WO32.2 WO32.3 WO32.4 WO32.5 WO35.1
WO40.1 WO40.2 WO40.3 WO40.4 WO40.5 WO40.6
WO41.1 WO41.2 WO41.3 WO41.4 WO42.1 WO42.2
WO42.3 WO42.4 WO42.5 WO45.1 WO510 WO80.1
WO81.1 WO81.2 WO82.1 WOEX.1 WOSP.1 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 stock 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 BL820 BL92.1
LOCATION BL940 CX05.1
BIN CX05.2 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CX805 CXCP.1
DR100 IC02.1
IC10.1 IC10.2
IC116 IC12.1
IC120 IC134
IC138 IC140
IC141 IC142
IC145 IC15.2
...
ICBSET3 COMPANY KeyChange IC01.3
BIN-TYPE
BIN
LOCATION
ICBSET4 COMPANY KeyChange IC10.1 IC10.2
LOCATION 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
|