Sales SpecialOffer (table)

Modified on 2011/08/27 11:19 by wikibot Categorized as Uncategorized
== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- valign="top"
| '''Table'''
| Sales.SpecialOffer
|- valign="top"
| '''Description'''
| Sale discounts lookup table.
|}

=== Columns ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Column'''
| '''Data Type'''
| '''Nullable'''
| '''Default'''
| '''Description'''

|- valign="top"
| SpecialOfferID
| int
| not null
| &nbsp;
| Primary key for SpecialOffer records.
|- valign="top"
| Description
| nvarchar(255)
| not null
| &nbsp;
| Discount description.
|- valign="top"
| DiscountPct
| smallmoney
| not null
| ((0.00))
| Discount precentage.
|- valign="top"
| Type
| nvarchar(50)
| not null
| &nbsp;
| Discount type category.
|- valign="top"
| Category
| nvarchar(50)
| not null
| &nbsp;
| Group the discount applies to such as Reseller or Customer.
|- valign="top"
| StartDate
| datetime
| not null
| &nbsp;
| Discount start date.
|- valign="top"
| EndDate
| datetime
| not null
| &nbsp;
| Discount end date.
|- valign="top"
| MinQty
| int
| not null
| ((0))
| Minimum discount percent allowed.
|- valign="top"
| MaxQty
| int
| null
| &nbsp;
| Maximum discount percent allowed.
|- valign="top"
| rowguid
| uniqueidentifier
| not null
| (newid())
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|- valign="top"
| ModifiedDate
| datetime
| not null
| (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"
|- style="background:silver"
| '''Detail Table'''
| '''Column'''
| '''Referencing Column'''

|- valign="top"
| [[Sales SpecialOfferProduct (table)|Sales.SpecialOfferProduct]]
| 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]]

|}
devio dbscript ScrewTurn Wiki

Navigation¶

Sales SpecialOffer (table)
