BINSTORAGE

Bin Storage Code

The Bin Storage Code file contains information about the physical storage capacities of a specific type of bin. These storage codes can be assigned to bins with the same physical attributes.

REFERENCED BY
IC12.1 IC215 IC330 IC51.1 IC511 IC512
IC812


UPDATED BY
IC10.2 IC15.1 IC15.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BST-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.1
BST-LOCATION
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
IC15.1
BST-STORAGE-CODE
Element: Storage Code
Alpha 5
This field contains a code assigned to describe the physical characteristics of a bin.
IC15.1
BST-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field contains the description for the bin storage code.
IC15.1
BST-CUBIC-FEET
Element: Cubic Feet
Signed 9.3
This field contains the number of cubic feet of storage space within the bin.
IC15.1
BST-WEIGHT
Element: Weight
Signed 9.3
This field contains the total amount of weight the bin can handle for storage.
IC15.1
BST-QUANTITY
Element: Quantity
Signed 13.4
This field contains the number of items the bin can hold.
IC15.1
BST-ACTIVE-STATUS
Element: Active Status
Alpha 1
This field is used to limit the use of a storage code. If the status is inactive, the bin storage code cannot be added to the Item Location record.
A = Active
I = Inactive
IC15.1
BST-USED-FL
Element: Used Fl
Alpha 1
This field indicates whether a bin storage code has been used in the Item Location file. Once it has been used, it cannot be deleted.
N = No
Y = Yes
IC10.2 IC15.1
IC15.2
BST-UOM
Element: Uom
Alpha 4
This is the valid stock unit of measure for this item.
IC15.1


BINSTORAGE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BSTSET1 COMPANY
LOCATION
STORAGE-CODE
IC10.1 IC10.2
IC12.1 IC15.1
IC15.2 IC215
IC330 IC51.1
IC511 IC512
IC812


BINSTORAGE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company ICCOMPANY Required
BST-COMPANY->ICC-COMPANY
Location ICLOCATION Required
BST-COMPANY->ICL-COMPANY
BST-LOCATION->ICL-LOCATION


File created: Thu Jun 09 02:18:24 2016

Home
Contact Us



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