This table stores the settings of a shopping cart 2.0 part.
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
MERCHANTACCOUNTID
|
uniqueidentifier
|
true
|
|
|
|
DATEADDED
|
datetime
|
false
|
|
Indicates the date this record was added.
|
|
DATECHANGED
|
datetime
|
false
|
|
Indicates the date this record was last changed.
|
|
TS
|
timestamp
|
false
|
|
Timestamp.
|
|
TSLONG
|
bigint (Computed)
|
true
|
|
Numeric representation of the timestamp.
|
|
EMAILTEMPLATEID
|
int
|
false
|
|
Acknowledgement Email Data
|
|
ALLOWPLEDGE
|
bit
|
false
|
|
|
|
ALLOWDIRECTDEBIT
|
bit
|
false
|
|
|
|
CONFIRMATIONBLOCK
|
nvarchar(max)
|
false
|
|
Confirmation Screen Data
|
|
DAYSUNTILANONYMOUSUSERCOOKIEEXPIRES
|
int
|
false
|
|
How many days an anonymous user's cookie should last for
|
|
ALLOWCREDITCARD
|
bit
|
false
|
|
|
|
REQUIREFIRSTNAME
|
bit
|
false
|
|
|
|
REQUIRETITLE
|
bit
|
false
|
|
|
|
REQUIREPHONE
|
bit
|
false
|
|
|
|
ALLOWINLINEREGISTRATION
|
bit
|
false
|
|
|
|
BBPAYTEMPLATEID
|
uniqueidentifier
|
true
|
|
Template ID to use for the secure payment process.
|
|
REGISTERFORDONATION
|
bit
|
false
|
|
Require online users to register before completing donation check out.
|
|
REGISTERFOREVENTREGISTRATION
|
bit
|
false
|
|
Require online users to register before completing event registration check out.
|
|
REGISTERFORMEMBERSHIP
|
bit
|
false
|
|
Require online users to register before completing membership check out.
|
|
REGISTERFORSPONSORSHIP
|
bit
|
false
|
|
Require online users to register before completing sponsorship check out.
|
|
REGISTRATIONPAGEID
|
int
|
false
|
|
ID of BBIS page to direct online users for registration.
|
|
ENABLEFINDERNUMBER
|
bit
|
false
|
|
|
|
FINDERNUMBERIMAGEID
|
int
|
false
|
|
|
|
FINDERNUMBERHELPTEXT
|
nvarchar(250)
|
false
|
|
|
|
REQUIREMIDDLENAME
|
bit
|
false
|
|
|
|
INCLUDEMIDDLENAME
|
bit
|
false
|
|
|
|
REQUIRECONFIRMEMAIL
|
bit
|
false
|
|
|
|
INCLUDECONFIRMEMAIL
|
bit
|
false
|
|
|
|
REQUIRERECAPTCHA
|
bit
|
false
|
|
|
|
CONSENTPARTID
|
int
|
false
|
|
|
|
CONSENTPARTLAYOUTOPTION
|
bit
|
false
|
|
|
|
CHECKOUTTHEMEUSESITEDEFAULT
|
bit
|
false
|
|
|
|
CHECKOUTTHEMEPRIMARYCOLOR
|
nvarchar(100)
|
false
|
|
|
|
CHECKOUTTHEMESECONDARYCOLOR
|
nvarchar(100)
|
false
|
|
|
|
CHECKOUTTHEMEFONTTYPE
|
nvarchar(100)
|
false
|
|
|
|
CHECKOUTWALLETALLCHECKED
|
bit
|
false
|
|
|
|
CHECKOUTWALLETAPPLEPAY
|
bit
|
false
|
|
|
|
CHECKOUTWALLETUSEVISA
|
bit
|
false
|
|
|
|
CHECKOUTWALLETMASTERPASS
|
bit
|
false
|
|
|
