Open topic with navigation

TICKET (4.0SP7)

Top
Primary Key
Foreign Key Fields
Fields
Indexes
Triggers
Referenced by

Stores data related to a ticket.

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
EVENTID	uniqueidentifier	true	EVENT.ID	ID of the event in which the ticket is linked.
PRICETYPECODEID	uniqueidentifier	false	PRICETYPECODE.ID	The ID of the Price Type that belongs to the Ticket.
HOLDID	uniqueidentifier	true	HOLD.ID	The entity that is holding the ticket.
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
SALESORDERITEMTICKETID	uniqueidentifier	true	SALESORDERITEMTICKET.ID	The order ticket that created this ticket.
PROGRAMID	uniqueidentifier	true	PROGRAM.ID	The program of this ticket.
APPLIEDTOMEMBERSHIPSALESORDERID	uniqueidentifier	true	SALESORDER.ID	The sales order that ticket has been applied to.

Fields
Field	Field Type	Null	Notes	Description
PRICE	money	false	0	The price of the ticket
STATUSCODE	tinyint	false	0	Specifies the particular state of a ticket.
ISACTIVE	bit	false	1	Describes whether the ticket is active.
DATEADDED	datetime	false	getdate()	Indicates the date this record was added.
DATECHANGED	datetime	false	getdate()	Indicates the date this record was last changed.
TS	timestamp	false		Timestamp.
TSLONG	bigint (Computed)	true		Numeric representation of the timestamp.
TICKETNUMBER	bigint (Computed)	true		The event specific ticket number.
APPLIEDTOMEMBERSHIP	bit	false	0	Describes whether the ticket has been applied to a membership.
SCANDATEWITHTIMEOFFSET	datetimeoffset	true
AMOUNTPAID	money	true	0
ORDERLEVELDISCOUNTSAPPLIED	money	true	0
ITEMLEVELDISCOUNTSAPPLIED	money	true	0
STATUS	nvarchar(9) (Computed)	true
ISREFUNDED	bit	false	0

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_TICKET_DATEADDED	DATEADDED	False	False	True
IX_TICKET_DATECHANGED	DATECHANGED	False	False	False
IX_TICKET_EVENTID	EVENTID	False	False	False
IX_TICKET_PROGRAMID	PROGRAMID	False	False	False
IX_TICKET_SALESORDERITEMTICKETID	SALESORDERITEMTICKETID	False	False	False
IX_TICKET_SCANDATEWITHTIMEOFFSET	SCANDATEWITHTIMEOFFSET	False	False	False
PK_TICKET	ID	True	True	False

Triggers
Trigger Name	Description
TR_TICKET_AUDIT_UPDATE
TR_TICKET_AUDIT_DELETE

Referenced by
Referenced by	Field
CREDITITEMTICKET	TICKETID
RESCHEDULETICKETSHISTORY	TICKETID
SALESORDERITEMMEMBERSHIPITEMPROMOTIONAPPLIEDITEMTICKET	TICKETID
SALESORDERITEMTICKETFEE	TICKETID
TICKETPRINTINFO	TICKETID