Difference between revisions of "Sales.SalesOrderHeader (table)"
(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 |