Welcome
Guest
, you are in:
<root>
•
Login
devio dbscript ScrewTurn Wiki
Navigation
¶
Main Page
Random Page
Create a new Page
All Pages
Categories
Navigation Paths
Administration
File Management
Create Account
Search the wiki
»
Discuss (0)
View Page Code
History
Sales SalesOrderHeaderSalesReason (table)
Print
RSS
Modified on 2011/08/27 11:19
by
wikibot
Categorized as
Uncategorized
Sales (schema)
Sales SalesOrderHeader (table)
Sales SalesReason (table)
Sales ContactCreditCard (table)
Sales CountryRegionCurrency (table)
Sales CreditCard (table)
Sales Currency (table)
Sales CurrencyRate (table)
Sales Customer (table)
Sales CustomerAddress (table)
Sales Individual (table)
Sales IndividualSurveySchemaCollection (xml schema collection)
Sales SalesOrderDetail (table)
Sales SalesOrderHeader (table)
Sales SalesOrderHeaderSalesReason (table)
Sales SalesPerson (table)
Sales SalesPersonQuotaHistory (table)
Sales SalesReason (table)
Sales SalesTaxRate (table)
Sales SalesTerritory (table)
Sales SalesTerritoryHistory (table)
Sales ShoppingCartItem (table)
Sales SpecialOffer (table)
Sales SpecialOfferProduct (table)
Sales Store (table)
Sales StoreContact (table)
Sales StoreSurveySchemaCollection (xml schema collection)
Sales vIndividualCustomer (view)
Sales vIndividualDemographics (view)
Sales vSalesPerson (view)
Sales vSalesPersonSalesByFiscalYears (view)
Sales vStoreWithDemographics (view)
SH COSTS (table)
SH SALES (table)
public notifications (table)
dbo Name (type)
HumanResources vEmployee (view)
Person (schema)
Person StateProvince (table)
Person vStateProvinceCountryRegion (view)
Purchasing vVendor (view)
Sales CountryRegionCurrency (table)
Sales vIndividualCustomer (view)
Sales vSalesPerson (view)
Sales vStoreWithDemographics (view)
SH COSTS (table)
SH SALES (table)
public events (table)
public ifservices (table)
public node (table)
public service (table)
public location_monitors (table)
HumanResources Employee (table)
HumanResources EmployeeAddress (table)
Person Address (table)
Person Contact (table)
Person CountryRegion (table)
Person StateProvince (table)
Sales (schema)
Sales SalesPerson (table)
Sales SalesTerritory (table)
public ifservices (table)
public outages (table)
Sales (schema)
Sales SalesOrderHeader (table)
Sales SalesReason (table)
Sales ContactCreditCard (table)
Sales CountryRegionCurrency (table)
Sales CreditCard (table)
Sales Currency (table)
Sales CurrencyRate (table)
Sales Customer (table)
Sales CustomerAddress (table)
Sales Individual (table)
Sales IndividualSurveySchemaCollection (xml schema collection)
Sales SalesOrderDetail (table)
Sales SalesOrderHeader (table)
Sales SalesOrderHeaderSalesReason (table)
Sales SalesPerson (table)
Sales SalesPersonQuotaHistory (table)
Sales SalesReason (table)
Sales SalesTaxRate (table)
Sales SalesTerritory (table)
Sales SalesTerritoryHistory (table)
Sales ShoppingCartItem (table)
Sales SpecialOffer (table)
Sales SpecialOfferProduct (table)
Sales Store (table)
Sales StoreContact (table)
Sales StoreSurveySchemaCollection (xml schema collection)
Sales vIndividualCustomer (view)
Sales vIndividualDemographics (view)
Sales vSalesPerson (view)
Sales vSalesPersonSalesByFiscalYears (view)
Sales vStoreWithDemographics (view)
SH COSTS (table)
SH SALES (table)
(10)
»
SH TIMES (table)
»
Sales (schema)
»
Sales SalesOrderHeaderSalesReason (table)
[X]
»
public service (table)
»
Sales vSalesPerson (view)
»
public location_monitor_details (table)
»
public outages (table)
»
SH PRODUCTS (table)
»
Person CountryRegion (table)
»
public usersnotified (table)
»
SH TIMES (table)
»
Sales (schema)
»
Sales SalesOrderHeaderSalesReason (table)
wikibot
¶
Table
Sales.SalesOrderHeaderSalesReason
Description
Cross-reference table mapping sales orders to sales reason codes.
Columns
¶
Column
Data Type
Nullable
Default
Description
SalesOrderID
int
not null
Primary key. Foreign key to SalesOrderHeader.SalesOrderID.
SalesReasonID
int
not null
Primary key. Foreign key to SalesReason.SalesReasonID.
ModifiedDate
datetime
not null
(getdate())
Date and time the record was last updated.
Primary Key
¶
Primary Key
Columns
PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID
SalesOrderID, SalesReasonID
Foreign Keys
¶
Relation
Column
Referenced Column
Sales.SalesOrderHeader
SalesOrderID
SalesOrderID
Sales.SalesReason
SalesReasonID
SalesReasonID
References
¶
Dependency Type
Object Type
Referenced Object
Schema
Schema
Sales
ScrewTurn Wiki
version 3.0.1.400. Some of the icons created by
FamFamFam
.