Table: [AdventureWorks2016CTP3].[Sales].[SalesOrderHeader]

CollapseAll image

Collapse image Table properties


Name  Value 
 Schema  [Sales]
 Owner  [dbo]
 Table is replicated   
 Creation date  23.10.2015
 ID  1586104691
 Located on  PRIMARY
 Data size KB  5536 KB
 Index size KB  2872 KB
 Rows  31465
 ChangeTrackingEnabled   
 FileStreamFileGroup   
 FileStreamPartitionScheme   
 LockEscalation  TABLE
 TrackColumnsUpdatedEnabled   
 Table is filetable   
 Filetable directory   
 Filetable collate   
 Filetable primary key  [PK_SalesOrderHeader_SalesOrderID]
 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   SalesOrderID     int 4        
      RevisionNumber     tinyint 1   ((0))    
      OrderDate     datetime 8   (getdate())    
      DueDate     datetime 8        
      ShipDate     datetime 8      
      Status     tinyint 1   ((1))    
      OnlineOrderFlag     [dbo].[Flag] 1   ((1))    
      SalesOrderNumber   True nvarchar 25         (isnull(N'SO'+CONVERT([nvarchar](23),[SalesOrderID]),N'*** ERROR ***'))
      PurchaseOrderNumber     [dbo].[OrderNumber] 25      
      AccountNumber     [dbo].[AccountNumber] 15      
    Foreign key CustomerID     int 4        
    Foreign key SalesPersonID     int 4      
    Foreign key TerritoryID     int 4      
    Foreign key BillToAddressID     int 4        
    Foreign key ShipToAddressID     int 4        
    Foreign key ShipMethodID     int 4        
    Foreign key CreditCardID     int 4      
      CreditCardApprovalCode     varchar 15      
    Foreign key CurrencyRateID     int 4      
      SubTotal     money 8   ((0.00))    
      TaxAmt     money 8   ((0.00))    
      Freight     money 8   ((0.00))    
      TotalDue   True money 8         (isnull(([SubTotal]+[TaxAmt])+[Freight],(0)))
      Comment     nvarchar 128      
      rowguid     uniqueidentifier 16   (newid())  
      ModifiedDate     datetime 8   (getdate())    
Total: 26 column(s)

Collapse image Indexes


Index  Description  Primary  Unique  Size KB 
[PK_SalesOrderHeader_SalesOrderID] SalesOrderID   8408 0
[AK_SalesOrderHeader_rowguid] rowguid     832 0
[AK_SalesOrderHeader_SalesOrderNumber] SalesOrderNumber     888 0
[IX_SalesOrderHeader_CustomerID] CustomerID       456 0
[IX_SalesOrderHeader_SalesPersonID] SalesPersonID       456 0
Total: 5 Index/indexes

Collapse image Columnstore indexes


No columnstore indexes exist

Collapse image Check constraints


Name  Expression 
CK_SalesOrderHeader_DueDate ([DueDate]>=[OrderDate])
CK_SalesOrderHeader_Freight ([Freight]>=(0.00))
CK_SalesOrderHeader_ShipDate ([ShipDate]>=[OrderDate] OR [ShipDate] IS NULL)
CK_SalesOrderHeader_Status ([Status]>=(0) AND [Status]<=(8))
CK_SalesOrderHeader_SubTotal ([SubTotal]>=(0.00))
CK_SalesOrderHeader_TaxAmt ([TaxAmt]>=(0.00))

Collapse image Identity column


  Name  Seed  Increment  Not for replication 
 SalesOrderID   1   1 

Collapse image Referencing tables


Table  Foreign key  Primary key or unique constraint 
[Sales].[SalesOrderDetail] FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID PK_SalesOrderHeader_SalesOrderID
[Sales].[SalesOrderHeaderSalesReason] FK_SalesOrderHeaderSalesReason_SalesOrderHeader_SalesOrderID PK_SalesOrderHeader_SalesOrderID
Total: 2 table(s)

Collapse image Referenced tables


