inv.units_of_measure
| Documentation | Inventory |
| Schema | inv |
| Name | units_of_measure |
| Module | Inventory |
List of all used units of measure.
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | uom_code | nvarchar(10) | Unit of measure code | |||||
| Unit of measure code |
||||||||
| 2 | uom_label | nvarchar(50) | Unit of measure name | |||||
| Unit of measure name |
||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| inv.items | inv.units_of_measure | inv.items.uom_code = inv.units_of_measure.uom_code | User-defined relation |
|
|
inv.items.uom_code = inv.units_of_measure.uom_code Name: User-defined relation |
||||
| inv.quantities_onhand | inv.units_of_measure | inv.quantities_onhand.uom_code = inv.units_of_measure.uom_code | User-defined relation |
|
|
inv.quantities_onhand.uom_code = inv.units_of_measure.uom_code Name: User-defined relation |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PK_units_of_measure | uom_code | ||
Used by
| Name |
|---|
|
inv.units_of_measure
|
Exported: 2019-02-04 23:17, Last imported: 2018-02-09 20:31