|
|
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 IC812
UPDATED BY
IC15.1 IC15.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BST-COMPANY Numeric 4 IC15.1
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.
BST-LOCATION Alpha 5 IC15.1
Element: Location This field contains a valid stocking
location within the company inventory.
BST-STORAGE-CODE Alpha 5 IC15.1
Element: Storage Code This field contains a code assigned to
describe the physical characteristics of
a bin.
BST-DESCRIPTION Alpha 30 (Lower Case) IC15.1
Element: Description This field contains the description for
the bin storage code.
BST-CUBIC-FEET Signed 9.3 IC15.1
Element: Cubic Feet This field contains the number of cubic
feet of storage space within the bin.
BST-WEIGHT Signed 9.3 IC15.1
Element: Weight This field contains the total amount of
weight the bin can handle for storage.
BST-QUANTITY Signed 13.4 IC15.1
Element: Quantity This field contains the number of items
the bin can hold.
BST-ACTIVE-STATUS Alpha 1 IC15.1
Element: Active 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 IC15.1 IC15.2
Element: Used Fl 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
BST-UOM Alpha 4 IC15.1
Element: Uom This is the valid stock unit of measure
for this item.
BINSTORAGE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BSTSET1 COMPANY IC12.1 IC15.1
LOCATION IC15.2 IC215
STORAGE-CODE IC330 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
|
