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 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 IC189
IC20.1 IC20.2 IC21.1 IC21.2 IC21.5 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 IC243 IC25.1
IC258 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 IC58.1 IC58.2
IC58.3 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 IC93.1 IC95.1 IC95.2
IC95.3 PC120 MA180 MA278 MA41.1 MA41.2
MA41.4 MA41.7 MA42.2 MA43.2 MA43.7 MA44.1
MA44.2 MA53.1 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 PD570 PO04.1 PO04.2
PO10.1 PO10.2 PO100 PO101 PO115 PO120
PO122 PO131 PO132 PO136 PO15.1 PO15.2
PO15.4 PO150 PO16.1 PO17.1 PO190 PO20.1
PO20.6 PO20.9 PO204 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO22.3 PO22.4 PO220
PO222 PO224 PO225 PO228 PO229 PO23.1
PO230 PO234 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO251 PO253 PO26.3 PO26.7 PO26.9
PO27.2 PO27.3 PO27.4 PO275 PO276 PO277
PO28.2 PO280 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 RQ01.1 RQ10.1 RQ10.2 RQ10.3
RQ10.4 RQ10.5 RQ11.1 RQ12.1 RQ13.1 RQ13.2
RQ270 RQ35.1 RQ39.1 RQ39.2 RQ39.3 RQ44.1
RQ500 RQ810 RQIB.1 RQIC.1 RQID.1 RQIF.1
RQIG.1 RQIH.1 RQII.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
IC01.3 IC51.1


UPDATED BY
AP510 IC15.2 IC331 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
ICB-GEO-TYPE
Element: Customer Code
Alpha 4
ICB-GEO-LATITUDE
Element: Gis Coordinate
Signed 12.6
ICB-GEO-LONGITUDE
Element: Gis Coordinate
Signed 12.6
ICB-GEO-ALTITUDE
Element: Gis Coordinate
Signed 12.6
ICB-GEO-DATE
Element: Date
Numeric 8 (yyyymmdd)
ICB-GEO-TIME
Element: Time
Numeric 8


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 02:18:32 2016

Home
Contact Us



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