ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Back
History
Sales.SpecialOffer_(table)
== 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 | | Primary key for SpecialOffer records. |- valign="top" | Description | nvarchar(255) | not null | | Discount description. |- valign="top" | DiscountPct | smallmoney | not null | ((0.00)) | Discount precentage. |- valign="top" | Type | nvarchar(50) | not null | | Discount type category. |- valign="top" | Category | nvarchar(50) | not null | | Group the discount applies to such as Reseller or Customer. |- valign="top" | StartDate | datetime | not null | | Discount start date. |- valign="top" | EndDate | datetime | not null | | Discount end date. |- valign="top" | MinQty | int | not null | ((0)) | Minimum discount percent allowed. |- valign="top" | MaxQty | int | null | | 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]] |} == automatically generated == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table''' | Sales.SpecialOffer |- valign="top" | '''Description''' | Sale discounts lookup table. |- |- |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Column''' | '''Data Type''' | '''Nullable''' | '''Default''' | '''Description / PK / Index''' |- | SpecialOfferID | int | not null | | Primary key for SpecialOffer records.<br />PK_SpecialOffer_SpecialOfferID |- | Description | nvarchar(255) | not null | | Discount description.<br /> |- | DiscountPct | smallmoney | not null | (0.00) | Discount precentage.<br /> |- | Type | nvarchar(50) | not null | | Discount type category.<br /> |- | Category | nvarchar(50) | not null | | Group the discount applies to such as Reseller or Customer.<br /> |- | StartDate | datetime | not null | | Discount start date.<br /> |- | EndDate | datetime | not null | | Discount end date.<br /> |- | MinQty | int | not null | (0) | Minimum discount percent allowed.<br /> |- | MaxQty | int | null | | Maximum discount percent allowed.<br /> |- | rowguid | uniqueidentifier | not null | (NEWID()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_SpecialOffer_rowguid |- | ModifiedDate | datetime | not null | (GETDATE()) | Date and time the record was last updated.<br /> |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Detail Table''' | '''Column''' | '''Referencing Column''' |- | [[Sales.SpecialOfferProduct_(table)|Sales.SpecialOfferProduct]] | SpecialOfferID | SpecialOfferID |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Dependency Type''' | '''Object Type''' | '''Referenced Object''' |- | Schema | Schema | [[Sales_(schema)|Sales]] |}
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.