Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: Sales SpecialOffer (table)

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: 2010/01/09 17:49


wikibot

TableSales.SpecialOffer
DescriptionSale discounts lookup table.

ColumnData TypeNullableDefaultDescription / PK / Index
SpecialOfferIDintnot null Primary key for SpecialOffer records.
PK_SpecialOffer_SpecialOfferID
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.
AK_SpecialOffer_rowguid
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.



Detail TableColumnReferencing Column
Sales.SpecialOfferProductSpecialOfferIDSpecialOfferID

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.