ICBIN

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 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 API1.1 API2.1
CX05.1 CX05.2 CX100 CX20.1 CX20.2 CX20.4
CX20.5 CX205 CX220 CX30.1 CX300 CX506
CX805 CXCP.1 DR100 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 IC21.5 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 IC574 IC598
IC61.1 IC62.1 IC62.2 IC62.4 IC66.1 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 ZC522
MA180 MA41.1 MA41.2 MA41.4 MA41.7 MA42.2
MA43.2 MA43.7 MA44.1 MA44.2 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA63.1 MA66.2
MA67.2 MA67.3 MA68.2 MA68.3 MA68.5 MA69.1
MA69.2 MA70.1 MA75.1 MA80.1 MAI1.1 PD10.1
PD10.2 PD130 PD20.1 PD20.2 PD20.3 PO100
PO101 PO122 PO131 PO136 PO150 PO16.1
PO190 PO20.1 PO20.6 PO20.9 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO22.3 PO22.4
PO228 PO23.1 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO253 PO27.2 PO28.2 PO29.1 PO30.1
PO30.2 PO30.3 PO30.4 PO300 PO31.1 PO31.2
PO32.2 PO32.4 PO33.1 PO34.1 PO35.1 PO36.1
PO36.2 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 PO536 PO54.5 PO64.1 POCP.1
POI3.1 POID.1 POII.1 POIJ.1 RQ10.1 RQ10.2
RQ10.3 RQ10.4 RQ11.1 RQ12.1 RQ13.1 RQ13.2
RQ270 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 WH224 WH226
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 WH32.5 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 ZW130 IC215 IC258 IC58.1
IC58.2 IC58.3 IC01.3


UPDATED BY
AP510 IC02.1 IC15.2 IC331 IC51.1 IC64.1
IC64.2 IC64.3 IC64.4 IC64.5 IC64.6 IC64.7
IC64.8 IC64.9 IC81.1 IC82.1 IC840

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ICB-COMPANY
Element: Company		Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
IC15.2 IC331
IC81.1 IC82.1
IC840
ICB-LOCATION
Element: Location		Alpha 5
This field contains a valid stocking location within the company inventory.
IC15.2 IC331
IC81.1 IC82.1
IC840
ICB-BIN
Element: Bin		Alpha 7
This field contains a storage area for an item or any number of items.
IC15.2 IC331
IC81.1 IC82.1
IC840
ICB-BIN-TYPE
Element: Bin Type		Alpha 1
This field indicates how the bin is used (for example, for inspection).
IC15.2 IC331
IC81.1 IC82.1
IC840
ICB-STORAGE-CODE
Element: Storage Code		Alpha 5
This field contains a code assigned to describe the physical characteristics of a bin.
IC15.2 IC24.1
IC331 IC81.1
IC82.1 IC840
ICB-GLN-NBR
Element: Gln Nbr		Alpha 13
AP510 IC15.2
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9


ICBIN FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ICBSET1 COMPANY
LOCATION
BIN
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX05.1
CX05.2 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX205 CX220
CX30.1 CX300
ICBSET3 COMPANY
BIN-TYPE
BIN
LOCATION
KeyChange
IC01.3
ICBSET4 COMPANY
LOCATION
STORAGE-CODE
BIN
KeyChange
IC10.1 IC10.2
IC330 IC51.1


ICBIN FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
Glnloc GLNLOC Not Required
Valid When ICB-GLN-NBR !=Spaces
ICC-ITEM-GROUP->GLO-ITEM-GROUP
ICB-GLN-NBR->GLO-GLN-NBR
Glnlocdtl GLNLOCDTL Not Required
Valid When ICB-GLN-NBR !=Spaces
GLO-ITEM-GROUP->GLX-ITEM-GROUP
11->GLX-GLN-TYPE
ICB-COMPANY->GLX-COMPANY
ICB-LOCATION->GLX-LOCATION
ICB-BIN->GLX-BIN
ICB-GLN-NBR->GLX-GLN-NBR
Location ICLOCATION Required
ICB-COMPANY->ICL-COMPANY
ICB-LOCATION->ICL-LOCATION


ICBIN FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED 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

File created: Thu Jun 09 11:16:51 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.