Table: [AdventureWorks2016CTP3].[Purchasing].[PurchaseOrderHeader]

CollapseAll image

Collapse image Table properties


Name  Value 
 Schema  [Purchasing]
 Owner  [dbo]
 Table is replicated   
 Creation date  23.10.2015
 ID  1266103551
 Located on  PRIMARY
 Data size KB  336 KB
 Index size KB  160 KB
 Rows  4012
 ChangeTrackingEnabled   
 FileStreamFileGroup   
 FileStreamPartitionScheme   
 LockEscalation  TABLE
 TrackColumnsUpdatedEnabled   
 Table is filetable   
 Filetable directory   
 Filetable collate   
 Filetable primary key  [PK_PurchaseOrderHeader_PurchaseOrderID]
 Filetable streamid unique   
 Filetable fullpath unique   
 Filetable is enabled   
 Is memory optimized   
 Durability  SCHEMA_AND_DATA

Collapse image Creation options


Name  Value 
QUOTED_IDENTIFIER ON
ANSI_NULLS ON
ANSI_PADDING ON

Collapse image Columns


      Name  Description  Data type  Max length  Nullable  Default IsGUID  SPARSE Computed value
Primary key Identity   PurchaseOrderID     int 4        
      RevisionNumber     tinyint 1   ((0))    
      Status     tinyint 1   ((1))    
    Foreign key EmployeeID     int 4        
    Foreign key VendorID     int 4        
    Foreign key ShipMethodID     int 4        
      OrderDate     datetime 8   (getdate())    
      ShipDate     datetime 8      
      SubTotal     money 8   ((0.00))    
      TaxAmt     money 8   ((0.00))    
      Freight     money 8   ((0.00))    
      TotalDue   True money 8         (isnull(([SubTotal]+[TaxAmt])+[Freight],(0)))
      ModifiedDate     datetime 8   (getdate())    
Total: 13 column(s)

Collapse image Indexes


Index  Description  Primary  Unique  Size KB 
[PK_PurchaseOrderHeader_PurchaseOrderID] PurchaseOrderID   496 0
[IX_PurchaseOrderHeader_EmployeeID] EmployeeID       72 0
[IX_PurchaseOrderHeader_VendorID] VendorID       72 0
Total: 3 Index/indexes

Collapse image Columnstore indexes


No columnstore indexes exist

Collapse image Check constraints


Name  Expression 
CK_PurchaseOrderHeader_Freight ([Freight]>=(0.00))
CK_PurchaseOrderHeader_ShipDate ([ShipDate]>=[OrderDate] OR [ShipDate] IS NULL)
CK_PurchaseOrderHeader_Status ([Status]>=(1) AND [Status]<=(4))
CK_PurchaseOrderHeader_SubTotal ([SubTotal]>=(0.00))
CK_PurchaseOrderHeader_TaxAmt ([TaxAmt]>=(0.00))

Collapse image Identity column


  Name  Seed  Increment  Not for replication 
 PurchaseOrderID   1   1   

Collapse image Referencing tables


Table  Foreign key  Primary key or unique constraint 
[Purchasing].[PurchaseOrderDetail] FK_PurchaseOrderDetail_PurchaseOrderHeader_PurchaseOrderID PK_PurchaseOrderHeader_PurchaseOrderID
Total: 1 table(s)

Collapse image Referenced tables


Table  Primary key or unique constraint  Foreign key 
[HumanResources].[Employee] PK_Employee_BusinessEntityID FK_PurchaseOrderHeader_Employee_EmployeeID
[Purchasing].[ShipMethod] PK_ShipMethod_ShipMethodID FK_PurchaseOrderHeader_ShipMethod_ShipMethodID
[Purchasing].[Vendor] PK_Vendor_BusinessEntityID FK_PurchaseOrderHeader_Vendor_VendorID
Total: 3 table(s)

Collapse image Triggers


