V_QUERY_TICKET
Provides the ability to query tickets.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| SALESORDERITEMTICKETID | uniqueidentifier | yes | Sales order ticket ID |
| EVENTID | uniqueidentifier | yes | Event ID |
| PRICETYPECODEID_TRANSLATION | nvarchar(100) | yes | Price type |
| PRICE | money | Price | |
| TICKETNUMBER | bigint | yes | Ticket number |
| STATUS | nvarchar(9) | yes | Status |
| HOLDID | uniqueidentifier | yes | Hold ID |
| ISACTIVE | bit | Active | |
| 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 |
| APPLIEDTOMEMBERSHIP | bit | Applied to membership | |
| APPLIEDTOMEMBERSHIPSALESORDERID | uniqueidentifier | yes | Sales order ID applied to |
| SALESORDERID | uniqueidentifier | yes | Sales order ID |
| SCANDATEWITHTIMEOFFSET | datetimeoffset | yes | |
| ISREFUNDED | bit |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 11/11/2014 4:19:04 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_TICKET AS
select
TICKET.ID,
TICKET.SALESORDERITEMTICKETID,
TICKET.EVENTID,
PRICETYPECODE.[DESCRIPTION] as [PRICETYPECODEID_TRANSLATION],
TICKET.PRICE,
TICKET.TICKETNUMBER,
TICKET.STATUS,
TICKET.HOLDID,
TICKET.ISACTIVE,
[ADDEDBY].APPLICATIONNAME as [ADDEDBY_APPLICATION],
[ADDEDBY].USERNAME as [ADDEDBY_USERNAME],
[CHANGEDBY].APPLICATIONNAME as [CHANGEDBY_APPLICATION],
[CHANGEDBY].USERNAME as [CHANGEDBY_USERNAME],
TICKET.DATEADDED,
TICKET.DATECHANGED,
TICKET.TSLONG,
TICKET.APPLIEDTOMEMBERSHIP,
TICKET.APPLIEDTOMEMBERSHIPSALESORDERID,
SALESORDERITEM.SALESORDERID,
TICKET.SCANDATEWITHTIMEOFFSET,
TICKET.ISREFUNDED
/*EXTENSION*/
from
dbo.TICKET
left outer join
dbo.PRICETYPECODE on TICKET.PRICETYPECODEID = PRICETYPECODE.ID
left outer join
dbo.CHANGEAGENT as [ADDEDBY] on TICKET.ADDEDBYID = [ADDEDBY].ID
left outer join
dbo.CHANGEAGENT as [CHANGEDBY] on TICKET.CHANGEDBYID = [CHANGEDBY].ID
left outer join
dbo.SALESORDERITEM on SALESORDERITEMTICKETID = SALESORDERITEM.ID