BIN_LOCATION_DETAILS
Bin Location Qty Details
tableFINBIN
BIN_LOCATION_DETAILS — Bin Location Qty Details. FIN table in the standard Ross ERP 8.0 schema: 26 columns, used by 44 programs. Columns, data types, keys, foreign keys and relationships.
Open BIN_LOCATION_DETAILS 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 FK→BIN_LOCATIONS | Bin Location |
| 5 | PART_CODE | varchar(15) | PK FK→PRODUCT_MASTER | Product |
| 6 | MH_NUMBER | int | PK | Material Handling Number |
| 7 | PHYS_COUNT_NUMBER | int | Count Number | |
| 8 | COUNT_SEQ_NUMBER | int | Inventory Count Sequence Number | |
| 9 | LAST_COUNT_DATE | datetime | Last Inventory Count Date | |
| 10 | CUBIC_SIZE | numeric(20,4) | Cubic Size of Product | |
| 11 | WEIGHT_GROSS | numeric(20,4) | Gross Weight of Product | |
| 12 | LAST_MODIFIED_DATE | datetime | Last Modified Date | |
| 13 | RECEIVED_DATE | datetime | Received Date | |
| 14 | BEST_BEFORE_DATE | datetime | Best Before End / Best Before Date | |
| 15 | SYSTEM_DATE | datetime | System Date Transaction Made | |
| 16 | BATCH_DATE | datetime | Batch Date | |
| 17 | MH_UNIT | varchar(4) | FK→UNITS_OF_MEASURE | Material Handling Unit |
| 18 | MH_CONVERSION_FACTOR | numeric(20,4) | Conversion from Inv Unit to Mtrl Handling Unit | |
| 19 | USERNAME | varchar(20) | Username | |
| 20 | IC_LOT_NUMBER | varchar(20) | PK FK→PART_BATCHES | Lot Number |
| 21 | QTY_IN_BIN | numeric(20,6) | Qty In Bin | |
| 22 | IC_LOT_SEQUENCE | int | Lot Sequence | |
| 23 | IC_LAST_SPOT_COUNT_DATE | datetime | Last Spot Check Count Date | |
| 24 | IC_LAST_CYCLE_COUNT_DATE | datetime | ||
| 25 | IC_LAST_PHYSICAL_COUNT_DATE | datetime | ||
| 26 | COMPLETE_RATIO | computed |