inv.items
| Documentation | Inventory |
| Schema | inv |
| Name | items |
| Module | Inventory |
All items that are stored in warehouses.
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | item_id | int | Item ID | |||||
| Item ID |
||||||||
| 2 | sku | nvarchar(25) | Products.dbo.products | Stock keeping unit (SKU) - unique business identifier used within orgranization | ||||
| Stock keeping unit (SKU) - unique business identifier used within orgranization References: Products.dbo.products |
||||||||
| 3 | name | nvarchar(50) | Item name, for convenience includes key measurements, vendor name | |||||
| Item name, for convenience includes key measurements, vendor name |
||||||||
| 4 | uom_code | nchar(10) | inv.units_of_measure | Item default unit of measure | ||||
| Item default unit of measure References: inv.units_of_measure |
||||||||
| 5 | vendor_sku | nchar(10) | Vendor SKU | |||||
| Vendor SKU |
||||||||
| 6 | vendor_name | nchar(10) | Name of vendor if applicable | |||||
| Name of vendor if applicable |
||||||||
| 7 | category_id | int | inv.item_categories | Item category | ||||
| Item category References: inv.item_categories |
||||||||
| 8 | default_warehouse_id | int | inv.warehouses | Default warehouse | ||||
| Default warehouse References: inv.warehouses |
||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| inv.items | inv.item_categories | inv.items.category_id = inv.item_categories.item_category_id | FK_items_item_categories |
|
|
inv.items.category_id = inv.item_categories.item_category_id Name: FK_items_item_categories |
||||
| inv.items | Products.dbo.products | inv.items.sku = Products.dbo.products.sku | User-defined relation | |
|
inv.items.sku = Products.dbo.products.sku Name: User-defined relation |
||||
| 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.items | inv.warehouses | inv.items.default_warehouse_id = inv.warehouses.warehouse_id | FK_items_warehouses |
|
|
inv.items.default_warehouse_id = inv.warehouses.warehouse_id Name: FK_items_warehouses |
||||
| Procurement.pur.item_suppliers (Item suppliers) | inv.items | Procurement.pur.item_suppliers.item_id = inv.items.item_id | User-defined relation |
|
|
Procurement.pur.item_suppliers.item_id = inv.items.item_id Name: User-defined relation |
||||
| Procurement.pur.items | inv.items | Procurement.pur.items.item_id = inv.items.item_id | Items relation cross DB Items relation |
|
|
Procurement.pur.items.item_id = inv.items.item_id Name: Items relation cross DBItems relation |
||||
| 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.transactions | inv.items | inv.transactions.item_id = inv.items.item_id | User-defined relation |
|
|
inv.transactions.item_id = inv.items.item_id Name: User-defined relation |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PK_items | item_id | ||
| User-defined unique key | sku | ||
Uses
Used by
Exported: 2019-02-04 23:17, Last imported: 2018-02-09 20:31