Difference between revisions of "Sales.SalesOrderHeader (table)"

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Sales.SalesOrderHeader |- |} {| border="1" cellpadding="5" cellspacing="0" s...)
(No difference)

Revision as of 13:34, 3 January 2009

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