Databases > WideWorldImporters > Tables > Purchasing.PurchaseOrders

WideWorldImporters

Purchasing.PurchaseOrders

//
Details of supplier purchase orders

Created: Modified:

Columns

  • //
    ${escapify(column.description)}
    PurchaseOrderID
    [int] NOT NULL DEFAULT (NEXT VALUE FOR [Sequences].[PurchaseOrderID])
  • //
    ${escapify(column.description)}
    SupplierID
    [int] NOT NULL
  • //
    ${escapify(column.description)}
    OrderDate
    [date] NOT NULL
  • //
    ${escapify(column.description)}
    DeliveryMethodID
    [int] NOT NULL
  • //
    ${escapify(column.description)}
    ContactPersonID
    [int] NOT NULL
  • //
    ${escapify(column.description)}
    ExpectedDeliveryDate
    [date] NULL
  • //
    ${escapify(column.description)}
    SupplierReference
    [nvarchar](20) NULL
  • //
    ${escapify(column.description)}
    IsOrderFinalized
    [bit] NOT NULL
  • //
    ${escapify(column.description)}
    Comments
    [nvarchar](MAX) NULL
  • //
    ${escapify(column.description)}
    InternalComments
    [nvarchar](MAX) NULL
  • LastEditedBy
    [int] NOT NULL
  • LastEditedWhen
    [datetime2](8) NOT NULL DEFAULT (sysdatetime())

Indexes

  • PK_Purchasing_PurchaseOrders
    UNIQUE CLUSTERED
    PurchaseOrderID
  • //
    Auto-created to support a foreign key
    FK_Purchasing_PurchaseOrders_SupplierID
    NONCLUSTERED
    SupplierID
  • //
    Auto-created to support a foreign key
    FK_Purchasing_PurchaseOrders_DeliveryMethodID
    NONCLUSTERED
    DeliveryMethodID
  • //
    Auto-created to support a foreign key
    FK_Purchasing_PurchaseOrders_ContactPersonID
    NONCLUSTERED
    ContactPersonID

Foreign Keys

  • FK_Purchasing_PurchaseOrders_Application_People
    Application.People
    LastEditedBy ⥱ PersonID
  • FK_Purchasing_PurchaseOrders_ContactPersonID_Application_People
    Application.People
    ContactPersonID ⥱ PersonID
  • FK_Purchasing_PurchaseOrders_DeliveryMethodID_Application_DeliveryMethods
    Application.DeliveryMethods
    DeliveryMethodID ⥱ DeliveryMethodID
  • FK_Purchasing_PurchaseOrders_SupplierID_Purchasing_Suppliers
    Purchasing.Suppliers
    SupplierID ⥱ SupplierID

Sample Data

PurchaseOrderID
SupplierID
OrderDate
DeliveryMethodID
ContactPersonID
ExpectedDeliveryDate
SupplierReference
IsOrderFinalized
Comments
InternalComments
LastEditedBy
LastEditedWhen
1
2
9
2
B2084020
true
NULL
NULL
6
2
4
7
2
293092
true
NULL
NULL
6
3
5
10
2
08803922
true
NULL
NULL
6
4
7
2
2
BC0280982
true
NULL
NULL
6
5
10
8
2
ML0300202
true
NULL
NULL
6
6
12
7
2
237408032
true
NULL
NULL
6
7
4
7
2
293092
true
NULL
NULL
5
8
5
10
2
08803922
true
NULL
NULL
5
9
7
2
2
BC0280982
true
NULL
NULL
5
10
10
8
2
ML0300202
true
NULL
NULL
5
11
12
7
2
237408032
true
NULL
NULL
5
12
4
7
2
293092
true
NULL
NULL
3
13
5
10
2
08803922
true
NULL
NULL
3
14
7
2
2
BC0280982
true
NULL
NULL
3
15
10
8
2
ML0300202
true
NULL
NULL
3
16
12
7
2
237408032
true
NULL
NULL
3
17
4
7
2
293092
true
NULL
NULL
14
18
5
10
2
08803922
true
NULL
NULL
14
19
7
2
2
BC0280982
true
NULL
NULL
14
20
10
8
2
ML0300202
true
NULL
NULL
14
21
4
7
2
293092
true
NULL
NULL
14
22
5
10
2
08803922
true
NULL
NULL
14
23
7
2
2
BC0280982
true
NULL
NULL
14
24
10
8
2
ML0300202
true
NULL
NULL
14
25
12
7
2
237408032
true
NULL
NULL
14