Sales.SpecialOffer (table) - Revision history

Bot at 22:17, 23 June 2010

2010-06-23T22:17:52Z

Bot at 22:05, 2 February 2010

2010-02-02T22:05:23Z

Bot at 21:55, 28 December 2009

2009-12-28T21:55:33Z

Bot at 06:00, 30 November 2009

2009-11-30T06:00:18Z

Bot at 05:35, 30 November 2009

2009-11-30T05:35:40Z

Bot at 05:24, 30 November 2009

2009-11-30T05:24:55Z

Bot at 23:11, 26 November 2009

2009-11-26T23:11:08Z

Bot at 22:58, 26 November 2009

2009-11-26T22:58:21Z

Bot at 22:27, 26 November 2009

2009-11-26T22:27:33Z

Bot: New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Sales.SpecialOffer |- |} {| border="1" cellpadding="5" cellspacing="0" style...

2009-01-03T12:35:09Z

New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Sales.SpecialOffer |- |} {| border="1" cellpadding="5" cellspacing="0" style...

New page

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''Table
| Sales.SpecialOffer
|-
|}

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

|-
| SpecialOfferID
| int
| not null
|
| PK_SpecialOffer_SpecialOfferID
|
|-
| Description
| nvarchar(255)
| not null
|
|
|
|-
| DiscountPct
| smallmoney
| not null
| ((0.00))
|
|
|-
| Type
| nvarchar(50)
| not null
|
|
|
|-
| Category
| nvarchar(50)
| not null
|
|
|
|-
| StartDate
| datetime
| not null
|
|
|
|-
| EndDate
| datetime
| not null
|
|
|
|-
| MinQty
| int
| not null
| ((0))
|
|
|-
| MaxQty
| int
| null
|
|
|
|-
| rowguid
| uniqueidentifier
| not null
| (newid())
|
| AK_SpecialOffer_rowguid
|-
| ModifiedDate
| datetime
| not null
| (getdate())
|
|
|}

{| 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
|}

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | Sales.SpecialOffer
@@ Line 8: / Line 8: @@
 | '''Description
 | Sale discounts lookup table.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | SpecialOfferID
@@ Line 94: / Line 92: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_SpecialOffer_SpecialOfferID
 | SpecialOfferID
@@ Line 105: / Line 103: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | AK_SpecialOffer_rowguid
 | Unique
@@ Line 118: / Line 116: @@
 | '''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))
@@ Line 143: / Line 141: @@
 | '''Column
 | '''Referencing Column
-−
-|-
+|- valign="top"
 | [[Sales.SpecialOfferProduct_(table)|Sales.SpecialOfferProduct]]
 | SpecialOfferID
@@ Line 157: / Line 155: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Schema
 | Schema

@@ Line 12: / Line 12: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 18: / Line 19: @@
 | '''Nullable
 | '''Default
-| '''Description / PK / Index
+| '''Description
 |- valign="top"
@@ Line 25: / Line 26: @@
 | not null
+|
-| Primary key for SpecialOffer records.<br />PK_SpecialOffer_SpecialOfferID
+| Primary key for SpecialOffer records.
 |- valign="top"
 | Description
@@ Line 31: / Line 32: @@
 | not null
+|
-| Discount description.<br />
+| Discount description.
 |- valign="top"
 | DiscountPct
@@ Line 37: / Line 38: @@
 | not null
 | ((0.00))
-| Discount precentage.<br />
+| Discount precentage.
 |- valign="top"
 | Type
@@ Line 43: / Line 44: @@
 | not null
+|
-| Discount type category.<br />
+| Discount type category.
 |- valign="top"
 | Category
@@ Line 49: / Line 50: @@
 | 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"
 | StartDate
@@ Line 55: / Line 56: @@
 | not null
+|
-| Discount start date.<br />
+| Discount start date.
 |- valign="top"
 | EndDate
@@ Line 61: / Line 62: @@
 | not null
+|
-| Discount end date.<br />
+| Discount end date.
 |- valign="top"
 | MinQty
@@ Line 67: / Line 68: @@
 | not null
 | ((0))
-| Minimum discount percent allowed.<br />
+| Minimum discount percent allowed.
 |- valign="top"
 | MaxQty
@@ Line 73: / Line 74: @@
 | null
+|
-| Maximum discount percent allowed.<br />
+| Maximum discount percent allowed.
 |- valign="top"
 | rowguid
@@ Line 79: / Line 80: @@
 | not null
 | (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"
 | ModifiedDate
@@ Line 85: / Line 86: @@
 | not null
 | (getdate())
-| Date and time the record was last updated.<br />
+| Date and time the record was last updated.
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 102: / Line 150: @@
 |}

@@ Line 117: / Line 117: @@
 | Sales.SpecialOffer
 |- valign="top"
 | '''Description
 | Sale discounts lookup table.
 |-
 |}

@@ Line 218: / Line 218: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referenced Object
 |-
 | Schema
 | Schema
 |}

@@ Line 116: / Line 116: @@
 | '''Table
 | Sales.SpecialOffer
-|-
+|- valign="top"
 | '''Description
@@ Line 138: / Line 138: @@
 | not null
+|
-| Primary key for SpecialOffer records.PK_SpecialOffer_SpecialOfferID
+| Primary key for SpecialOffer records.<br />PK_SpecialOffer_SpecialOfferID
 |- valign="top"
 | Description
@@ Line 144: / Line 144: @@
 | not null
+|
-| Discount description.
+| Discount description.<br />
 |- valign="top"
 | DiscountPct
@@ Line 150: / Line 150: @@
 | not null
 | (0.00)
-| Discount precentage.
+| Discount precentage.<br />
 |- valign="top"
 | Type
@@ Line 156: / Line 156: @@
 | not null
+|
-| Discount type category.
+| Discount type category.<br />
 |- valign="top"
 | Category
@@ Line 162: / Line 162: @@
 | not null
+|
-| Group the discount applies to such as Reseller or Customer.
+| Group the discount applies to such as Reseller or Customer.<br />
 |- valign="top"
 | StartDate
@@ Line 168: / Line 168: @@
 | not null
+|
-| Discount start date.
+| Discount start date.<br />
 |- valign="top"
 | EndDate
@@ Line 174: / Line 174: @@
 | not null
+|
-| Discount end date.
+| Discount end date.<br />
 |- valign="top"
 | MinQty
@@ Line 180: / Line 180: @@
 | not null
 | (0)
-| Minimum discount percent allowed.
+| Minimum discount percent allowed.<br />
 |- valign="top"
 | MaxQty
@@ Line 186: / Line 186: @@
 | null
+|
-| Maximum discount percent allowed.
+| Maximum discount percent allowed.<br />
 |- valign="top"
 | rowguid
@@ Line 192: / Line 192: @@
 | not null
 | (NEWID())
-| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.AK_SpecialOffer_rowguid
+| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_SpecialOffer_rowguid
 |- valign="top"
 | ModifiedDate
@@ Line 198: / Line 198: @@
 | not null
 | (GETDATE())
-| Date and time the record was last updated.
+| Date and time the record was last updated.<br />
 |}