BINSTORAGE FILE
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 IC812
UPDATED BY
IC10.2 IC15.1 IC15.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BST-COMPANY Numeric 4 IC15.1
Company The company number represents an
established company and is entered on
all function codes.
BST-LOCATION Alpha 5 IC15.1
Location Code This field contains a valid stocking
location within the company inventory.
BST-STORAGE-CODE Alpha 5 IC15.1
Bin Storage Code This field contains a code assigned to
describe the physical characteristics of
a bin.
BST-DESCRIPTION Alpha 30 (Lower Case) IC15.1
Description This field contains the description for
the bin storage code.
BST-CUBIC-FEET Signed 9.3 IC15.1
Cubic Feet This field contains the number of cubic
feet of storage space within the bin.
BST-WEIGHT Signed 9.3 IC15.1
Unit Weight This field contains the total amount of
weight the bin can handle for storage.
BST-QUANTITY Signed 13.4 IC15.1
Quantity This field contains the number of items
the bin can hold.
BST-ACTIVE-STATUS Alpha 1 IC15.1
Status 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
BST-USED-FL Alpha 1 IC10.2 IC15.1
Used This field indicates whether a bin IC15.2
storage code has been used in the Item
Location file. Once it has been used, it
cannot be deleted.
N = No
Y = Yes
BST-UOM Alpha 4 IC15.1
Unit of Measure This is the valid stock unit of measure
for this item.
BINSTORAGE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BSTSET1 COMPANY IC10.1 IC10.2
LOCATION IC12.1 IC15.1
STORAGE-CODE IC15.2 IC215
IC330 IC51.1
IC812
BINSTORAGE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company ICCOMPANY Required
BST-COMPANY -> ICC-COMPANY
Location ICLOCATION Required
BST-COMPANY -> ICL-COMPANY
BST-LOCATION -> ICL-LOCATION
|
