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

Page History: Sales SalesReason (table)

Compare Page Revisions

5 4 3 2 1 0 Current 5 4 3 2 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: 2010/02/11 09:07

wikibot ¶

Table	Sales.SalesReason
Description	Lookup table of customer purchase reasons.

Columns ¶

Column	Data Type	Nullable	Default	Description
SalesReasonID	int	not null		Primary key for SalesReason records.
Name	dbo.Name	not null		Sales reason description.
ReasonType	dbo.Name	not null		Category the sales reason belongs to.
ModifiedDate	datetime	not null	(getdate())	Date and time the record was last updated.

Primary Key ¶

Primary Key	Columns
PK_SalesReason_SalesReasonID	SalesReasonID

Detail Tables ¶

Detail Table	Column	Referencing Column
Sales.SalesOrderHeaderSalesReason	SalesReasonID	SalesReasonID

References ¶

Dependency Type	Object Type	Referenced Object
Data Type	Type	dbo.Name
Schema	Schema	Sales