inv.quantities_onhand
| Documentation | Inventory |
| Schema | inv |
| Name | quantities_onhand |
| Module | Inventory |
Stores quantity on hand information calculated each time transactoin is recorded.
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | quantity_id | int | inv.quantities_onhand | Row ID | ||||
| Row ID References: inv.quantities_onhand |
||||||||
| 2 | date | date | Date quantities were last calculated | |||||
| Date quantities were last calculated |
||||||||
| 3 | item_id | int | inv.items | Item | ||||
| Item References: inv.items |
||||||||
| 4 | quantity | int | Quanitity in UOM | |||||
| Quanitity in UOM |
||||||||
| 5 | uom_code | nvarchar(10) | inv.units_of_measure | UOM in which quantity is expressed | ||||
| UOM in which quantity is expressed References: inv.units_of_measure |
||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| inv.quantities_onhand | inv.items | inv.quantities_onhand.item_id = inv.items.item_id | FK_quantities_onhand_items |
|
|
inv.quantities_onhand.item_id = inv.items.item_id Name: FK_quantities_onhand_items |
||||
| inv.quantities_onhand | inv.quantities_onhand | inv.quantities_onhand.quantity_id = inv.quantities_onhand.quantity_id | FK_quantities_onhand_quantities_onhand |
|
|
inv.quantities_onhand.quantity_id = inv.quantities_onhand.quantity_id Name: FK_quantities_onhand_quantities_onhand |
||||
| 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 |
||||
| inv.quantities_onhand | inv.quantities_onhand | inv.quantities_onhand.quantity_id = inv.quantities_onhand.quantity_id | FK_quantities_onhand_quantities_onhand |
|
|
inv.quantities_onhand.quantity_id = inv.quantities_onhand.quantity_id Name: FK_quantities_onhand_quantities_onhand |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PK_quantity_onhand | quantity_id | ||
Uses
| Name |
|---|
|
inv.quantities_onhand
|
|
inv.quantities_onhand
|
Used by
| Name |
|---|
|
inv.quantities_onhand
|
|
inv.quantities_onhand
|
Exported: 2019-02-04 23:17, Last imported: 2018-02-09 20:32