|
|
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 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 API1.1 BL120
BL122 BL130 BL140 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL80.1 BL820
BL92.1 CXCP.1 IC02.1 IC12.1 IC12.2 IC130
IC215 IC320 IC330 IC812 IC850 MA180
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.7 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA63.1 MA66.2 MA66.3 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 PO16.1 PO190 PO20.1
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO228 PO23.1 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO253 PO27.2 PO29.1 PO30.1 PO30.2
PO30.3 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 PO64.1 POI3.1 POID.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 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 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
UPDATED BY
IC15.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ICB-COMPANY Numeric 4 IC15.2
Element: Company 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 Alpha 5 IC15.2
Element: Location This field contains a valid stocking
location within the company inventory.
ICB-BIN Alpha 7 IC15.2
Element: Bin This field contains a storage area for
an item or any number of items.
ICB-BIN-TYPE Alpha 1 IC15.2
Element: Bin Type This field indicates how the bin is
used (for example, for inspection).
ICB-STORAGE-CODE Alpha 5 IC15.2
Element: Storage Code This field contains a code assigned to
describe the physical characteristics of
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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL140 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL80.1 BL820
...
ICBSET3 COMPANY KeyChange IC01.3
BIN-TYPE
BIN
LOCATION
ICBSET4 COMPANY KeyChange IC330
LOCATION
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
|
