V_QUERY_DISCOUNT
Provides the ability to query discounts.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| NAME | nvarchar(100) | Name | |
| DESCRIPTION | nvarchar(255) | Description | |
| APPLIESTO | nvarchar(5) | yes | Applies to order or item |
| DISCOUNTTYPE | nvarchar(22) | yes | Discount type |
| CALCULATIONTYPE | nvarchar(14) | yes | Calculation type |
| PERCENT | decimal(5, 2) | yes | Ticket percent |
| AMOUNT | money | yes | Ticket amount |
| ISACTIVE | bit | Active | |
| APPLICATIONTYPE | nvarchar(13) | yes | Application type |
| NUMBERTOPURCHASE | int | Required quantity to purchase | |
| NUMBERTODISCOUNTTYPE | nvarchar(17) | yes | Quantity to discount type |
| NUMBERTODISCOUNT | int | Quantity to discount | |
| LIMITDISCOUNTSPERORDER | bit | Limit discounts per order | |
| NUMBEROFDISCOUNTSPERORDER | int | Number of discounts per order | |
| DISCOUNTTICKETSFOR | nvarchar(35) | yes | Limit discount to |
| ADDEDBY_APPLICATION | nvarchar(200) | yes | Added by application |
| ADDEDBY_USERNAME | nvarchar(128) | yes | Added by user name |
| CHANGEDBY_APPLICATION | nvarchar(200) | yes | Changed by application |
| CHANGEDBY_USERNAME | nvarchar(128) | yes | Changed by user name |
| DATEADDED | datetime | Date added | |
| DATECHANGED | datetime | Date changed | |
| TSLONG | bigint | yes | Timestamp value |
| APPLIESTOMERCHANDISE | bit | Applies to merchandise | |
| APPLIESTOTICKETS | bit | Applies to tickets | |
| MERCHANDISEPERCENT | decimal(5, 2) | Merchandise percent | |
| MERCHANDISEAMOUNT | money | Merchandise amount | |
| QUALIFYINGITEMTYPE | nvarchar(11) | yes | Qualifying item type |
| DISCOUNTMERCHANDISEFOR | nvarchar(41) | yes | Discount merchandise for |
| DISCOUNTITEMTYPE | nvarchar(11) | yes | Discount item type |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 11/11/2014 4:12:00 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_DISCOUNT AS
select
DISCOUNT.ID,
DISCOUNT.NAME,
DISCOUNT.[DESCRIPTION],
DISCOUNT.APPLIESTO,
DISCOUNT.DISCOUNTTYPE,
DISCOUNT.CALCULATIONTYPE,
case DISCOUNT.APPLIESTOCODE
when 1 then DPT.[PERCENT]
else DISCOUNT.[PERCENT]
end [PERCENT],
case DISCOUNT.APPLIESTOCODE
when 1 then DPT.[AMOUNT]
else DISCOUNT.[AMOUNT]
end [AMOUNT],
DISCOUNT.ISACTIVE,
DISCOUNT.APPLICATIONTYPE,
DISCOUNT.NUMBERTOPURCHASE,
DISCOUNT.NUMBERTODISCOUNTTYPE,
DISCOUNT.NUMBERTODISCOUNT,
DISCOUNT.LIMITDISCOUNTSPERORDER,
DISCOUNT.NUMBEROFDISCOUNTSPERORDER,
DISCOUNT.DISCOUNTTICKETSFOR,
[ADDEDBY].APPLICATIONNAME as [ADDEDBY_APPLICATION],
[ADDEDBY].USERNAME as [ADDEDBY_USERNAME],
[CHANGEDBY].APPLICATIONNAME as [CHANGEDBY_APPLICATION],
[CHANGEDBY].USERNAME as [CHANGEDBY_USERNAME],
DISCOUNT.DATEADDED,
DISCOUNT.DATECHANGED,
DISCOUNT.TSLONG,
DISCOUNT.APPLIESTOMERCHANDISE,
DISCOUNT.APPLIESTOTICKETS,
DISCOUNT.MERCHANDISEPERCENT,
DISCOUNT.MERCHANDISEAMOUNT,
DISCOUNT.QUALIFYINGITEMTYPE,
DISCOUNT.DISCOUNTMERCHANDISEFOR,
DISCOUNT.DISCOUNTITEMTYPE
/*EXTENSION*/
from
dbo.DISCOUNT
left outer join
dbo.DISCOUNTPRICETYPE DPT on DPT.DISCOUNTID = DISCOUNT.ID
left outer join
dbo.CHANGEAGENT as [ADDEDBY] on DISCOUNT.ADDEDBYID = [ADDEDBY].ID
left outer join
dbo.CHANGEAGENT as [CHANGEDBY] on DISCOUNT.CHANGEDBYID = [CHANGEDBY].ID
where
DISCOUNT.SUPERSEDEDBYID is null