Table  Primary key or unique constraint  Foreign key 
[Person].[Address] PK_Address_AddressID FK_SalesOrderHeader_Address_BillToAddressID
[Person].[Address] PK_Address_AddressID FK_SalesOrderHeader_Address_ShipToAddressID
[Sales].[CreditCard] PK_CreditCard_CreditCardID FK_SalesOrderHeader_CreditCard_CreditCardID
[Sales].[CurrencyRate] PK_CurrencyRate_CurrencyRateID FK_SalesOrderHeader_CurrencyRate_CurrencyRateID
[Sales].[Customer] PK_Customer_CustomerID FK_SalesOrderHeader_Customer_CustomerID
[Sales].[SalesPerson] PK_SalesPerson_BusinessEntityID FK_SalesOrderHeader_SalesPerson_SalesPersonID
[Sales].[SalesTerritory] PK_SalesTerritory_TerritoryID FK_SalesOrderHeader_SalesTerritory_TerritoryID
[Purchasing].[ShipMethod] PK_ShipMethod_ShipMethodID FK_SalesOrderHeader_ShipMethod_ShipMethodID
Total: 8 table(s)

Collapse image Triggers


Name  Schema  Description  Instead 
of 
For 
insert 
For 
update 
For 
delete 
Table/view 
[Sales].[uSalesOrderHeader] [Sales]       For Update   [Sales].[SalesOrderHeader]
Total: 1 triggers(s)

Collapse image Objects that depend on [Sales].[SalesOrderHeader]


Object name Object type Dep level
[Demo].[usp_DemoReset] Procedure 1
[Sales].[SalesOrderDetail] Table 1
[Sales].[SalesOrderHeaderSalesReason] Table 1
[Sales].[iduSalesOrderDetail] Trigger 1
[Sales].[uSalesOrderHeader] Trigger 1
[Sales].[vSalesPersonSalesByFiscalYears] View 1
Total 6 object(s)

Collapse image Objects that [Sales].[SalesOrderHeader] depends on


Object name Object type Dep level
[Sales] Schema 1
[Person].[Address] Table 1
[Sales].[CreditCard] Table 1
[Sales].[CurrencyRate] Table 1
[Sales].[Customer] Table 1
[Sales].[SalesPerson] Table 1
[Sales].[SalesTerritory] Table 1
[Purchasing].[ShipMethod] Table 1
[dbo].[AccountNumber] Datatype 1
[dbo].[Flag] Datatype 1
[dbo].[OrderNumber] Datatype 1
Total 11 object(s)

Collapse image Extended properties


