Databases > WideWorldImporters > Tables > Warehouse.StockItemHoldings

WideWorldImporters

Warehouse.StockItemHoldings

//
Non-temporal attributes for stock items

Created: Modified:

Columns

  • //
    ${escapify(column.description)}
    StockItemID
    [int] NOT NULL
  • //
    ${escapify(column.description)}
    QuantityOnHand
    [int] NOT NULL
  • //
    ${escapify(column.description)}
    BinLocation
    [nvarchar](20) NOT NULL
  • //
    ${escapify(column.description)}
    LastStocktakeQuantity
    [int] NOT NULL
  • //
    ${escapify(column.description)}
    LastCostPrice
    [decimal](18, 2) NOT NULL
  • //
    ${escapify(column.description)}
    ReorderLevel
    [int] NOT NULL
  • //
    ${escapify(column.description)}
    TargetStockLevel
    [int] NOT NULL
  • LastEditedBy
    [int] NOT NULL
  • LastEditedWhen
    [datetime2](8) NOT NULL DEFAULT (sysdatetime())

Indexes

  • PK_Warehouse_StockItemHoldings
    UNIQUE CLUSTERED
    StockItemID

Foreign Keys

  • FK_Warehouse_StockItemHoldings_Application_People
    Application.People
    LastEditedBy ⥱ PersonID
  • PKFK_Warehouse_StockItemHoldings_StockItemID_Warehouse_StockItems
    Warehouse.StockItems
    StockItemID ⥱ StockItemID

Sample Data

StockItemID
QuantityOnHand
BinLocation
LastStocktakeQuantity
LastCostPrice
ReorderLevel
TargetStockLevel
LastEditedBy
LastEditedWhen
1
175609
L-1
171341
9.5
20
100
16
2
165538
L-1
161435
9.5
20
100
3
3
253190
L-2
246900
11.25
10
120
3
4
208109
L-3
202964
12
5
100
3
5
199064
L-3
194162
12
5
100
3
6
196995
L-3
192127
12
5
100
3
7
205295
L-3
200201
12
5
100
16
8
412277
L-3
401980
88.5
10
200
16
9
192749
L-3
187968
12
5
100
3
10
222572
L-3
217048
12
5
100
3
11
203148
L-3
198084
12
5
100
3
12
200406
L-3
195396
12
5
100
3
13
197453
L-3
192553
12
5
100
3
14
192358
L-3
187553
12
5
100
3
15
398290
L-3
388445
88.5
10
200
16
16
51836
K-9
50541
4.5
15
40
16
17
62428
K-9
60923
4.5
15
40
3
18
89207
K-9
86985
4.5
15
40
16
19
68800
K-9
67153
4.5
15
40
3
20
66722
K-9
65070
4.5
15
40
3
21
68683
K-9
67023
4.5
15
40
3
22
72747
K-9
70913
4.5
15
40
16
23
56283
K-9
54910
4.5
15
40
3
24
57083
K-9
55653
4.5
15
40
3
25
47106
K-9
45926
4.5
15
40
3