Name  Schema  Description  Instead 
of 
For 
insert 
For 
update 
For 
delete 
Table/view 
[Purchasing].[uPurchaseOrderHeader] [Purchasing]       For Update   [Purchasing].[PurchaseOrderHeader]
Total: 1 triggers(s)

Collapse image Objects that depend on [Purchasing].[PurchaseOrderHeader]


Object name Object type Dep level
[Purchasing].[PurchaseOrderDetail] Table 1
[Purchasing].[iPurchaseOrderDetail] Trigger 1
[Purchasing].[uPurchaseOrderDetail] Trigger 1
[Purchasing].[uPurchaseOrderHeader] Trigger 1
Total 4 object(s)

Collapse image Objects that [Purchasing].[PurchaseOrderHeader] depends on


Object name Object type Dep level
[Purchasing] Schema 1
[HumanResources].[Employee] Table 1
[Purchasing].[ShipMethod] Table 1
[Purchasing].[Vendor] Table 1
Total 4 object(s)

Collapse image Extended properties


Name  Value 
MS_Description General purchase order information. See PurchaseOrderDetail.

Collapse image Table options


Name  Value 
Pintable OFF
Table lock on bulk load OFF
Insert row lock OFF
Text in row 0
Large value types out of row OFF

Collapse image SQL


SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
GO
CREATE TABLE [Purchasing].[PurchaseOrderHeader] (
        [PurchaseOrderID]     [int] IDENTITY(1, 1) NOT NULL,
        [RevisionNumber]      [tinyint] NOT NULL,
        [Status]              [tinyint] NOT NULL,
        [EmployeeID]          [int] NOT NULL,
        [VendorID]            [int] NOT NULL,
        [ShipMethodID]        [int] NOT NULL,
        [OrderDate]           [datetime] NOT NULL,
        [ShipDate]            [datetime] NULL,
        [SubTotal]            [money] NOT NULL,
        [TaxAmt]              [money] NOT NULL,
        [Freight]             [money] NOT NULL,
        [TotalDue]            AS (isnull(([SubTotal]+[TaxAmt])+[Freight],(0))) PERSISTED NOT NULL,
        [ModifiedDate]        [datetime] NOT NULL,
        CONSTRAINT [PK_PurchaseOrderHeader_PurchaseOrderID]
        PRIMARY KEY
        CLUSTERED
        ([PurchaseOrderID])
    ON [PRIMARY]
) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Primary key (clustered) constraint', 'SCHEMA', N'Purchasing', 'TABLE', N'PurchaseOrderHeader', 'CONSTRAINT', N'PK_PurchaseOrderHeader_PurchaseOrderID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Clustered index created by a primary key constraint.', 'SCHEMA', N'Purchasing', 'TABLE', N'PurchaseOrderHeader', 'INDEX', N'PK_PurchaseOrderHeader_PurchaseOrderID'
GO
ALTER TABLE [Purchasing].[PurchaseOrderHeader]
    ADD
    CONSTRAINT [CK_PurchaseOrderHeader_Freight]
    CHECK
    ([Freight]>=(0.00))
GO
EXEC sp_addextendedproperty N'MS_Description', N'Check constraint [Freight] >= (0.00)', 'SCHEMA', N'Purchasing', 'TABLE', N'PurchaseOrderHeader', 'CONSTRAINT', N'CK_PurchaseOrderHeader_Freight'
GO
ALTER TABLE [Purchasing].[PurchaseOrderHeader]
CHECK CONSTRAINT [CK_PurchaseOrderHeader_Freight]
GO
ALTER TABLE [Purchasing].[PurchaseOrderHeader]
    ADD
    CONSTRAINT [CK_PurchaseOrderHeader_ShipDate]
    CHECK
    ([ShipDate]>=[OrderDate] OR [ShipDate] IS NULL)
