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

From dbscript Online Help
Jump to: navigation, search
 
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| Sales.SpecialOffer
 
| Sales.SpecialOffer
Line 8: Line 8:
 
| '''Description
 
| '''Description
 
| Sale discounts lookup table.
 
| Sale discounts lookup table.
|-
 
 
|}
 
|}
 
  
 
=== Columns ===
 
=== Columns ===
Line 20: Line 18:
 
| '''Default
 
| '''Default
 
| '''Description
 
| '''Description
+
 
 
|- valign="top"
 
|- valign="top"
 
| SpecialOfferID
 
| SpecialOfferID
Line 94: Line 92:
 
| '''Primary Key
 
| '''Primary Key
 
| '''Columns
 
| '''Columns
|-
+
|- valign="top"
 
| PK_SpecialOffer_SpecialOfferID
 
| PK_SpecialOffer_SpecialOfferID
 
| SpecialOfferID
 
| SpecialOfferID
Line 105: Line 103:
 
| '''Type
 
| '''Type
 
| '''Columns
 
| '''Columns
+
 
|-
+
|- valign="top"
 
| AK_SpecialOffer_rowguid
 
| AK_SpecialOffer_rowguid
 
| Unique
 
| Unique
Line 118: Line 116:
 
| '''Expression
 
| '''Expression
 
| '''Description
 
| '''Description
+
 
|-
+
|- valign="top"
 
| CK_SpecialOffer_DiscountPct
 
| CK_SpecialOffer_DiscountPct
 
| ([DiscountPct]>=(0.00))
 
| ([DiscountPct]>=(0.00))
 
| Check constraint [DiscountPct] >= (0.00)
 
| Check constraint [DiscountPct] >= (0.00)
|-
+
|- valign="top"
 
| CK_SpecialOffer_EndDate
 
| CK_SpecialOffer_EndDate
 
| ([EndDate]>=[StartDate])
 
| ([EndDate]>=[StartDate])
 
| Check constraint [EndDate] >= [StartDate]
 
| Check constraint [EndDate] >= [StartDate]
|-
+
|- valign="top"
 
| CK_SpecialOffer_MaxQty
 
| CK_SpecialOffer_MaxQty
 
| ([MaxQty]>=(0))
 
| ([MaxQty]>=(0))
 
| Check constraint [MaxQty] >= (0)
 
| Check constraint [MaxQty] >= (0)
|-
+
|- valign="top"
 
| CK_SpecialOffer_MinQty
 
| CK_SpecialOffer_MinQty
 
| ([MinQty]>=(0))
 
| ([MinQty]>=(0))
Line 143: Line 141:
 
| '''Column
 
| '''Column
 
| '''Referencing Column
 
| '''Referencing Column
+
 
|-
+
|- valign="top"
 
| [[Sales.SpecialOfferProduct_(table)|Sales.SpecialOfferProduct]]
 
| [[Sales.SpecialOfferProduct_(table)|Sales.SpecialOfferProduct]]
 
| SpecialOfferID
 
| SpecialOfferID
Line 157: Line 155:
 
| '''Referenced Object
 
| '''Referenced Object
  
|-
+
|- valign="top"
 
| Schema
 
| Schema
 
| Schema
 
| Schema

Latest revision as of 23:17, 23 June 2010

wikibot[edit]

Table Sales.SpecialOffer
Description Sale discounts lookup table.

Columns[edit]

Column Data Type Nullable Default Description
SpecialOfferID int not null Primary key for SpecialOffer records.
Description nvarchar(255) not null Discount description.
DiscountPct smallmoney not null ((0.00)) Discount precentage.
Type nvarchar(50) not null Discount type category.
Category nvarchar(50) not null Group the discount applies to such as Reseller or Customer.
StartDate datetime not null Discount start date.
EndDate datetime not null Discount end date.
MinQty int not null ((0)) Minimum discount percent allowed.
MaxQty int null Maximum discount percent allowed.
rowguid uniqueidentifier not null (newid()) ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate datetime not null (getdate()) Date and time the record was last updated.

Primary Key[edit]

Primary Key Columns
PK_SpecialOffer_SpecialOfferID SpecialOfferID

Indexes[edit]

Index Type Columns
AK_SpecialOffer_rowguid Unique rowguid

Check Constraints[edit]

Check Constraint Expression Description
CK_SpecialOffer_DiscountPct ([DiscountPct]>=(0.00)) Check constraint [DiscountPct] >= (0.00)
CK_SpecialOffer_EndDate ([EndDate]>=[StartDate]) Check constraint [EndDate] >= [StartDate]
CK_SpecialOffer_MaxQty ([MaxQty]>=(0)) Check constraint [MaxQty] >= (0)
CK_SpecialOffer_MinQty ([MinQty]>=(0)) Check constraint [MinQty] >= (0)

Detail Tables[edit]

Detail Table Column Referencing Column
Sales.SpecialOfferProduct SpecialOfferID SpecialOfferID

References[edit]

Dependency Type Object Type Referenced Object
Schema Schema Sales


automatically generated[edit]

Table Sales.SpecialOffer
Description Sale discounts lookup table.


Column Data Type Nullable Default Description / PK / Index
SpecialOfferID int not null Primary key for SpecialOffer records.
PK_SpecialOffer_SpecialOfferID
Description nvarchar(255) not null Discount description.
DiscountPct smallmoney not null (0.00) Discount precentage.
Type nvarchar(50) not null Discount type category.
Category nvarchar(50) not null Group the discount applies to such as Reseller or Customer.
StartDate datetime not null Discount start date.
EndDate datetime not null Discount end date.
MinQty int not null (0) Minimum discount percent allowed.
MaxQty int null Maximum discount percent allowed.
rowguid uniqueidentifier not null (NEWID()) ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
AK_SpecialOffer_rowguid
ModifiedDate datetime not null (GETDATE()) Date and time the record was last updated.


Detail Table Column Referencing Column
Sales.SpecialOfferProduct SpecialOfferID SpecialOfferID


Dependency Type Object Type Referenced Object
Schema Schema Sales