|
|
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
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.4 API1.1 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 IC182 IC20.1 IC20.2 IC21.1 IC21.2
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 IC270 IC28.1 IC281
IC282 IC285 IC29.1 IC29.2 IC29.3 IC295
IC31.1 IC320 IC330 IC36.1 IC38.1 IC40.1
IC40.2 IC41.1 IC42.3 IC44.1 IC45.1 IC500
IC520 IC521 IC522 IC523 IC524 IC525
IC526 IC527 IC530 IC531 IC574 IC598
IC61.1 IC62.1 IC62.2 IC67.1 IC68.1 IC68.2
IC68.3 IC72.1 IC73.1 IC74.1 IC812 IC820
IC83.1 IC84.1 IC84.2 IC850 IC90.1 IC95.1
IC95.2 IC95.3 PC120 SEA1.1 MA180 MA41.2
MA41.7 MA43.1 MA43.2 MA43.3 MA43.9 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA63.1
MA66.2 MA66.3 MA67.1 MA67.2 MA70.1 MA75.1
MA80.1 MAI1.1 PO100 PO101 PO122 PO131
PO16.1 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO228 PO23.1 PO25.1 PO25.5
PO25.6 PO25.7 PO27.2 PO29.1 PO30.1 PO30.2
PO30.3 PO300 PO31.1 PO31.2 PO32.2 PO33.1
PO34.1 PO35.1 PO36.1 PO36.2 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 PO536
PO64.1 POI3.1 POII.1 POIJ.1 RQ10.1 RQ10.2
RQ10.3 RQ11.1 RQ12.1 RQ13.1 RQ35.1 RQ39.1
RQ39.2 RQ39.3 RQ500 RQIC.1 RQID.1 RQIE.1
RQIF.1 RQIG.1 RQIH.1 RQIJ.1 SEA3.1 WH110
WH120 WH126 WH130 WH132 WH190 WH20.1
WH20.2 WH20.3 WH20.4 WH20.5 WH20.6 WH20.7
WH22.1 WH220 WH222 WH25.1 WH25.2 WH30.1
WH30.2 WH30.3 WH30.4 WH31.1 WH31.2 WH31.3
WH31.4 WH32.1 WH32.2 WH32.3 WH32.4 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 WO10.1 WO120
WO130 WO131 WO132 WO133 WO140 WO20.1
WO215 WO220 WO232 WO235 WO250 WO251
WO252 WO255 WO256 WO280 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 IC331 IC81.1 IC82.1 IC840
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ICB-COMPANY Numeric 4 IC15.2 IC331
Element: Company The company number represents an IC81.1 IC82.1
established company and is entered on IC840
all function codes.
ICB-LOCATION Alpha 5 IC15.2 IC331
Element: Location Code This field contains a valid stocking IC81.1 IC82.1
location within the company inventory. IC840
ICB-BIN Alpha 7 IC15.2 IC331
Element: Bin This field contains a storage area for IC81.1 IC82.1
an item or any number of items. IC840
ICB-BIN-TYPE Alpha 1 IC15.2 IC331
Element: Bin Usage TypeThis field indicates how the bin is IC81.1 IC82.1
used (for example, for inspection). IC840
ICB-STORAGE-CODE Alpha 5 IC15.2 IC24.1
Element: Bin Storage CoThis field contains a code assigned to IC331 IC81.1
describe the physical characteristics of IC82.1 IC840
a bin.
ICBIN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ICBSET1 COMPANY AP125 AP126
LOCATION AP131 AP20.1
BIN AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
CXCP.1 DR100
IC02.1 IC10.1
IC10.2 IC12.1
IC12.2 IC120
IC125 IC130
IC134 IC138
IC140 IC141
...
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
|
