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
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1 PO136
PO190 PO300 PO520 PO64.1 POCP.1 POI3.1
POII.1 POIJ.1


UPDATED BY
AP510

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.
ICB-LOCATION
Element: Location		Alpha 5
This field contains a valid stocking location within the company inventory.
ICB-BIN
Element: Bin		Alpha 7
This field contains a storage area for an item or any number of items.
ICB-BIN-TYPE
Element: Bin Type		Alpha 1
This field indicates how the bin is used (for example, for inspection).
ICB-STORAGE-CODE
Element: Storage Code		Alpha 5
This field contains a code assigned to describe the physical characteristics of a bin.
ICB-GLN-NBR
Element: Gln Nbr		Alpha 13
AP510


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 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
ICBSET3 COMPANY
BIN-TYPE
BIN
LOCATION
KeyChange
ICBSET4 COMPANY
LOCATION
STORAGE-CODE
BIN
KeyChange


ICBIN FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Company ICCOMPANY Required
ICB-COMPANY->ICC-COMPANY (ICCSET1)
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: Wed Jun 08 20:49:37 2016

Home
Contact Us



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