|
|
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 AP25.1 AP25.2 AP26.1
AP27.1 AP30.4 BL120 BL122 BL130 BL140
BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2
BL520 BL820 BL92.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
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 IC62.4 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 PC120
SEA1.1 MA180 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 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
OE111 OE113 OE114 OE116 OE129 OE13.1
OE13.2 OE13.3 OE13.4 OE13.5 OE13.6 OE14.4
OE229 OE270 OE271 OE30.1 OE30.2 OE30.3
OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE510
OE530 OE81.1 OE81.3 OE810 OE830 OE86.1
OE90.1 OE90.2 PO100 PO101 PO122 PO131
PO16.1 PO20.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO228 PO23.1 PO29.1 PO30.1 PO30.2
PO30.3 PO300 PO31.1 PO31.2 PO32.2 PO33.1
PO34.1 PO35.1 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 PO64.1 POI3.1 POIE.1
POII.1 POIJ.1 RQ10.1 RQ10.2 RQ10.3 RQ11.1
RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ39.1 RQ39.2
RQ39.3 RQ500 RQIC.1 RQID.1 RQIF.1 RQIG.1
RQIH.1 RQIJ.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 Identifies the AP company if the IC81.1 IC82.1
resource type = V. Identifies the HR IC840
company if the resource type = E. It is
blank for type A, P or Q resources.
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 AP25.1
BIN AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC02.1
IC10.1 IC10.2
IC12.1 IC12.2
IC120 IC125
...
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
|
