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

From dbscript Online Help
Jump to: navigation, search
 
(One intermediate revision 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
Line 8: Line 8:
 
| '''Description
 
| '''Description
 
| Sale discounts lookup table.
 
| 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 18: Line 17:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''Description / PK / Index
+
| '''Description
−
+
 
 
|- valign="top"
 
|- valign="top"
 
| SpecialOfferID
 
| SpecialOfferID
Line 25: Line 24:
 
| 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 30:
 
| not null
 
| not null
 
|  
 
|  
−
| Discount description.<br />
+
| Discount description.
 
|- valign="top"
 
|- valign="top"
 
| DiscountPct
 
| DiscountPct
Line 37: Line 36:
 
| not null
 
| not null
 
| ((0.00))
 
| ((0.00))
−
| Discount precentage.<br />
+
| Discount precentage.
 
|- valign="top"
 
|- valign="top"
 
| Type
 
| Type
Line 43: Line 42:
 
| not null
 
| not null
 
|  
 
|  
−
| Discount type category.<br />
+
| Discount type category.
 
|- valign="top"
 
|- valign="top"
 
| Category
 
| Category
Line 49: Line 48:
 
| 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 54:
 
| not null
 
| not null
 
|  
 
|  
−
| Discount start date.<br />
+
| Discount start date.
 
|- valign="top"
 
|- valign="top"
 
| EndDate
 
| EndDate
Line 61: Line 60:
 
| not null
 
| not null
 
|  
 
|  
−
| Discount end date.<br />
+
| Discount end date.
 
|- valign="top"
 
|- valign="top"
 
| MinQty
 
| MinQty
Line 67: Line 66:
 
| not null
 
| not null
 
| ((0))
 
| ((0))
−
| Minimum discount percent allowed.<br />
+
| Minimum discount percent allowed.
 
|- valign="top"
 
|- valign="top"
 
| MaxQty
 
| MaxQty
Line 73: Line 72:
 
| null
 
| null
 
|  
 
|  
−
| Maximum discount percent allowed.<br />
+
| Maximum discount percent allowed.
 
|- valign="top"
 
|- valign="top"
 
| rowguid
 
| rowguid
Line 79: Line 78:
 
| 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 84:
 
| 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
 +
|- 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 95: Line 141:
 
| '''Column
 
| '''Column
 
| '''Referencing Column
 
| '''Referencing Column
−
+
 
−
|-
+
|- valign="top"
 
| [[Sales.SpecialOfferProduct_(table)|Sales.SpecialOfferProduct]]
 
| [[Sales.SpecialOfferProduct_(table)|Sales.SpecialOfferProduct]]
 
| SpecialOfferID
 
| SpecialOfferID
Line 102: Line 148:
 
|}
 
|}
  
 +
=== 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]]
 +
 +
|}
  
  

Latest revision as of 00:17, 24 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"