BIN_LOCATIONS
Bin Locations
tableFINBIN
BIN_LOCATIONS — Bin Locations. FIN table in the standard Ross ERP 8.0 schema: 46 columns, used by 98 programs. Columns, data types, keys, foreign keys and relationships.
Open BIN_LOCATIONS in the interactive Data Dictionary →Part of Other tables & objects · all tables, views & procedures
Columns
| # | Column | Type | Key | Description |
|---|---|---|---|---|
| 1 | GEM_DBKEY | int | GEMBASE internal surrogate primary key: a system-generated unique row identifier (the database key). Not a business field; every table carries one. | |
| 2 | COMPANY_CODE | varchar(10) | PK | Company Code |
| 3 | WAREHOUSE | varchar(2) | PK FK→WAREHOUSE_CONTROLS | Warehouse Code |
| 4 | BIN_LOCATION | varchar(15) | PK | Bin Location |
| 5 | CUBIC_SIZE_UOM | varchar(4) | FK→UNITS_OF_MEASURE | Cubic Size Unit of Measure |
| 6 | WEIGHT_UOM | varchar(4) | FK→UNITS_OF_MEASURE | Weight Unit of Measure |
| 7 | BIN_MAX_CUBIC | numeric(20,4) | Max Cubic Size of bin | |
| 8 | BIN_MAX_WEIGHT | numeric(20,2) | Max Gross Weight of Bin | |
| 9 | BIN_MAX_QTY | numeric(20,6) | Bin Maximum Quantity | |
| 10 | BIN_ACT_CUBIC | numeric(20,4) | Act Cubic Size of Bin | |
| 11 | BIN_ACT_WEIGHT | numeric(20,2) | Act Gross Weight of Bin | |
| 12 | BIN_ACT_QTY | numeric(20,6) | Bin Actual Quantity | |
| 13 | DESCRIPTION | varchar(30) | Description | |
| 14 | BIN_WEIGHT_PERCENT | numeric(10,2) | Percentage Bin Weight Used | |
| 15 | BIN_CUBIC_PERCENT | numeric(10,2) | Percentage Cubic Used | |
| 16 | BIN_AV_LOAD | numeric(10,2) | Bin Average Load | |
| 17 | BIN_TYPE | varchar(6) | FK→BIN_TYPES | Bin Location Type Code |
| 18 | WAREHOUSE_ZONE | varchar(6) | FK→WAREHOUSE_ZONES | Warehouse Zone |
| 19 | MH_UNIT | varchar(4) | FK→UNITS_OF_MEASURE | Material Handling Unit |
| 20 | MH_MAX_QTY | numeric(20,6) | Maximum Number of Material Handling Units in this Bin | |
| 21 | MH_ACT_QTY | numeric(20,6) | Actual Number of Material Handling Units in Bin | |
| 22 | MH_QTY_WASTAGE | numeric(20,6) | Number of Material Handling Units not used in this Bin | |
| 23 | PUT_AWAY_FLAG_1 | varchar(1) | Put Away Key Yes/No Indicator | |
| 24 | PUT_AWAY_FLAG_2 | varchar(1) | Put Away Key Yes/No Indicator | |
| 25 | PUT_AWAY_FLAG_3 | varchar(1) | Put Away Key Yes/No Indicator | |
| 26 | PUT_AWAY_FLAG_4 | varchar(1) | Put Away Key Yes/No Indicator | |
| 27 | PUT_AWAY_FLAG_5 | varchar(1) | Put Away Key Yes/No Indicator | |
| 28 | PUT_AWAY_KEY_1 | varchar(15) | ||
| 29 | PUT_AWAY_KEY_2 | varchar(15) | ||
| 30 | PUT_AWAY_KEY_3 | datetime | ||
| 31 | PUT_AWAY_KEY_4 | datetime | ||
| 32 | PUT_AWAY_KEY_5 | numeric(10,2) | ||
| 33 | ALLOW_PARTIAL_UNITS | varchar(1) | Allow Partial Units Indicator | |
| 34 | ALLOW_WHOLE_UNITS | varchar(1) | Allow Whole Units Indicator | |
| 35 | LOCATION_STATUS | varchar(1) | Location Status Flag | |
| 36 | INFINITE_CAPACITY_VOLUME | varchar(1) | Infinite Capacity for Volume | |
| 37 | INFINITE_CAPACITY_WEIGHT | varchar(1) | Infinite Capacity for Weight | |
| 38 | INFINITE_CAPACITY_QTY | varchar(1) | Infinite Capacity for Quantity | |
| 39 | MH_IN_USE | varchar(1) | Material Handling in Use | |
| 40 | UNIT_INV | varchar(4) | FK→UNITS_OF_MEASURE | Unit of Measure (Inventory) |
| 41 | IC_ALLOW_VARIABLE_MHUS | varchar(1) | Variable MHus allowed in a bin | |
| 42 | CUBIC_AVAILABLE | computed | ||
| 43 | QTY_AVAILABLE | computed | Qty Available | |
| 44 | WEIGHT_AVAILABLE | computed | ||
| 45 | MH_CAPACITY_OUTSTANDING | computed | ||
| 46 | MERGED_LOTS | varchar(1) | Merged Lots |