GO
EXEC sp_addextendedproperty N'MS_Description', N'Check constraint [ShipDate] >= [OrderDate] OR [ShipDate] IS NULL', 'SCHEMA', N'Purchasing', 'TABLE', N'PurchaseOrderHeader', 'CONSTRAINT', N'CK_PurchaseOrderHeader_ShipDate'
GO
ALTER TABLE [Purchasing].[PurchaseOrderHeader]
CHECK CONSTRAINT [CK_PurchaseOrderHeader_ShipDate]
GO
ALTER TABLE [Purchasing].[PurchaseOrderHeader]
    ADD
    CONSTRAINT [CK_PurchaseOrderHeader_Status]
    CHECK
    ([Status]>=(1) AND [Status]<=(4))
GO
EXEC sp_addextendedproperty N'MS_Description', N'Check constraint [Status] BETWEEN (1) AND (4)', 'SCHEMA', N'Purchasing', 'TABLE', N'PurchaseOrderHeader', 'CONSTRAINT', N'CK_PurchaseOrderHeader_Status'
GO
ALTER TABLE [Purchasing].[PurchaseOrderHeader]
CHECK CONSTRAINT [CK_PurchaseOrderHeader_Status]
GO
ALTER TABLE [Purchasing].[PurchaseOrderHeader]
    ADD
    CONSTRAINT [CK_PurchaseOrderHeader_SubTotal]
    CHECK
    ([SubTotal]>=(0.00))
GO
EXEC sp_addextendedproperty N'MS_Description', N'Check constraint [SubTotal] >= (0.00)', 'SCHEMA', N'Purchasing', 'TABLE', N'PurchaseOrderHeader', 'CONSTRAINT', N'CK_PurchaseOrderHeader_SubTotal'
GO
ALTER TABLE [Purchasing].[PurchaseOrderHeader]
CHECK CONSTRAINT [CK_PurchaseOrderHeader_SubTotal]
GO
ALTER TABLE [Purchasing].[PurchaseOrderHeader]
    ADD
    CONSTRAINT [CK_PurchaseOrderHeader_TaxAmt]
    CHECK
    ([TaxAmt]>=(0.00))
GO
EXEC sp_addextendedproperty N'MS_Description', N'Check constraint [TaxAmt] >= (0.00)', 'SCHEMA', N'Purchasing', 'TABLE', N'PurchaseOrderHeader', 'CONSTRAINT', N'CK_PurchaseOrderHeader_TaxAmt'
GO
ALTER TABLE [Purchasing].[PurchaseOrderHeader]
CHECK CONSTRAINT [CK_PurchaseOrderHeader_TaxAmt]
GO
ALTER TABLE [Purchasing].[PurchaseOrderHeader]
    ADD
    CONSTRAINT [DF_PurchaseOrderHeader_Freight]
    DEFAULT ((0.00)) FOR [Freight]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Default constraint value of 0.0', 'SCHEMA', N'Purchasing', 'TABLE', N'PurchaseOrderHeader', 'CONSTRAINT', N'DF_PurchaseOrderHeader_Freight'
GO
ALTER TABLE [Purchasing].[PurchaseOrderHeader]
    ADD
    CONSTRAINT [DF_PurchaseOrderHeader_ModifiedDate]
    DEFAULT (getdate()) FOR [ModifiedDate]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Default constraint value of GETDATE()', 'SCHEMA', N'Purchasing', 'TABLE', N'PurchaseOrderHeader', 'CONSTRAINT', N'DF_PurchaseOrderHeader_ModifiedDate'
GO
ALTER TABLE [Purchasing].[PurchaseOrderHeader]
    ADD
    CONSTRAINT [DF_PurchaseOrderHeader_OrderDate]
    DEFAULT (getdate()) FOR [OrderDate]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Default constraint value of GETDATE()', 'SCHEMA', N'Purchasing', 'TABLE', N'PurchaseOrderHeader', 'CONSTRAINT', N'DF_PurchaseOrderHeader_OrderDate'
