Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 MERCHANTACCOUNTID uniqueidentifier
 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.
 EMAILTEMPLATEID int   Default = 0 Acknowledgement Email Data
 ALLOWPLEDGE bit   Default = 0
 ALLOWDIRECTDEBIT bit   Default = 0
 CONFIRMATIONBLOCK nvarchar(max)   Default = '' Confirmation Screen Data
 DAYSUNTILANONYMOUSUSERCOOKIEEXPIRES int   Default = 30 How many days an anonymous user's cookie should last for
 ALLOWCREDITCARD bit   Default = 0
 REQUIREFIRSTNAME bit   Default = 0
 REQUIRETITLE bit   Default = 0
 REQUIREPHONE bit   Default = 0
 ALLOWINLINEREGISTRATION bit   Default = 0
 BBPAYTEMPLATEID uniqueidentifier Template ID to use for the secure payment process.
 REGISTERFORDONATION bit   Default = 0
 REGISTERFOREVENTREGISTRATION bit   Default = 0
 REGISTERFORMEMBERSHIP bit   Default = 0
 REGISTERFORSPONSORSHIP bit   Default = 0
 REGISTRATIONPAGEID int   Default = 0
 ENABLEFINDERNUMBER bit   Default = 0
 FINDERNUMBERIMAGEID int   Default = 0
 FINDERNUMBERHELPTEXT nvarchar(250)   Default = ''

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_SHOPPINGCARTSETTINGS_DATEADDED DATEADDED    
 IX_SHOPPINGCARTSETTINGS_DATECHANGED DATECHANGED      
 PK_SHOPPINGCARTSETTINGS ID  

Trigger Name Description
 TR_SHOPPINGCARTSETTINGS_AUDIT_UPDATE
 TR_SHOPPINGCARTSETTINGS_AUDIT_DELETE

Referenced by Field
 SHOPPINGCARTSETTINGSTHUMBNAILS SHOPPINGCARTSETTINGSID

Entity-Relationship diagram of this table