Sales.SalesOrderHeader

Columns

• //

  ${escapify(column.description)}
  SalesOrderID
  [int] IDENTITY (1,1) NOT NULL
• //

  ${escapify(column.description)}
  RevisionNumber
  [tinyint] NOT NULL DEFAULT ((0))
• //

  ${escapify(column.description)}
  OrderDate
  [datetime] NOT NULL DEFAULT (getdate())
• //

  ${escapify(column.description)}
  DueDate
  [datetime] NOT NULL
• //

  ${escapify(column.description)}
  ShipDate
  [datetime] NULL
• //

  ${escapify(column.description)}
  Status
  [tinyint] NOT NULL DEFAULT ((1))

  //

  CONSTRAINT: Check constraint [Status] BETWEEN (0) AND (8)

  ([Status]>=(0) AND [Status]<=(8))
• //

  ${escapify(column.description)}
  OnlineOrderFlag
  [Flag] NOT NULL DEFAULT ((1))

  //

  USER-DEFINED DATA TYPE

  [bit] NOT NULL
• //

  ${escapify(column.description)}
  SalesOrderNumber
  [nvarchar](25) NOT NULL
• //

  ${escapify(column.description)}
  PurchaseOrderNumber
  [OrderNumber] NULL

  //

  USER-DEFINED DATA TYPE

  [nvarchar](25) NULL
• //

  ${escapify(column.description)}
  AccountNumber
  [AccountNumber] NULL

  //

  USER-DEFINED DATA TYPE

  [nvarchar](15) NULL
• //

  ${escapify(column.description)}
  CustomerID
  [int] NOT NULL
• //

  ${escapify(column.description)}
  SalesPersonID
  [int] NULL
• //

  ${escapify(column.description)}
  TerritoryID
  [int] NULL
• //

  ${escapify(column.description)}
  BillToAddressID
  [int] NOT NULL
• //

  ${escapify(column.description)}
  ShipToAddressID
  [int] NOT NULL
• //

  ${escapify(column.description)}
  ShipMethodID
  [int] NOT NULL
• //

  ${escapify(column.description)}
  CreditCardID
  [int] NULL
• //

  ${escapify(column.description)}
  CreditCardApprovalCode
  [varchar](15) NULL
• //

  ${escapify(column.description)}
  CurrencyRateID
  [int] NULL
• //

  ${escapify(column.description)}
  SubTotal
  [money] NOT NULL DEFAULT ((0.00))

  //

  CONSTRAINT: Check constraint [SubTotal] >= (0.00)

  ([SubTotal]>=(0.00))
• //

  ${escapify(column.description)}
  TaxAmt
  [money] NOT NULL DEFAULT ((0.00))

  //

  CONSTRAINT: Check constraint [TaxAmt] >= (0.00)

  ([TaxAmt]>=(0.00))
• //

  ${escapify(column.description)}
  Freight
  [money] NOT NULL DEFAULT ((0.00))

  //

  CONSTRAINT: Check constraint [Freight] >= (0.00)

  ([Freight]>=(0.00))
• //

  ${escapify(column.description)}
  TotalDue
  [money] NOT NULL
• //

  ${escapify(column.description)}
  Comment
  [nvarchar](128) NULL
• //

  ${escapify(column.description)}
  rowguid
  [uniqueidentifier] NOT NULL DEFAULT (newid())
• //

  ${escapify(column.description)}
  ModifiedDate
  [datetime] NOT NULL DEFAULT (getdate())

Indexes

• //

  Clustered index created by a primary key constraint.
  PK_SalesOrderHeader_SalesOrderID
  UNIQUE CLUSTERED
  SalesOrderID
• //

  Unique nonclustered index. Used to support replication samples.
  AK_SalesOrderHeader_rowguid
  UNIQUE NONCLUSTERED
  rowguid
• //

  Unique nonclustered index.
  AK_SalesOrderHeader_SalesOrderNumber
  UNIQUE NONCLUSTERED
  SalesOrderNumber
• //

  Nonclustered index.
  IX_SalesOrderHeader_CustomerID
  NONCLUSTERED
  CustomerID
• //

  Nonclustered index.
  IX_SalesOrderHeader_SalesPersonID
  NONCLUSTERED
  SalesPersonID

Foreign Keys

• //

  Foreign key constraint referencing Address.AddressID.
  FK_SalesOrderHeader_Address_BillToAddressID
  Person.Address
  BillToAddressID ⥱ AddressID
• //

  Foreign key constraint referencing Address.AddressID.
  FK_SalesOrderHeader_Address_ShipToAddressID
  Person.Address
  ShipToAddressID ⥱ AddressID
• //

  Foreign key constraint referencing CreditCard.CreditCardID.
  FK_SalesOrderHeader_CreditCard_CreditCardID
  Sales.CreditCard
  CreditCardID ⥱ CreditCardID
• //

  Foreign key constraint referencing CurrencyRate.CurrencyRateID.
  FK_SalesOrderHeader_CurrencyRate_CurrencyRateID
  Sales.CurrencyRate
  CurrencyRateID ⥱ CurrencyRateID
• //

  Foreign key constraint referencing Customer.CustomerID.
  FK_SalesOrderHeader_Customer_CustomerID
  Sales.Customer
  CustomerID ⥱ CustomerID
• //

  Foreign key constraint referencing SalesPerson.SalesPersonID.
  FK_SalesOrderHeader_SalesPerson_SalesPersonID
  Sales.SalesPerson
  SalesPersonID ⥱ BusinessEntityID
• //

  Foreign key constraint referencing SalesTerritory.TerritoryID.
  FK_SalesOrderHeader_SalesTerritory_TerritoryID
  Sales.SalesTerritory
  TerritoryID ⥱ TerritoryID
• //

  Foreign key constraint referencing ShipMethod.ShipMethodID.
  FK_SalesOrderHeader_ShipMethod_ShipMethodID
  Purchasing.ShipMethod
  ShipMethodID ⥱ ShipMethodID

Check Constraints

• //

  Check constraint [DueDate] >= [OrderDate]
  CK_SalesOrderHeader_DueDate
  ([DueDate]>=[OrderDate])
• //

  Check constraint [ShipDate] >= [OrderDate] OR [ShipDate] IS NULL
  CK_SalesOrderHeader_ShipDate
  ([ShipDate]>=[OrderDate] OR [ShipDate] IS NULL)

Sample Data