GO
ALTER TABLE [Purchasing].[PurchaseOrderHeader]
    ADD
    CONSTRAINT [DF_PurchaseOrderHeader_RevisionNumber]
    DEFAULT ((0)) FOR [RevisionNumber]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Default constraint value of 0', 'SCHEMA', N'Purchasing', 'TABLE', N'PurchaseOrderHeader', 'CONSTRAINT', N'DF_PurchaseOrderHeader_RevisionNumber'
GO
ALTER TABLE [Purchasing].[PurchaseOrderHeader]
    ADD
    CONSTRAINT [DF_PurchaseOrderHeader_Status]
    DEFAULT ((1)) FOR [Status]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Default constraint value of 1', 'SCHEMA', N'Purchasing', 'TABLE', N'PurchaseOrderHeader', 'CONSTRAINT', N'DF_PurchaseOrderHeader_Status'
GO
ALTER TABLE [Purchasing].[PurchaseOrderHeader]
    ADD
    CONSTRAINT [DF_PurchaseOrderHeader_SubTotal]
    DEFAULT ((0.00)) FOR [SubTotal]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Default constraint value of 0.0', 'SCHEMA', N'Purchasing', 'TABLE', N'PurchaseOrderHeader', 'CONSTRAINT', N'DF_PurchaseOrderHeader_SubTotal'
GO
ALTER TABLE [Purchasing].[PurchaseOrderHeader]
    ADD
    CONSTRAINT [DF_PurchaseOrderHeader_TaxAmt]
    DEFAULT ((0.00)) FOR [TaxAmt]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Default constraint value of 0.0', 'SCHEMA', N'Purchasing', 'TABLE', N'PurchaseOrderHeader', 'CONSTRAINT', N'DF_PurchaseOrderHeader_TaxAmt'
GO
ALTER TABLE [Purchasing].[PurchaseOrderHeader]
    WITH CHECK
    ADD CONSTRAINT [FK_PurchaseOrderHeader_Employee_EmployeeID]
    FOREIGN KEY ([EmployeeID]) REFERENCES [HumanResources].[Employee] ([BusinessEntityID])
ALTER TABLE [Purchasing].[PurchaseOrderHeader]
    CHECK CONSTRAINT [FK_PurchaseOrderHeader_Employee_EmployeeID]

GO
EXEC sp_addextendedproperty N'MS_Description', N'Foreign key constraint referencing Employee.EmployeeID.', 'SCHEMA', N'Purchasing', 'TABLE', N'PurchaseOrderHeader', 'CONSTRAINT', N'FK_PurchaseOrderHeader_Employee_EmployeeID'
GO
ALTER TABLE [Purchasing].[PurchaseOrderHeader]
    WITH CHECK
    ADD CONSTRAINT [FK_PurchaseOrderHeader_ShipMethod_ShipMethodID]
    FOREIGN KEY ([ShipMethodID]) REFERENCES [Purchasing].[ShipMethod] ([ShipMethodID])
ALTER TABLE [Purchasing].[PurchaseOrderHeader]
    CHECK CONSTRAINT [FK_PurchaseOrderHeader_ShipMethod_ShipMethodID]

GO
EXEC sp_addextendedproperty N'MS_Description', N'Foreign key constraint referencing ShipMethod.ShipMethodID.', 'SCHEMA', N'Purchasing', 'TABLE', N'PurchaseOrderHeader', 'CONSTRAINT', N'FK_PurchaseOrderHeader_ShipMethod_ShipMethodID'
GO
ALTER TABLE [Purchasing].[PurchaseOrderHeader]
    WITH CHECK
    ADD CONSTRAINT [FK_PurchaseOrderHeader_Vendor_VendorID]
    FOREIGN KEY ([VendorID]) REFERENCES [Purchasing].[Vendor] ([BusinessEntityID])
ALTER TABLE [Purchasing].[PurchaseOrderHeader]
    CHECK CONSTRAINT [FK_PurchaseOrderHeader_Vendor_VendorID]

