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.

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