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
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. |
|
||||||||||||
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 |
|
||||||||||||
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 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ICBSET1 |
COMPANY LOCATION BIN |
|
|||||||||||
ICBSET3 |
COMPANY BIN-TYPE BIN LOCATION |
|
| ||||||||||
ICBSET4 |
COMPANY LOCATION STORAGE-CODE BIN |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Binstorage | BINSTORAGE |
Required
| ||||||||||||||||||||||||
Company | ICCOMPANY |
Required
| ||||||||||||||||||||||||
Glnloc | GLNLOC |
Not Required
| ||||||||||||||||||||||||
Glnlocdtl | GLNLOCDTL |
Not Required
| ||||||||||||||||||||||||
Location | ICLOCATION |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Stockonhand | SOHDETAIL |
Delete Restricted
|
All trademarks and registered trademarks are the property of their
respective owners.