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

From dbscript Online Help
Jump to: navigation, search
 
(2 intermediate revisions by the same user not shown)
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
−
|-
+
|- valign="top"
 +
| '''Description
 +
| Sale discounts lookup table.
 
|}
 
|}
  
−
 
+
=== Columns ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 15: Line 17:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description
−
| '''Index
+
 
−
+
|- valign="top"
−
|-
 
 
| SpecialOfferID
 
| SpecialOfferID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| PK_SpecialOffer_SpecialOfferID
+
| Primary key for SpecialOffer records.
−
|
+
|- valign="top"
−
|-
 
 
| Description
 
| Description
 
| nvarchar(255)
 
| nvarchar(255)
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Discount description.
−
|
+
|- valign="top"
−
|-
 
 
| DiscountPct
 
| DiscountPct
 
| smallmoney
 
| smallmoney
 
| not null
 
| not null
 
| ((0.00))
 
| ((0.00))
−
|  
+
| Discount precentage.
−
|
+
|- valign="top"
−
|-
 
 
| Type
 
| Type
 
| nvarchar(50)
 
| nvarchar(50)
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Discount type category.
−
|
+
|- valign="top"
−
|-
 
 
| Category
 
| Category
 
| nvarchar(50)
 
| nvarchar(50)
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Group the discount applies to such as Reseller or Customer.
−
|
+
|- valign="top"
−
|-
 
 
| StartDate
 
| StartDate
 
| datetime
 
| datetime
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Discount start date.
−
|
+
|- valign="top"
−
|-
 
 
| EndDate
 
| EndDate
 
| datetime
 
| datetime
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Discount end date.
−
|
+
|- valign="top"
−
|-
 
 
| MinQty
 
| MinQty
 
| int
 
| int
 
| not null
 
| not null
 
| ((0))
 
| ((0))
−
|  
+
| Minimum discount percent allowed.
−
|
+
|- valign="top"
−
|-
 
 
| MaxQty
 
| MaxQty
 
| int
 
| int
 
| null
 
| null
 
|  
 
|  
−
|  
+
| Maximum discount percent allowed.
−
|
+
|- valign="top"
−
|-
 
 
| rowguid
 
| rowguid
 
| uniqueidentifier
 
| uniqueidentifier
 
| not null
 
| not null
 
| (newid())
 
| (newid())
−
|  
+
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
−
| AK_SpecialOffer_rowguid
+
|- valign="top"
−
|-
 
 
| ModifiedDate
 
| ModifiedDate
 
| datetime
 
| datetime
 
| not null
 
| not null
 
| (getdate())
 
| (getdate())
−
|  
+
| Date and time the record was last updated.
−
|  
+
|}
 +
 
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|- valign="top"
 +
| PK_SpecialOffer_SpecialOfferID
 +
| SpecialOfferID
 
|}
 
|}
  
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
  
 +
|- valign="top"
 +
| AK_SpecialOffer_rowguid
 +
| Unique
 +
| rowguid
 +
|}
  
 +
=== Check Constraints ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Check Constraint
 +
| '''Expression
 +
| '''Description
 +
 +
|- valign="top"
 +
| CK_SpecialOffer_DiscountPct
 +
| ([DiscountPct]>=(0.00))
 +
| Check constraint [DiscountPct] >= (0.00)
 +
|- valign="top"
 +
| CK_SpecialOffer_EndDate
 +
| ([EndDate]>=[StartDate])
 +
| Check constraint [EndDate] >= [StartDate]
 +
|- valign="top"
 +
| CK_SpecialOffer_MaxQty
 +
| ([MaxQty]>=(0))
 +
| Check constraint [MaxQty] >= (0)
 +
|- valign="top"
 +
| CK_SpecialOffer_MinQty
 +
| ([MinQty]>=(0))
 +
| Check constraint [MinQty] >= (0)
 +
|}
 +
 +
=== Detail Tables ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 104: Line 141:
 
| '''Column
 
| '''Column
 
| '''Referencing Column
 
| '''Referencing Column
−
+
 
−
|-
+
|- valign="top"
 
| [[Sales.SpecialOfferProduct_(table)|Sales.SpecialOfferProduct]]
 
| [[Sales.SpecialOfferProduct_(table)|Sales.SpecialOfferProduct]]
 
| SpecialOfferID
 
| SpecialOfferID
 
| SpecialOfferID
 
| SpecialOfferID
 
|}
 
|}
 +
 +
=== References ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|- valign="top"
 +
| Schema
 +
| Schema
 +
| [[Sales_(schema)|Sales]]
 +
 +
|}
 +
 +
 
== automatically generated ==
 
== automatically generated ==
  

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
Retrieved from "http://dbshelp.devio.at/index.php?title=Sales.SpecialOffer_(table)&oldid=2678"