Purchasing.PurchaseOrderHeader (table)

wikibot

Table

Purchasing.PurchaseOrderHeader

Column	Data Type	Nullable	Default	PK	Index
PurchaseOrderID	int	not null		PK_PurchaseOrderHeader_PurchaseOrderID
RevisionNumber	tinyint	not null	((0))
Status	tinyint	not null	((1))
EmployeeID	int	not null			IX_PurchaseOrderHeader_EmployeeID
VendorID	int	not null			IX_PurchaseOrderHeader_VendorID
ShipMethodID	int	not null
OrderDate	datetime	not null	(getdate())
ShipDate	datetime	null
SubTotal	money	not null	((0.00))
TaxAmt	money	not null	((0.00))
Freight	money	not null	((0.00))
TotalDue
ModifiedDate	datetime	not null	(getdate())

Relation	Column	Referenced Column
HumanResources.Employee	EmployeeID	EmployeeID
Purchasing.ShipMethod	ShipMethodID	ShipMethodID
Purchasing.Vendor	VendorID	VendorID

Detail Table	Column	Referencing Column
Purchasing.PurchaseOrderDetail	PurchaseOrderID	PurchaseOrderID

Triggers	Type
uPurchaseOrderHeader	ON UPDATE