Purchasing.PurchaseOrderHeader Table

Information

Name	PurchaseOrderHeader
Schema	Purchasing
Row Count	0
Data Size
Index Size
Reserved Size
Unused Size
Created	29.3.2010. 21:58:18
Modified	29.3.2010. 21:58:56

Extended Properties

Name	Type	Property Name	Value
PurchaseOrderHeader	TABLE	MS_Description	General purchase order information. See PurchaseOrderDetail.

Columns

Name	Data Type	References	Default	Compute Expression
PurchaseOrderID	int
RevisionNumber	tinyint		((0))
Status	tinyint		((1))
EmployeeID	int	HumanResources.Employee.EmployeeID
VendorID	int	Purchasing.Vendor.VendorID
ShipMethodID	int	Purchasing.ShipMethod.ShipMethodID
OrderDate	datetime		(getdate())
ShipDate	datetime
SubTotal	money		((0.00))
TaxAmt	money		((0.00))
Freight	money		((0.00))
TotalDue	money			(isnull(([SubTotal]+[TaxAmt])+[Freight],(0)))
ModifiedDate	datetime		(getdate())

Indexes

Name	Type	Columns
PK_PurchaseOrderHeader_PurchaseOrderID	Clustered	PurchaseOrderID
IX_PurchaseOrderHeader_VendorID	NonClustered	VendorID
IX_PurchaseOrderHeader_EmployeeID	NonClustered	EmployeeID

Check Constraints

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

Foreign Key Constraints

Name	Type	Referenced Table
FK_PurchaseOrderHeader_Employee_EmployeeID	Foreign key	HumanResources.Employee
FK_PurchaseOrderHeader_ShipMethod_ShipMethodID	Foreign key	Purchasing.ShipMethod
FK_PurchaseOrderHeader_Vendor_VendorID	Foreign key	Purchasing.Vendor

Triggers

Name	Activates on	Instead Of	For Replication	Enabled	Created	Modified
uPurchaseOrderHeader	UPDATE				29.3.2010. 21:58:56	29.3.2010. 21:58:56

SQL Script

CREATE TABLE [Purchasing].[PurchaseOrderHeader] (
    [PurchaseOrderID] int NOT NULL IDENTITY,
    [RevisionNumber] tinyint NOT NULL DEFAULT ((0)),
    [Status] tinyint NOT NULL DEFAULT ((1)),
    [EmployeeID] int NOT NULL,
    [VendorID] int NOT NULL,
    [ShipMethodID] int NOT NULL,
    [OrderDate] datetime NOT NULL DEFAULT (getdate()),
    [ShipDate] datetime NULL,
    [SubTotal] money NOT NULL DEFAULT ((0.00)),
    [TaxAmt] money NOT NULL DEFAULT ((0.00)),
    [Freight] money NOT NULL DEFAULT ((0.00)),
    [TotalDue] money NOT NULL,
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);
CREATE INDEX [IX_PurchaseOrderHeader_VendorID] on [Purchasing].[PurchaseOrderHeader]([VendorID]);
CREATE INDEX [IX_PurchaseOrderHeader_EmployeeID] on [Purchasing].[PurchaseOrderHeader]([EmployeeID]);