Open topic with navigation

SALESORDERITEMTICKET (4.0SP6)

Top
Primary Key
Foreign Key Fields
Fields
Indexes
Triggers
Referenced by

Stores data for a ticket on a sales order.

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
PROGRAMID	uniqueidentifier	true	PROGRAM.ID	The program for this ticket
EVENTID	uniqueidentifier	true	EVENT.ID	The event for this ticket.
PRICETYPECODEID	uniqueidentifier	false	PRICETYPECODE.ID	The price type for this ticket.
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.

Fields
Field	Field Type	Null	Notes	Description
PRICE	money	false	0	The price of the ticket
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.
PROGRAMNAME	nvarchar(100)	false	''	Name of program at time of sale.
PROGRAMCATEGORYNAME	nvarchar(100)	false	''	Program category name at time of sale.

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_SALESORDERITEMTICKET_DATEADDED	DATEADDED	False	False	True
IX_SALESORDERITEMTICKET_DATECHANGED	DATECHANGED	False	False	False
IX_SALESORDERITEMTICKET_EVENTID	EVENTID	False	False	False
IX_SALESORDERITEMTICKET_PROGRAMID	PROGRAMID	False	False	False
PK_SALESORDERITEMTICKET	ID	True	True	False

Triggers
Trigger Name	Description
TR_SALESORDERITEMTICKET_AUDIT_UPDATE
TR_SALESORDERITEMTICKET_AUDIT_DELETE

Referenced by
Referenced by	Field
RESCHEDULETICKETSHISTORY	SALESORDERITEMTICKETID
SALESORDERITEMTICKETCOMBINATION	ID
SALESORDERITEMTICKETREGISTRANT	SALESORDERITEMTICKETID
TICKET	SALESORDERITEMTICKETID