Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 TYPECODE tinyint   Default = 0 The type of product the button represents.
 ISACTIVE bit   Default = 1 Determines the visibility of the action on the Daily Sales screen.
 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) CONVERT(bigint, TS) Numeric representation of the timestamp.
 BUTTONORDER int   Default = 0 The order of the button
 TYPE nvarchar(24) (Computed) CASE [TYPECODE] WHEN 0 THEN N'Daily admission programs' WHEN 1 THEN N'Scheduled programs' WHEN 2 THEN N'Memberships' WHEN 3 THEN N'Discounts and promotions' WHEN 4 THEN N'Donations' WHEN 5 THEN N'Event registrations' WHEN 6 THEN N'Merchandise' WHEN 7 THEN N'Renew memberships' WHEN 8 THEN N'Mid-term upgrades' WHEN 9 THEN N'Scan tickets' END

Foreign Key Field Type Null Notes Description
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_DAILYSALESGENERICACTION_DATEADDED DATEADDED    
 IX_DAILYSALESGENERICACTION_DATECHANGED DATECHANGED      
 PK_DAILYSALESGENERICACTION ID  

Trigger Name Description
 TR_DAILYSALESGENERICACTION_AUDIT_DELETE
 TR_DAILYSALESGENERICACTION_AUDIT_UPDATE