Welcome Guest, you are in: <root> • Login

Page History: Sales SalesOrderHeaderSalesReason (table)

Compare Page Revisions

4 3 2 1 0 Current 4 3 2 1 0

« Older Revision - Back to Page History - Current Revision

Page Revision: 2010/06/24 01:10

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