USP_DATALIST_SHOPPINGCARTSETTINGS

Returns the settings for the Payment 2.0 part

Parameters

Parameter Parameter Type Mode Description
@CONTEXTID uniqueidentifier IN Input parameter indicating the context ID for the data list.

Definition

Copy


          CREATE procedure dbo.USP_DATALIST_SHOPPINGCARTSETTINGS(@CONTEXTID uniqueidentifier)
          as
              set nocount on;

          select 
                  ID,
                  MERCHANTACCOUNTID,
                  CONFIRMATIONBLOCK,
                  EMAILTEMPLATEID,
                  ALLOWPLEDGE,
                  ALLOWDIRECTDEBIT,
            ALLOWCREDITCARD,            
                        DAYSUNTILANONYMOUSUSERCOOKIEEXPIRES,
                        REQUIREFIRSTNAME,
                        REQUIRETITLE,
                        REQUIREPHONE,
                        ALLOWINLINEREGISTRATION,
                        BBPAYTEMPLATEID,
            REGISTERFORDONATION,
            REGISTERFOREVENTREGISTRATION,
            REGISTERFORMEMBERSHIP,
            REGISTERFORSPONSORSHIP,
            REGISTRATIONPAGEID,
            ENABLEFINDERNUMBER,
            FINDERNUMBERIMAGEID,
            FINDERNUMBERHELPTEXT,
            REQUIREMIDDLENAME,
            INCLUDEMIDDLENAME,
            REQUIRECONFIRMEMAIL,
            INCLUDECONFIRMEMAIL,
            REQUIRERECAPTCHA,
            CONSENTPARTID,
            CONSENTPARTLAYOUTOPTION,
            ISNULL(CHECKOUTTHEMEUSESITEDEFAULT, 1),
            CHECKOUTTHEMEPRIMARYCOLOR,
            CHECKOUTTHEMESECONDARYCOLOR,
            CHECKOUTTHEMEFONTTYPE,
            CHECKOUTWALLETALLCHECKED,
            CHECKOUTWALLETAPPLEPAY,
            CHECKOUTWALLETUSEVISA,
            CHECKOUTWALLETMASTERPASS 
          from 
            dbo.SHOPPINGCARTSETTINGS
          where
            ID = @CONTEXTID