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

From dbscript Online Help
Jump to: navigation, search
Line 12: Line 12:
  
  
 +
=== 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 18: Line 19:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''Description / PK / Index
+
| '''Description
 
 
 
|- valign="top"
 
|- valign="top"
Line 25: Line 26:
 
| not null
 
| not null
 
|  
 
|  
−
| Primary key for SpecialOffer records.<br />PK_SpecialOffer_SpecialOfferID
+
| Primary key for SpecialOffer records.
 
|- valign="top"
 
|- valign="top"
 
| Description
 
| Description
Line 31: Line 32:
 
| not null
 
| not null
 
|  
 
|  
−
| Discount description.<br />
+
| Discount description.
 
|- valign="top"
 
|- valign="top"
 
| DiscountPct
 
| DiscountPct
Line 37: Line 38:
 
| not null
 
| not null
 
| ((0.00))
 
| ((0.00))
−
| Discount precentage.<br />
+
| Discount precentage.
 
|- valign="top"
 
|- valign="top"
 
| Type
 
| Type
Line 43: Line 44:
 
| not null
 
| not null
 
|  
 
|  
−
| Discount type category.<br />
+
| Discount type category.
 
|- valign="top"
 
|- valign="top"
 
| Category
 
| Category
Line 49: Line 50:
 
| not null
 
| not null
 
|  
 
|  
−
| Group the discount applies to such as Reseller or Customer.<br />
+
| Group the discount applies to such as Reseller or Customer.
 
|- valign="top"
 
|- valign="top"
 
| StartDate
 
| StartDate
Line 55: Line 56:
 
| not null
 
| not null
 
|  
 
|  
−
| Discount start date.<br />
+
| Discount start date.
 
|- valign="top"
 
|- valign="top"
 
| EndDate
 
| EndDate
Line 61: Line 62:
 
| not null
 
| not null
 
|  
 
|  
−
| Discount end date.<br />
+
| Discount end date.
 
|- valign="top"
 
|- valign="top"
 
| MinQty
 
| MinQty
Line 67: Line 68:
 
| not null
 
| not null
 
| ((0))
 
| ((0))
−
| Minimum discount percent allowed.<br />
+
| Minimum discount percent allowed.
 
|- valign="top"
 
|- valign="top"
 
| MaxQty
 
| MaxQty
Line 73: Line 74:
 
| null
 
| null
 
|  
 
|  
−
| Maximum discount percent allowed.<br />
+
| Maximum discount percent allowed.
 
|- valign="top"
 
|- valign="top"
 
| rowguid
 
| rowguid
Line 79: Line 80:
 
| not null
 
| not null
 
| (newid())
 
| (newid())
−
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_SpecialOffer_rowguid
+
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
 
|- valign="top"
 
|- valign="top"
 
| ModifiedDate
 
| ModifiedDate
Line 85: Line 86:
 
| not null
 
| not null
 
| (getdate())
 
| (getdate())
−
| Date and time the record was last updated.<br />
+
| 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
 +
|-
 +
| PK_SpecialOffer_SpecialOfferID
 +
| SpecialOfferID
 +
|}
  
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
 +
 +
|-
 +
| AK_SpecialOffer_rowguid
 +
| Unique
 +
| rowguid
 +
|}
 +
 +
=== Check Constraints ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''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 ===
 
{| 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 102: Line 150:
 
|}
 
|}
  
 +
=== References ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|-
 +
| Schema
 +
| Schema
 +
| [[Sales_(schema)|Sales]]
 +
 +
|}
  
  

Revision as of 00:05, 3 February 2010

wikibot

Table Sales.SpecialOffer
Description Sale discounts lookup table.


Columns

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

Primary Key Columns
PK_SpecialOffer_SpecialOfferID SpecialOfferID

Indexes

Index Type Columns
AK_SpecialOffer_rowguid Unique rowguid

Check Constraints

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

Detail Table Column Referencing Column
Sales.SpecialOfferProduct SpecialOfferID SpecialOfferID

References

Dependency Type Object Type Referenced Object
Schema Schema Sales


automatically generated

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=2093"