Purchasing.PurchaseOrderHeader

Table: 'Purchasing.PurchaseOrderHeader'

13 fields. 150 bytes.

General purchase order information. See PurchaseOrderDetail.

Field Name Data Type Size Original Type Default Nullable Description Check

PurchaseOrderID int identity int Not null Primary key.

RevisionNumber tinyint (0) Not null Incremental number to track changes to the purchase order over time.

Status tinyint (1) Not null Order current status. 1 = Pending; 2 = Approved; 3 = Rejected; 4 = Complete ([Status]>=(1) AND [Status]<=(4))

EmployeeID int Not null Employee who created the purchase order. Foreign key to Employee.EmployeeID.

VendorID int Not null Vendor with whom the purchase order is placed. Foreign key to Vendor.VendorID.

ShipMethodID int Not null Shipping method. Foreign key to ShipMethod.ShipMethodID.

OrderDate datetime getdate() Not null Purchase order creation date.

ShipDate datetime Null Estimated shipment date from the vendor.

SubTotal money 19,4 decimal(19,4) (0.00) Not null Purchase order subtotal. Computed as SUM(PurchaseOrderDetail.LineTotal)for the appropriate PurchaseOrderID. ([SubTotal]>=(0.00))

TaxAmt money 19,4 decimal(19,4) (0.00) Not null Tax amount. ([TaxAmt]>=(0.00))

Freight money 19,4 decimal(19,4) (0.00) Not null Shipping cost. ([Freight]>=(0.00))

TotalDue money 19,4 decimal(19,4) Not null Total due to vendor. Computed as Subtotal + TaxAmt + Freight.

ModifiedDate datetime getdate() Not null Date and time the record was last updated.

Field Name	Data Type	Size	Original Type	Default	Nullable	Description	Check
PurchaseOrderID	int identity		int		Not null	Primary key.
RevisionNumber	tinyint			(0)	Not null	Incremental number to track changes to the purchase order over time.
Status	tinyint			(1)	Not null	Order current status. 1 = Pending; 2 = Approved; 3 = Rejected; 4 = Complete	([Status]>=(1) AND [Status]<=(4))
EmployeeID	int				Not null	Employee who created the purchase order. Foreign key to Employee.EmployeeID.
VendorID	int				Not null	Vendor with whom the purchase order is placed. Foreign key to Vendor.VendorID.
ShipMethodID	int				Not null	Shipping method. Foreign key to ShipMethod.ShipMethodID.
OrderDate	datetime			getdate()	Not null	Purchase order creation date.
ShipDate	datetime				Null	Estimated shipment date from the vendor.
SubTotal	money	19,4	decimal(19,4)	(0.00)	Not null	Purchase order subtotal. Computed as SUM(PurchaseOrderDetail.LineTotal)for the appropriate PurchaseOrderID.	([SubTotal]>=(0.00))
TaxAmt	money	19,4	decimal(19,4)	(0.00)	Not null	Tax amount.	([TaxAmt]>=(0.00))
Freight	money	19,4	decimal(19,4)	(0.00)	Not null	Shipping cost.	([Freight]>=(0.00))
TotalDue	money	19,4	decimal(19,4)		Not null	Total due to vendor. Computed as Subtotal + TaxAmt + Freight.
ModifiedDate	datetime			getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'Purchasing.PurchaseOrderHeader'

Primary Key Name Field Name

PK_PurchaseOrderHeader_PurchaseOrderID PurchaseOrderID

Primary Key Name	Field Name
PK_PurchaseOrderHeader_PurchaseOrderID	PurchaseOrderID

Foreign keys for table 'Purchasing.PurchaseOrderHeader', 3 items

Foreign Primary Key Name

PurchaseOrderHeader.EmployeeID Employee.EmployeeID FK_PurchaseOrderHeader_Employee_EmployeeID

PurchaseOrderHeader.ShipMethodID ShipMethod.ShipMethodID FK_PurchaseOrderHeader_ShipMethod_ShipMethodID

PurchaseOrderHeader.VendorID Vendor.VendorID FK_PurchaseOrderHeader_Vendor_VendorID

Foreign	Primary	Key Name
PurchaseOrderHeader.EmployeeID	Employee.EmployeeID	FK_PurchaseOrderHeader_Employee_EmployeeID
PurchaseOrderHeader.ShipMethodID	ShipMethod.ShipMethodID	FK_PurchaseOrderHeader_ShipMethod_ShipMethodID
PurchaseOrderHeader.VendorID	Vendor.VendorID	FK_PurchaseOrderHeader_Vendor_VendorID

Indexes for table 'Purchasing.PurchaseOrderHeader', 3 items

Index Name Description Clustered Unique Fields

PK_PurchaseOrderHeader_PurchaseOrderID Clustered index created by a primary key constraint. Yes Yes PurchaseOrderID

IX_PurchaseOrderHeader_EmployeeID Nonclustered index. No No EmployeeID

IX_PurchaseOrderHeader_VendorID Nonclustered index. No No VendorID

Index Name	Description	Clustered	Unique	Fields
PK_PurchaseOrderHeader_PurchaseOrderID	Clustered index created by a primary key constraint.	Yes	Yes	PurchaseOrderID
IX_PurchaseOrderHeader_EmployeeID	Nonclustered index.	No	No	EmployeeID
IX_PurchaseOrderHeader_VendorID	Nonclustered index.	No	No	VendorID

Triggers for table 'Purchasing.PurchaseOrderHeader', 1 item

Name Description Type Enabled

uPurchaseOrderHeader AFTER UPDATE trigger that updates the RevisionNumber and ModifiedDate columns in the PurchaseOrderHeader table. after Update Yes

Name	Description	Type	Enabled
uPurchaseOrderHeader	AFTER UPDATE trigger that updates the RevisionNumber and ModifiedDate columns in the PurchaseOrderHeader table.	after Update	Yes

Dependencies for table 'Purchasing.PurchaseOrderHeader', 3 items

Object Name Type Field Name

Purchasing.PurchaseOrderHeader user table SubTotal

Purchasing.PurchaseOrderHeader user table TaxAmt

Purchasing.PurchaseOrderHeader user table Freight

Object Name	Type	Field Name
Purchasing.PurchaseOrderHeader	user table	SubTotal
Purchasing.PurchaseOrderHeader	user table	TaxAmt
Purchasing.PurchaseOrderHeader	user table	Freight