Name  Value 
MS_Description General sales order information.

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 [Sales].[SalesOrderHeader] (
        [SalesOrderID]               [int] IDENTITY(1, 1) NOT FOR REPLICATION NOT NULL,
        [RevisionNumber]             [tinyint] NOT NULL,
        [OrderDate]                  [datetime] NOT NULL,
        [DueDate]                    [datetime] NOT NULL,
        [ShipDate]                   [datetime] NULL,
        [Status]                     [tinyint] NOT NULL,
        [OnlineOrderFlag]            [dbo].[Flag] NOT NULL,
        [SalesOrderNumber]           AS (isnull(N'SO'+CONVERT([nvarchar](23),[SalesOrderID]),N'*** ERROR ***')),
        [PurchaseOrderNumber]        [dbo].[OrderNumber] NULL,
        [AccountNumber]              [dbo].[AccountNumber] NULL,
        [CustomerID]                 [int] NOT NULL,
        [SalesPersonID]              [int] NULL,
        [TerritoryID]                [int] NULL,
        [BillToAddressID]            [int] NOT NULL,
        [ShipToAddressID]            [int] NOT NULL,
        [ShipMethodID]               [int] NOT NULL,
        [CreditCardID]               [int] NULL,
        [CreditCardApprovalCode]     [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        [CurrencyRateID]             [int] NULL,
        [SubTotal]                   [money] NOT NULL,
        [TaxAmt]                     [money] NOT NULL,
        [Freight]                    [money] NOT NULL,
        [TotalDue]                   AS (isnull(([SubTotal]+[TaxAmt])+[Freight],(0))),
        [Comment]                    [nvarchar](128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        [rowguid]                    [uniqueidentifier] NOT NULL ROWGUIDCOL,
        [ModifiedDate]               [datetime] NOT NULL,
        CONSTRAINT [PK_SalesOrderHeader_SalesOrderID]
        PRIMARY KEY
        CLUSTERED
        ([SalesOrderID])
    ON [PRIMARY]
) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Primary key (clustered) constraint', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'CONSTRAINT', N'PK_SalesOrderHeader_SalesOrderID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Clustered index created by a primary key constraint.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'INDEX', N'PK_SalesOrderHeader_SalesOrderID'
GO
ALTER TABLE [Sales].[SalesOrderHeader]
    ADD
    CONSTRAINT [CK_SalesOrderHeader_DueDate]
    CHECK
    ([DueDate]>=[OrderDate])
GO
EXEC sp_addextendedproperty N'MS_Description', N'Check constraint [DueDate] >= [OrderDate]', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'CONSTRAINT', N'CK_SalesOrderHeader_DueDate'
GO
ALTER TABLE [Sales].[SalesOrderHeader]
CHECK CONSTRAINT [CK_SalesOrderHeader_DueDate]
GO
ALTER TABLE [Sales].[SalesOrderHeader]
    ADD
    CONSTRAINT [CK_SalesOrderHeader_Freight]
    CHECK
    ([Freight]>=(0.00))
GO
EXEC sp_addextendedproperty N'MS_Description', N'Check constraint [Freight] >= (0.00)', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'CONSTRAINT', N'CK_SalesOrderHeader_Freight'
GO
ALTER TABLE [Sales].[SalesOrderHeader]
CHECK CONSTRAINT [CK_SalesOrderHeader_Freight]
GO
ALTER TABLE [Sales].[SalesOrderHeader]
    ADD
    CONSTRAINT [CK_SalesOrderHeader_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'Sales', 'TABLE', N'SalesOrderHeader', 'CONSTRAINT', N'CK_SalesOrderHeader_ShipDate'
GO
ALTER TABLE [Sales].[SalesOrderHeader]
CHECK CONSTRAINT [CK_SalesOrderHeader_ShipDate]
GO
ALTER TABLE [Sales].[SalesOrderHeader]
    ADD
    CONSTRAINT [CK_SalesOrderHeader_Status]
    CHECK
    ([Status]>=(0) AND [Status]<=(8))
GO
EXEC sp_addextendedproperty N'MS_Description', N'Check constraint [Status] BETWEEN (0) AND (8)', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'CONSTRAINT', N'CK_SalesOrderHeader_Status'
GO
ALTER TABLE [Sales].[SalesOrderHeader]
CHECK CONSTRAINT [CK_SalesOrderHeader_Status]
GO
ALTER TABLE [Sales].[SalesOrderHeader]
    ADD
    CONSTRAINT [CK_SalesOrderHeader_SubTotal]
    CHECK
    ([SubTotal]>=(0.00))
GO
EXEC sp_addextendedproperty N'MS_Description', N'Check constraint [SubTotal] >= (0.00)', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'CONSTRAINT', N'CK_SalesOrderHeader_SubTotal'
GO
ALTER TABLE [Sales].[SalesOrderHeader]
CHECK CONSTRAINT [CK_SalesOrderHeader_SubTotal]
GO
ALTER TABLE [Sales].[SalesOrderHeader]
    ADD
    CONSTRAINT [CK_SalesOrderHeader_TaxAmt]
    CHECK
    ([TaxAmt]>=(0.00))
GO
EXEC sp_addextendedproperty N'MS_Description', N'Check constraint [TaxAmt] >= (0.00)', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'CONSTRAINT', N'CK_SalesOrderHeader_TaxAmt'
GO
ALTER TABLE [Sales].[SalesOrderHeader]
CHECK CONSTRAINT [CK_SalesOrderHeader_TaxAmt]
GO
ALTER TABLE [Sales].[SalesOrderHeader]
    ADD
    CONSTRAINT [DF_SalesOrderHeader_Freight]
    DEFAULT ((0.00)) FOR [Freight]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Default constraint value of 0.0', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'CONSTRAINT', N'DF_SalesOrderHeader_Freight'
GO
ALTER TABLE [Sales].[SalesOrderHeader]
    ADD
    CONSTRAINT [DF_SalesOrderHeader_ModifiedDate]
    DEFAULT (getdate()) FOR [ModifiedDate]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Default constraint value of GETDATE()', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'CONSTRAINT', N'DF_SalesOrderHeader_ModifiedDate'
GO
ALTER TABLE [Sales].[SalesOrderHeader]
    ADD
    CONSTRAINT [DF_SalesOrderHeader_OnlineOrderFlag]
    DEFAULT ((1)) FOR [OnlineOrderFlag]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Default constraint value of 1 (TRUE)', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'CONSTRAINT', N'DF_SalesOrderHeader_OnlineOrderFlag'
GO
ALTER TABLE [Sales].[SalesOrderHeader]
    ADD
    CONSTRAINT [DF_SalesOrderHeader_OrderDate]
    DEFAULT (getdate()) FOR [OrderDate]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Default constraint value of GETDATE()', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'CONSTRAINT', N'DF_SalesOrderHeader_OrderDate'
GO
ALTER TABLE [Sales].[SalesOrderHeader]
    ADD
    CONSTRAINT [DF_SalesOrderHeader_RevisionNumber]
    DEFAULT ((0)) FOR [RevisionNumber]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Default constraint value of 0', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'CONSTRAINT', N'DF_SalesOrderHeader_RevisionNumber'
GO
ALTER TABLE [Sales].[SalesOrderHeader]
    ADD
    CONSTRAINT [DF_SalesOrderHeader_rowguid]
    DEFAULT (newid()) FOR [rowguid]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Default constraint value of NEWID()', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'CONSTRAINT', N'DF_SalesOrderHeader_rowguid'
GO
ALTER TABLE [Sales].[SalesOrderHeader]
    ADD
    CONSTRAINT [DF_SalesOrderHeader_Status]
    DEFAULT ((1)) FOR [Status]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Default constraint value of 1', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'CONSTRAINT', N'DF_SalesOrderHeader_Status'
GO
ALTER TABLE [Sales].[SalesOrderHeader]
    ADD
    CONSTRAINT [DF_SalesOrderHeader_SubTotal]
    DEFAULT ((0.00)) FOR [SubTotal]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Default constraint value of 0.0', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'CONSTRAINT', N'DF_SalesOrderHeader_SubTotal'
GO
ALTER TABLE [Sales].[SalesOrderHeader]
    ADD
    CONSTRAINT [DF_SalesOrderHeader_TaxAmt]
    DEFAULT ((0.00)) FOR [TaxAmt]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Default constraint value of 0.0', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'CONSTRAINT', N'DF_SalesOrderHeader_TaxAmt'
GO
ALTER TABLE [Sales].[SalesOrderHeader]
    WITH CHECK
    ADD CONSTRAINT [FK_SalesOrderHeader_Address_BillToAddressID]
    FOREIGN KEY ([BillToAddressID]) REFERENCES [Person].[Address] ([AddressID])
ALTER TABLE [Sales].[SalesOrderHeader]
    CHECK CONSTRAINT [FK_SalesOrderHeader_Address_BillToAddressID]

GO
EXEC sp_addextendedproperty N'MS_Description', N'Foreign key constraint referencing Address.AddressID.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'CONSTRAINT', N'FK_SalesOrderHeader_Address_BillToAddressID'
GO
ALTER TABLE [Sales].[SalesOrderHeader]
    WITH CHECK
    ADD CONSTRAINT [FK_SalesOrderHeader_Address_ShipToAddressID]
    FOREIGN KEY ([ShipToAddressID]) REFERENCES [Person].[Address] ([AddressID])
ALTER TABLE [Sales].[SalesOrderHeader]
    CHECK CONSTRAINT [FK_SalesOrderHeader_Address_ShipToAddressID]

GO
EXEC sp_addextendedproperty N'MS_Description', N'Foreign key constraint referencing Address.AddressID.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'CONSTRAINT', N'FK_SalesOrderHeader_Address_ShipToAddressID'
GO
ALTER TABLE [Sales].[SalesOrderHeader]
    WITH CHECK
    ADD CONSTRAINT [FK_SalesOrderHeader_CreditCard_CreditCardID]
    FOREIGN KEY ([CreditCardID]) REFERENCES [Sales].[CreditCard] ([CreditCardID])
ALTER TABLE [Sales].[SalesOrderHeader]
    CHECK CONSTRAINT [FK_SalesOrderHeader_CreditCard_CreditCardID]

GO
EXEC sp_addextendedproperty N'MS_Description', N'Foreign key constraint referencing CreditCard.CreditCardID.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'CONSTRAINT', N'FK_SalesOrderHeader_CreditCard_CreditCardID'
GO
ALTER TABLE [Sales].[SalesOrderHeader]
    WITH CHECK
    ADD CONSTRAINT [FK_SalesOrderHeader_CurrencyRate_CurrencyRateID]
    FOREIGN KEY ([CurrencyRateID]) REFERENCES [Sales].[CurrencyRate] ([CurrencyRateID])
ALTER TABLE [Sales].[SalesOrderHeader]
    CHECK CONSTRAINT [FK_SalesOrderHeader_CurrencyRate_CurrencyRateID]

GO
EXEC sp_addextendedproperty N'MS_Description', N'Foreign key constraint referencing CurrencyRate.CurrencyRateID.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'CONSTRAINT', N'FK_SalesOrderHeader_CurrencyRate_CurrencyRateID'
GO
ALTER TABLE [Sales].[SalesOrderHeader]
    WITH CHECK
    ADD CONSTRAINT [FK_SalesOrderHeader_Customer_CustomerID]
    FOREIGN KEY ([CustomerID]) REFERENCES [Sales].[Customer] ([CustomerID])
ALTER TABLE [Sales].[SalesOrderHeader]
    CHECK CONSTRAINT [FK_SalesOrderHeader_Customer_CustomerID]

GO
EXEC sp_addextendedproperty N'MS_Description', N'Foreign key constraint referencing Customer.CustomerID.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'CONSTRAINT', N'FK_SalesOrderHeader_Customer_CustomerID'
GO
ALTER TABLE [Sales].[SalesOrderHeader]
    WITH CHECK
    ADD CONSTRAINT [FK_SalesOrderHeader_SalesPerson_SalesPersonID]
    FOREIGN KEY ([SalesPersonID]) REFERENCES [Sales].[SalesPerson] ([BusinessEntityID])
ALTER TABLE [Sales].[SalesOrderHeader]
    CHECK CONSTRAINT [FK_SalesOrderHeader_SalesPerson_SalesPersonID]

GO
EXEC sp_addextendedproperty N'MS_Description', N'Foreign key constraint referencing SalesPerson.SalesPersonID.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'CONSTRAINT', N'FK_SalesOrderHeader_SalesPerson_SalesPersonID'
GO
ALTER TABLE [Sales].[SalesOrderHeader]
    WITH CHECK
    ADD CONSTRAINT [FK_SalesOrderHeader_SalesTerritory_TerritoryID]
    FOREIGN KEY ([TerritoryID]) REFERENCES [Sales].[SalesTerritory] ([TerritoryID])
ALTER TABLE [Sales].[SalesOrderHeader]
    CHECK CONSTRAINT [FK_SalesOrderHeader_SalesTerritory_TerritoryID]

GO
EXEC sp_addextendedproperty N'MS_Description', N'Foreign key constraint referencing SalesTerritory.TerritoryID.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'CONSTRAINT', N'FK_SalesOrderHeader_SalesTerritory_TerritoryID'
GO
ALTER TABLE [Sales].[SalesOrderHeader]
    WITH CHECK
    ADD CONSTRAINT [FK_SalesOrderHeader_ShipMethod_ShipMethodID]
    FOREIGN KEY ([ShipMethodID]) REFERENCES [Purchasing].[ShipMethod] ([ShipMethodID])
ALTER TABLE [Sales].[SalesOrderHeader]
    CHECK CONSTRAINT [FK_SalesOrderHeader_ShipMethod_ShipMethodID]

GO
EXEC sp_addextendedproperty N'MS_Description', N'Foreign key constraint referencing ShipMethod.ShipMethodID.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'CONSTRAINT', N'FK_SalesOrderHeader_ShipMethod_ShipMethodID'
GO
CREATE UNIQUE NONCLUSTERED INDEX [AK_SalesOrderHeader_rowguid]
    ON [Sales].[SalesOrderHeader] ([rowguid])
    ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Unique nonclustered index. Used to support replication samples.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'INDEX', N'AK_SalesOrderHeader_rowguid'
GO
CREATE UNIQUE NONCLUSTERED INDEX [AK_SalesOrderHeader_SalesOrderNumber]
    ON [Sales].[SalesOrderHeader] ([SalesOrderNumber])
    ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Unique nonclustered index.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'INDEX', N'AK_SalesOrderHeader_SalesOrderNumber'
GO
CREATE NONCLUSTERED INDEX [IX_SalesOrderHeader_CustomerID]
    ON [Sales].[SalesOrderHeader] ([CustomerID])
    ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Nonclustered index.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'INDEX', N'IX_SalesOrderHeader_CustomerID'
GO
CREATE NONCLUSTERED INDEX [IX_SalesOrderHeader_SalesPersonID]
    ON [Sales].[SalesOrderHeader] ([SalesPersonID])
    ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Nonclustered index.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'INDEX', N'IX_SalesOrderHeader_SalesPersonID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Financial accounting number reference.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'COLUMN', N'AccountNumber'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Customer billing address. Foreign key to Address.AddressID.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'COLUMN', N'BillToAddressID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Sales representative comments.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'COLUMN', N'Comment'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Approval code provided by the credit card company.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'COLUMN', N'CreditCardApprovalCode'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Credit card identification number. Foreign key to CreditCard.CreditCardID.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'COLUMN', N'CreditCardID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Currency exchange rate used. Foreign key to CurrencyRate.CurrencyRateID.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'COLUMN', N'CurrencyRateID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Customer identification number. Foreign key to Customer.BusinessEntityID.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'COLUMN', N'CustomerID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Date the order is due to the customer.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'COLUMN', N'DueDate'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Shipping cost.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'COLUMN', N'Freight'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Date and time the record was last updated.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'COLUMN', N'ModifiedDate'
GO
EXEC sp_addextendedproperty N'MS_Description', N'0 = Order placed by sales person. 1 = Order placed online by customer.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'COLUMN', N'OnlineOrderFlag'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Dates the sales order was created.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'COLUMN', N'OrderDate'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Customer purchase order number reference. ', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'COLUMN', N'PurchaseOrderNumber'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Incremental number to track changes to the sales order over time.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'COLUMN', N'RevisionNumber'
GO
EXEC sp_addextendedproperty N'MS_Description', N'ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'COLUMN', N'rowguid'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Primary key.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'COLUMN', N'SalesOrderID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Unique sales order identification number.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'COLUMN', N'SalesOrderNumber'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Sales person who created the sales order. Foreign key to SalesPerson.BusinessEntityID.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'COLUMN', N'SalesPersonID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Date the order was shipped to the customer.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'COLUMN', N'ShipDate'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Shipping method. Foreign key to ShipMethod.ShipMethodID.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'COLUMN', N'ShipMethodID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Customer shipping address. Foreign key to Address.AddressID.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'COLUMN', N'ShipToAddressID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Order current status. 1 = In process; 2 = Approved; 3 = Backordered; 4 = Rejected; 5 = Shipped; 6 = Cancelled', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'COLUMN', N'Status'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Sales subtotal. Computed as SUM(SalesOrderDetail.LineTotal)for the appropriate SalesOrderID.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'COLUMN', N'SubTotal'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Tax amount.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'COLUMN', N'TaxAmt'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Territory in which the sale was made. Foreign key to SalesTerritory.SalesTerritoryID.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'COLUMN', N'TerritoryID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Total due from customer. Computed as Subtotal + TaxAmt + Freight.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'COLUMN', N'TotalDue'
GO
EXEC sp_addextendedproperty N'MS_Description', N'General sales order information.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', NULL, NULL
GO

Collapse image See also


List of tables