SALESORDERITEMMEMBERSHIPITEMPROMOTIONAPPLIEDITEMTICKET

Stores the tickets that are applied to a membership promotion

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
DATEADDED	datetime		Default = getdate()	Indicates the date this record was added.
DATECHANGED	datetime		Default = getdate()	Indicates the date this record was last changed.
TS	timestamp			Timestamp.
TSLONG	bigint (Computed)	yes	CONVERT(bigint, TS)	Numeric representation of the timestamp.
AMOUNTAPPLIED	money		Default = 0

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
SALESORDERITEMMEMBERSHIPITEMPROMOTIONAPPLIEDITEMID	uniqueidentifier		SALESORDERITEMMEMBERSHIPITEMPROMOTIONAPPLIEDITEM.ID	Applied sales order item for promotion
TICKETID	uniqueidentifier		TICKET.ID	Applied ticket for promotion
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_SALESORDERITEMMEMBERSHIPITEMPROMOTIONAPPLIEDITEMTICKET_DATEADDED	DATEADDED			yes
IX_SALESORDERITEMMEMBERSHIPITEMPROMOTIONAPPLIEDITEMTICKET_DATECHANGED	DATECHANGED
IX_SALESORDERITEMMEMBERSHIPITEMPROMOTIONAPPLIEDITEMTICKET_SALESORDERITEMMEMBERSHIPITEMPROMOTIONAPPLIEDITEMID	SALESORDERITEMMEMBERSHIPITEMPROMOTIONAPPLIEDITEMID
IX_SALESORDERITEMMEMBERSHIPITEMPROMOTIONAPPLIEDITEMTICKET_TICKETID	TICKETID
PK_SALESORDERITEMMEMBERSHIPITEMPROMOTIONAPPLIEDITEMTICKET	ID	yes	yes

Triggers

Trigger Name	Description
TR_SALESORDERITEMMEMBERSHIPITEMPROMOTIONAPPLIEDITEMTICKET_DELETE_UPDATETICKET
TR_SALESORDERITEMMEMBERSHIPITEMPROMOTIONAPPLIEDITEMTICKET_AUDIT_UPDATE
TR_SALESORDERITEMMEMBERSHIPITEMPROMOTIONAPPLIEDITEMTICKET_AUDIT_DELETE