Integration.StockHolding_Staging
Documentation | WideWorldImportersDW |
Schema | Integration |
Name | StockHolding_Staging |
Stock holding staging table
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | Stock Holding Staging Key | bigint | Identity | DW key for a row in the Stock Holding fact | ||||
DW key for a row in the Stock Holding fact Identity |
||||||||
2 | Stock Item Key | int | Stock item being held | |||||
Stock item being held |
||||||||
3 | Quantity On Hand | int | Quantity on hand | |||||
Quantity on hand |
||||||||
4 | Bin Location | nvarchar(20) | Bin location (where is this stock in the warehouse) | |||||
Bin location (where is this stock in the warehouse) |
||||||||
5 | Last Stocktake Quantity | int | Quantity present at last stocktake | |||||
Quantity present at last stocktake |
||||||||
6 | Last Cost Price | decimal(18, 2) | Unit cost when the stock item was last purchased | |||||
Unit cost when the stock item was last purchased |
||||||||
7 | Reorder Level | int | Quantity below which reordering should take place | |||||
Quantity below which reordering should take place |
||||||||
8 | Target Stock Level | int | Typical stock level held | |||||
Typical stock level held |
||||||||
9 | WWI Stock Item ID | int | Stock Item ID in source system | |||||
Stock Item ID in source system |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PK_Integration_Stock_Holding_Staging | Stock Holding Staging Key | Primary key (nonclustered) constraint. | |
Primary key (nonclustered) constraint. |
Exported: 2019-02-04 23:05, Last imported: 2018-08-10 09:59