Databases > WideWorldImporters > Tables > Purchasing.PurchaseOrderLines

WideWorldImporters

Purchasing.PurchaseOrderLines

//
Detail lines from supplier purchase orders

Created: Modified:

Columns

  • //
    ${escapify(column.description)}
    PurchaseOrderLineID
    [int] NOT NULL DEFAULT (NEXT VALUE FOR [Sequences].[PurchaseOrderLineID])
  • //
    ${escapify(column.description)}
    PurchaseOrderID
    [int] NOT NULL
  • //
    ${escapify(column.description)}
    StockItemID
    [int] NOT NULL
  • //
    ${escapify(column.description)}
    OrderedOuters
    [int] NOT NULL
  • //
    ${escapify(column.description)}
    Description
    [nvarchar](100) NOT NULL
  • //
    ${escapify(column.description)}
    ReceivedOuters
    [int] NOT NULL
  • //
    ${escapify(column.description)}
    PackageTypeID
    [int] NOT NULL
  • //
    ${escapify(column.description)}
    ExpectedUnitPricePerOuter
    [decimal](18, 2) NULL
  • //
    ${escapify(column.description)}
    LastReceiptDate
    [date] NULL
  • //
    ${escapify(column.description)}
    IsOrderLineFinalized
    [bit] NOT NULL
  • LastEditedBy
    [int] NOT NULL
  • LastEditedWhen
    [datetime2](8) NOT NULL DEFAULT (sysdatetime())

Indexes

  • PK_Purchasing_PurchaseOrderLines
    UNIQUE CLUSTERED
    PurchaseOrderLineID
  • //
    Auto-created to support a foreign key
    FK_Purchasing_PurchaseOrderLines_PurchaseOrderID
    NONCLUSTERED
    PurchaseOrderID
  • //
    Auto-created to support a foreign key
    FK_Purchasing_PurchaseOrderLines_StockItemID
    NONCLUSTERED
    StockItemID
  • //
    Auto-created to support a foreign key
    FK_Purchasing_PurchaseOrderLines_PackageTypeID
    NONCLUSTERED
    PackageTypeID
  • //
    Improves performance of order picking and invoicing
    IX_Purchasing_PurchaseOrderLines_Perf_20160301_4
    NONCLUSTERED
    IsOrderLineFinalized , StockItemID , OrderedOuters , ReceivedOuters

Foreign Keys

  • FK_Purchasing_PurchaseOrderLines_Application_People
    Application.People
    LastEditedBy ⥱ PersonID
  • FK_Purchasing_PurchaseOrderLines_PackageTypeID_Warehouse_PackageTypes
    Warehouse.PackageTypes
    PackageTypeID ⥱ PackageTypeID
  • FK_Purchasing_PurchaseOrderLines_PurchaseOrderID_Purchasing_PurchaseOrders
    Purchasing.PurchaseOrders
    PurchaseOrderID ⥱ PurchaseOrderID
  • FK_Purchasing_PurchaseOrderLines_StockItemID_Warehouse_StockItems
    Warehouse.StockItems
    StockItemID ⥱ StockItemID

Sample Data

PurchaseOrderLineID
PurchaseOrderID
StockItemID
OrderedOuters
Description
ReceivedOuters
PackageTypeID
ExpectedUnitPricePerOuter
LastReceiptDate
IsOrderLineFinalized
LastEditedBy
LastEditedWhen
1
1
150
18
Pack of 12 action figures (variety)
18
9
5.5
true
6
2
1
151
21
Pack of 12 action figures (male)
21
9
5.5
true
6
3
1
152
18
Pack of 12 action figures (female)
18
9
5.5
true
6
4
2
76
8
"The Gu" red shirt XML tag t-shirt (White) 3XS
8
6
84
true
6
5
2
77
1
"The Gu" red shirt XML tag t-shirt (White) XXS
1
6
84
true
6
6
2
78
1
"The Gu" red shirt XML tag t-shirt (White) XS
1
6
84
true
6
7
2
80
2
"The Gu" red shirt XML tag t-shirt (White) M
2
6
84
true
6
8
2
81
7
"The Gu" red shirt XML tag t-shirt (White) L
7
6
84
true
6
9
2
84
3
"The Gu" red shirt XML tag t-shirt (White) 3XL
3
6
96
true
6
10
2
85
5
"The Gu" red shirt XML tag t-shirt (White) 4XL
5
6
96
true
6
11
2
86
1
"The Gu" red shirt XML tag t-shirt (White) 5XL
1
6
96
true
6
12
2
88
9
"The Gu" red shirt XML tag t-shirt (White) 7XL
9
6
102
true
6
13
2
89
6
"The Gu" red shirt XML tag t-shirt (Black) 3XS
6
6
84
true
6
14
2
92
6
"The Gu" red shirt XML tag t-shirt (Black) S
6
6
84
true
6
15
2
94
9
"The Gu" red shirt XML tag t-shirt (Black) L
9
6
84
true
6
16
2
95
2
"The Gu" red shirt XML tag t-shirt (Black) XL
2
6
90
true
6
17
2
98
1
"The Gu" red shirt XML tag t-shirt (Black) 4XL
1
6
96
true
6
18
2
99
14
"The Gu" red shirt XML tag t-shirt (Black) 5XL
14
6
96
true
6
19
2
100
14
"The Gu" red shirt XML tag t-shirt (Black) 6XL
14
6
96
true
6
20
2
102
6
Alien officer hoodie (Black) XL
6
7
17
true
6
21
2
104
10
Alien officer hoodie (Black) 3XL
10
7
17
true
6
22
2
109
16
Superhero action jacket (Blue) XS
16
7
19
true
6
23
2
110
12
Superhero action jacket (Blue) S
12
7
19
true
6
24
2
111
7
Superhero action jacket (Blue) M
7
7
22
true
6
25
2
113
6
Superhero action jacket (Blue) XL
6
7
22
true
6