Sales.SalesOrderHeader (table)

wikibot

Table

Sales.SalesOrderHeader

Column	Data Type	Nullable	Default	PK	Index
SalesOrderID	int	not null		PK_SalesOrderHeader_SalesOrderID
RevisionNumber	tinyint	not null	((0))
OrderDate	datetime	not null	(getdate())
DueDate	datetime	not null
ShipDate	datetime	null
Status	tinyint	not null	((1))
OnlineOrderFlag	dbo.Flag	not null	((1))
SalesOrderNumber					AK_SalesOrderHeader_SalesOrderNumber
PurchaseOrderNumber	dbo.OrderNumber	null
AccountNumber	dbo.AccountNumber	null
CustomerID	int	not null			IX_SalesOrderHeader_CustomerID
ContactID	int	not null
SalesPersonID	int	null			IX_SalesOrderHeader_SalesPersonID
TerritoryID	int	null
BillToAddressID	int	not null
ShipToAddressID	int	not null
ShipMethodID	int	not null
CreditCardID	int	null
CreditCardApprovalCode	varchar(15)	null
CurrencyRateID	int	null
SubTotal	money	not null	((0.00))
TaxAmt	money	not null	((0.00))
Freight	money	not null	((0.00))
TotalDue
Comment	nvarchar(128)	null
rowguid	uniqueidentifier	not null	(newid())		AK_SalesOrderHeader_rowguid
ModifiedDate	datetime	not null	(getdate())

Relation	Column	Referenced Column
Person.Address	BillToAddressID	AddressID
Person.Address	ShipToAddressID	AddressID
Person.Contact	ContactID	ContactID
Sales.CreditCard	CreditCardID	CreditCardID
Sales.CurrencyRate	CurrencyRateID	CurrencyRateID
Sales.Customer	CustomerID	CustomerID
Sales.SalesPerson	SalesPersonID	SalesPersonID
Sales.SalesTerritory	TerritoryID	TerritoryID
Purchasing.ShipMethod	ShipMethodID	ShipMethodID

Detail Table	Column	Referencing Column
Sales.SalesOrderDetail	SalesOrderID	SalesOrderID
Sales.SalesOrderHeaderSalesReason	SalesOrderID	SalesOrderID

Triggers	Type
uSalesOrderHeader	ON UPDATE