GO
EXEC sp_addextendedproperty N'MS_Description', N'Foreign key constraint referencing Vendor.VendorID.', 'SCHEMA', N'Purchasing', 'TABLE', N'PurchaseOrderHeader', 'CONSTRAINT', N'FK_PurchaseOrderHeader_Vendor_VendorID'
GO
CREATE NONCLUSTERED INDEX [IX_PurchaseOrderHeader_EmployeeID]
    ON [Purchasing].[PurchaseOrderHeader] ([EmployeeID])
    ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Nonclustered index.', 'SCHEMA', N'Purchasing', 'TABLE', N'PurchaseOrderHeader', 'INDEX', N'IX_PurchaseOrderHeader_EmployeeID'
GO
CREATE NONCLUSTERED INDEX [IX_PurchaseOrderHeader_VendorID]
    ON [Purchasing].[PurchaseOrderHeader] ([VendorID])
    ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Nonclustered index.', 'SCHEMA', N'Purchasing', 'TABLE', N'PurchaseOrderHeader', 'INDEX', N'IX_PurchaseOrderHeader_VendorID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Employee who created the purchase order. Foreign key to Employee.BusinessEntityID.', 'SCHEMA', N'Purchasing', 'TABLE', N'PurchaseOrderHeader', 'COLUMN', N'EmployeeID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Shipping cost.', 'SCHEMA', N'Purchasing', 'TABLE', N'PurchaseOrderHeader', 'COLUMN', N'Freight'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Date and time the record was last updated.', 'SCHEMA', N'Purchasing', 'TABLE', N'PurchaseOrderHeader', 'COLUMN', N'ModifiedDate'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Purchase order creation date.', 'SCHEMA', N'Purchasing', 'TABLE', N'PurchaseOrderHeader', 'COLUMN', N'OrderDate'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Primary key.', 'SCHEMA', N'Purchasing', 'TABLE', N'PurchaseOrderHeader', 'COLUMN', N'PurchaseOrderID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Incremental number to track changes to the purchase order over time.', 'SCHEMA', N'Purchasing', 'TABLE', N'PurchaseOrderHeader', 'COLUMN', N'RevisionNumber'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Estimated shipment date from the vendor.', 'SCHEMA', N'Purchasing', 'TABLE', N'PurchaseOrderHeader', 'COLUMN', N'ShipDate'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Shipping method. Foreign key to ShipMethod.ShipMethodID.', 'SCHEMA', N'Purchasing', 'TABLE', N'PurchaseOrderHeader', 'COLUMN', N'ShipMethodID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Order current status. 1 = Pending; 2 = Approved; 3 = Rejected; 4 = Complete', 'SCHEMA', N'Purchasing', 'TABLE', N'PurchaseOrderHeader', 'COLUMN', N'Status'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Purchase order subtotal. Computed as SUM(PurchaseOrderDetail.LineTotal)for the appropriate PurchaseOrderID.', 'SCHEMA', N'Purchasing', 'TABLE', N'PurchaseOrderHeader', 'COLUMN', N'SubTotal'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Tax amount.', 'SCHEMA', N'Purchasing', 'TABLE', N'PurchaseOrderHeader', 'COLUMN', N'TaxAmt'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Total due to vendor. Computed as Subtotal + TaxAmt + Freight.', 'SCHEMA', N'Purchasing', 'TABLE', N'PurchaseOrderHeader', 'COLUMN', N'TotalDue'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Vendor with whom the purchase order is placed. Foreign key to Vendor.BusinessEntityID.', 'SCHEMA', N'Purchasing', 'TABLE', N'PurchaseOrderHeader', 'COLUMN', N'VendorID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'General purchase order information. See PurchaseOrderDetail.', 'SCHEMA', N'Purchasing', 'TABLE', N'PurchaseOrderHeader', NULL, NULL
GO

Collapse image See also


List of tables