Purchasing.PurchaseOrderHeader

Columns

• //

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

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

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

  //

  CONSTRAINT: Check constraint [Status] BETWEEN (1) AND (4)

  ([Status]>=(1) AND [Status]<=(4))
• //

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

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

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

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

  ${escapify(column.description)}
  ShipDate
  [datetime] 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)}
  ModifiedDate
  [datetime] NOT NULL DEFAULT (getdate())

Indexes

• //

  Clustered index created by a primary key constraint.
  PK_PurchaseOrderHeader_PurchaseOrderID
  UNIQUE CLUSTERED
  PurchaseOrderID
• //

  Nonclustered index.
  IX_PurchaseOrderHeader_VendorID
  NONCLUSTERED
  VendorID
• //

  Nonclustered index.
  IX_PurchaseOrderHeader_EmployeeID
  NONCLUSTERED
  EmployeeID

Foreign Keys

• //

  Foreign key constraint referencing Employee.EmployeeID.
  FK_PurchaseOrderHeader_Employee_EmployeeID
  HumanResources.Employee
  EmployeeID ⥱ BusinessEntityID
• //

  Foreign key constraint referencing ShipMethod.ShipMethodID.
  FK_PurchaseOrderHeader_ShipMethod_ShipMethodID
  Purchasing.ShipMethod
  ShipMethodID ⥱ ShipMethodID
• //

  Foreign key constraint referencing Vendor.VendorID.
  FK_PurchaseOrderHeader_Vendor_VendorID
  Purchasing.Vendor
  VendorID ⥱ BusinessEntityID

Check Constraints

• //

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

Sample Data