Sales SpecialOffer (table)

wikibot

TableSales.SpecialOffer
DescriptionSale discounts lookup table.

Columns

ColumnData TypeNullableDefaultDescription
SpecialOfferIDintnot null Primary key for SpecialOffer records.
Descriptionnvarchar(255)not null Discount description.
DiscountPctsmallmoneynot null((0.00))Discount precentage.
Typenvarchar(50)not null Discount type category.
Categorynvarchar(50)not null Group the discount applies to such as Reseller or Customer.
StartDatedatetimenot null Discount start date.
EndDatedatetimenot null Discount end date.
MinQtyintnot null((0))Minimum discount percent allowed.
MaxQtyintnull Maximum discount percent allowed.
rowguiduniqueidentifiernot null(newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.

Primary Key

Primary KeyColumns
PK_SpecialOffer_SpecialOfferIDSpecialOfferID

Indexes

IndexTypeColumns
AK_SpecialOffer_rowguidUniquerowguid

Check Constraints

Check ConstraintExpressionDescription
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 TableColumnReferencing Column
Sales.SpecialOfferProductSpecialOfferIDSpecialOfferID

References

Dependency TypeObject TypeReferenced Object
SchemaSchemaSales