CustomerProfileDetails
Query Customer Profile Details for Authorize.net merchant account.
テーブル固有の情報
CustomerProfileId は、WHERE 句でサポートされている唯一使用可能なカラムで、CustomerProfileDetails から結果を取得する必要があります。CustomerProfileId は、(=)演算子またはIN 演算子と一緒に使用できます。
SELECT * FROM CustomerProfileDetails WHERE CustomerProfileId = '1915622429'
SELECT * FROM CustomerProfileDetails WHERE CustomerProfileId IN ('1915622429', '3215422449')
Columns
| Name | Type | Statistic | Description |
| MerchantCustomerId | String | Merchant-assigned customer reference ID. Must be unique among all of the customer IDs stored with profiles to be able to retrieve. | |
| CustomerProfileId [KEY] | String | Payment gateway-assigned ID associated with the customer profile.This output is present only for successful requests. | |
| String | Email address associated with the customer profile. | ||
| Description | String | Description of the customer or customer profile. Required only when no values for merchantCustomerId and email are submitted. | |
| FirstName | String | First name associated with customer's billing address. | |
| LastName | String | Last name associated with customer's billing address. | |
| Company | String | Company associated with customer's billing address. | |
| Address | String | Customer's billing address. | |
| City | String | City of customer's billing address. | |
| State | String | State of customer's billing address. | |
| Zip | String | The postal code of customer's billing address. | |
| Country | String | Country of customer's billing address. | |
| PhoneNumber | String | Phone number associated with customer's billing address. | |
| FaxNumber | String | Fax number associated with customer's billing address. | |
| DefaultPaymentProfile | Boolean | Indicates whether this profile is the default.If a customer profile does not have a default payment profile, then the defaultPaymentProfile element is not displayed in the getCustomerProfileResponse.If a profile has multiple payment profiles, the default profile returns defaultPaymentProfile set to true. Non-default profiles do not return defaultPaymentProfile. | |
| CustomerPaymentProfileId | String | Payment gateway assigned ID associated with the customer payment profile. | |
| CardNumber | String | The customer's masked credit card number. All sensitive payment information in the output is masked. | |
| ExpirationDate | String | The expiration date for the customer's credit card. | |
| CardType | String | Type of credit card. Possible values: Visa, Mastercard, AmericanExpress, Discover, JCB, or DinersClub. | |
| IssuerNumber | String | Unique identifier (IIN) for the issuer of the card. This element is only returned if you set the includeIssuerInfo field to true in the request. | |
| IsPaymentToken | Boolean | Indicates whether the payment method used an encrypted token. | |
| AccountType | String | The type of bank account used for the eCheck.net transaction. Possible values: checking, savings, or businessChecking. | |
| RoutingNumber | String | The ABA routing number. | |
| AccountNumber | String | The bank account number. | |
| NameOnAccount | String | Name of the person who holds the bank account. | |
| EcheckType | String | The type of eCheck transaction. Do not use TEL, ARC, or BOC for recurring charges. Possible values:PPD, WEB, or CCD. | |
| BankName | String | The name of the bank. |