Excel Add-In for Stripe

Build 24.0.9062

PaymentMethodConfigurations

Create, update, and query Payment Method Configurations in Stripe.

Table Specific Information

Select

Server-Side Query Support

The 本製品 uses the Stripe API to filter the results by the following columns and operators while the rest of the filter is executed client-side within the 本製品.

  • Id and Application support the following operator: =.

You can select:

All payment method configurations: 

SELECT * FROM PaymentMethodConfigurations

A payment method configuration by specifying its Id: 

SELECT * FROM PaymentMethodConfigurations WHERE Id = 'pmc_1Q3YXeATXQzBWNrl5zbq9orM'

Payment method configurations associated with an application: 

SELECT * FROM PaymentMethodConfigurations WHERE Application = 'ca_81Gw6dl5WN1GwS1VOKGC3vPUwwY7HvDD'

Insert

Name column is required to create a new payment method configuration: 

INSERT INTO PaymentMethodConfigurations (Name, CardDisplayPreferencePreference, ApplePayLaterDisplayPreferencePreference, PaypalDisplayPreferencePreference, GooglePayDisplayPreferencePreference) VALUES ('homelander', 'on', 'on', 'on', 'on')

Update

To update a payment method configuration, specify the Id: 

UPDATE PaymentMethodConfigurations SET GooglePayDisplayPreferencePreference = 'off' WHERE Id='pmc_1Q3YXeATXQzBWNrl5zbq9orM'

Columns

Name Type ReadOnly References Description
Id [KEY] String True

The Id of the Payment Method Configuration.

Active Boolean False

Whether the configuration can be used for new payments.

Application String True

For child configs, the Connect application associated with the configuration.

IsDefault Boolean True

The default configuration is used whenever a payment method configuration is not specified.

Name String False

The configuration's name.

Parent String False

For child configs, the configuration's parent configuration.

Livemode Boolean True

Has the value true if the object exists in live mode or the value false if the object exists in test mode.

Object String True

String representing the object's type. Objects of the same type share the same value.

AcssDebitAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

AcssDebitDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

AcssDebitDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

AcssDebitDisplayPreferenceValue String True

The effective display preference value.

AffirmAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

AffirmDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

AffirmDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

AffirmDisplayPreferenceValue String True

The effective display preference value.

AfterpayClearpayAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

AfterpayClearpayDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

AfterpayClearpayDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

AfterpayClearpayDisplayPreferenceValue String True

The effective display preference value.

AlipayAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

AlipayDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

AlipayDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

AlipayDisplayPreferenceValue String True

The effective display preference value.

AmazonPayAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

AmazonPayDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

AmazonPayDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

AmazonPayDisplayPreferenceValue String True

The effective display preference value.

ApplePayAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

ApplePayDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

ApplePayDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

ApplePayDisplayPreferenceValue String True

The effective display preference value.

AuBecsDebitAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

AuBecsDebitDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

AuBecsDebitDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

AuBecsDebitDisplayPreferenceValue String True

The effective display preference value.

BacsDebitAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

BacsDebitDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

BacsDebitDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

BacsDebitDisplayPreferenceValue String True

The effective display preference value.

BancontactAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

BancontactDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

BancontactDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

BancontactDisplayPreferenceValue String True

The effective display preference value.

BlikAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

BlikDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

BlikDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

BlikDisplayPreferenceValue String True

The effective display preference value.

BoletoAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

BoletoDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

BoletoDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

BoletoDisplayPreferenceValue String True

The effective display preference value.

CardAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

CardDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

CardDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

CardDisplayPreferenceValue String True

The effective display preference value.

CartesBancairesAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

CartesBancairesDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

CartesBancairesDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

CartesBancairesDisplayPreferenceValue String True

The effective display preference value.

CashappAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

CashappDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

CashappDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

CashappDisplayPreferenceValue String True

The effective display preference value.

CustomerBalanceAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

CustomerBalanceDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

CustomerBalanceDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

CustomerBalanceDisplayPreferenceValue String True

The effective display preference value.

EpsAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

EpsDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

EpsDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

EpsDisplayPreferenceValue String True

The effective display preference value.

FpxAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

FpxDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

FpxDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

FpxDisplayPreferenceValue String True

The effective display preference value.

GiropayAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

GiropayDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

GiropayDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

GiropayDisplayPreferenceValue String True

The effective display preference value.

GooglePayAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

GooglePayDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

GooglePayDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

GooglePayDisplayPreferenceValue String True

The effective display preference value.

GrabpayAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

GrabpayDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

GrabpayDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

GrabpayDisplayPreferenceValue String True

The effective display preference value.

IdealAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

IdealDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

IdealDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

IdealDisplayPreferenceValue String True

The effective display preference value.

JcbAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

JcbDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

JcbDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

JcbDisplayPreferenceValue String True

The effective display preference value.

KlarnaAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

KlarnaDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

KlarnaDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

KlarnaDisplayPreferenceValue String True

The effective display preference value.

KonbiniAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

KonbiniDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

KonbiniDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

KonbiniDisplayPreferenceValue String True

The effective display preference value.

LinkAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

LinkDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

LinkDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

LinkDisplayPreferenceValue String True

The effective display preference value.

MobilepayAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

MobilepayDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

MobilepayDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

MobilepayDisplayPreferenceValue String True

The effective display preference value.

MultibancoAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

MultibancoDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

MultibancoDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

MultibancoDisplayPreferenceValue String True

The effective display preference value.

OxxoAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

OxxoDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

OxxoDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

OxxoDisplayPreferenceValue String True

The effective display preference value.

P24Available Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

P24DisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

P24DisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

P24DisplayPreferenceValue String True

The effective display preference value.

PaynowAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

PaynowDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

PaynowDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

PaynowDisplayPreferenceValue String True

The effective display preference value.

PaypalAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

PaypalDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

PaypalDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

PaypalDisplayPreferenceValue String True

The effective display preference value.

PromptpayAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

PromptpayDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

PromptpayDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

PromptpayDisplayPreferenceValue String True

The effective display preference value.

RevolutPayAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

RevolutPayDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

RevolutPayDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

RevolutPayDisplayPreferenceValue String True

The effective display preference value.

SepaDebitAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

SepaDebitDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

SepaDebitDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

SepaDebitDisplayPreferenceValue String True

The effective display preference value.

SofortAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

SofortDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

SofortDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

SofortDisplayPreferenceValue String True

The effective display preference value.

SwishAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

SwishDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

SwishDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

SwishDisplayPreferenceValue String True

The effective display preference value.

TwintAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

TwintDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

TwintDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

TwintDisplayPreferenceValue String True

The effective display preference value.

UsBankAccountAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

UsBankAccountDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

UsBankAccountDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

UsBankAccountDisplayPreferenceValue String True

The effective display preference value.

WechatPayAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

WechatPayDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

WechatPayDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

WechatPayDisplayPreferenceValue String True

The effective display preference value.

ZipAvailable Boolean True

Whether this payment method may be offered at checkout. True if display_preference is on and the payment method’s capability is active.

ZipDisplayPreferenceOverridable Boolean True

For child configs, whether or not the account’s preference will be observed. If false, the parent configuration’s default is used.

ZipDisplayPreferencePreference String False

The account's display preference.

使用できる値は次のとおりです。none, off, on

ZipDisplayPreferenceValue String True

The effective display preference value.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
ApplePayLaterDisplayPreferencePreference String

The account’s preference for whether or not to display this payment method. Used only in INSERT and UPDATE operations.

使用できる値は次のとおりです。none, off, on

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062