PaymentMethodSnapshot
A copy of the payment method that was used in a transaction.
Columns
Name | Type | Description |
bankname | String | The 'bankname' column for the 'paymentmethodsnapshot' table. |
secondtokenid | String | The 'secondtokenid' column for the 'paymentmethodsnapshot' table. |
streetname | String | The 'streetname' column for the 'paymentmethodsnapshot' table. |
accountid | String | The 'accountid' column for the 'paymentmethodsnapshot' table. |
String | The 'email' column for the 'paymentmethodsnapshot' table. | |
mandateid | String | The 'mandateid' column for the 'paymentmethodsnapshot' table. |
paymentmethodid | String | The 'paymentmethodid' column for the 'paymentmethodsnapshot' table. |
updateddate | Datetime | The 'updateddate' column for the 'paymentmethodsnapshot' table. |
achaccountnumbermask | String | The 'achaccountnumbermask' column for the 'paymentmethodsnapshot' table. |
creditcardexpirationmonth | String | The 'creditcardexpirationmonth' column for the 'paymentmethodsnapshot' table. |
creditcardexpirationyear | String | The 'creditcardexpirationyear' column for the 'paymentmethodsnapshot' table. |
bankstreetnumber | String | The 'bankstreetnumber' column for the 'paymentmethodsnapshot' table. |
creditcardholdername | String | The 'creditcardholdername' column for the 'paymentmethodsnapshot' table. |
name | String | The 'name' column for the 'paymentmethodsnapshot' table. |
creditcardaddress2 | String | The 'creditcardaddress2' column for the 'paymentmethodsnapshot' table. |
paymentmethodstatus | String | The 'paymentmethodstatus' column for the 'paymentmethodsnapshot' table. |
companyname | String | The 'companyname' column for the 'paymentmethodsnapshot' table. |
creditcardaddress1 | String | The 'creditcardaddress1' column for the 'paymentmethodsnapshot' table. |
creditcardcity | String | The 'creditcardcity' column for the 'paymentmethodsnapshot' table. |
paymentretrywindow | String | The 'paymentretrywindow' column for the 'paymentmethodsnapshot' table. |
banktransfertype | String | The 'banktransfertype' column for the 'paymentmethodsnapshot' table. |
streetnumber | String | The 'streetnumber' column for the 'paymentmethodsnapshot' table. |
achabacode | String | The 'achabacode' column for the 'paymentmethodsnapshot' table. |
bankbranchcode | String | The 'bankbranchcode' column for the 'paymentmethodsnapshot' table. |
achbankname | String | The 'achbankname' column for the 'paymentmethodsnapshot' table. |
banktransferaccounttype | String | The 'banktransferaccounttype' column for the 'paymentmethodsnapshot' table. |
bankpostalcode | String | The 'bankpostalcode' column for the 'paymentmethodsnapshot' table. |
iban | String | The 'iban' column for the 'paymentmethodsnapshot' table. |
bankstreetname | String | The 'bankstreetname' column for the 'paymentmethodsnapshot' table. |
mandatereceived | String | The 'mandatereceived' column for the 'paymentmethodsnapshot' table. |
bankcheckdigit | String | The 'bankcheckdigit' column for the 'paymentmethodsnapshot' table. |
city | String | The 'city' column for the 'paymentmethodsnapshot' table. |
mandatecreationdate | Date | The 'mandatecreationdate' column for the 'paymentmethodsnapshot' table. |
lastfailedsaletransactiondate | Date | The 'lastfailedsaletransactiondate' column for the 'paymentmethodsnapshot' table. |
existingmandate | String | The 'existingmandate' column for the 'paymentmethodsnapshot' table. |
state | String | The 'state' column for the 'paymentmethodsnapshot' table. |
createddate | Datetime | The 'createddate' column for the 'paymentmethodsnapshot' table. |
country | String | The 'country' column for the 'paymentmethodsnapshot' table. |
creditcardpostalcode | String | The 'creditcardpostalcode' column for the 'paymentmethodsnapshot' table. |
id | String | The 'id' column for the 'paymentmethodsnapshot' table. |
lastname | String | The 'lastname' column for the 'paymentmethodsnapshot' table. |
achaccountname | String | The 'achaccountname' column for the 'paymentmethodsnapshot' table. |
paypalpreapprovalkey | String | The 'paypalpreapprovalkey' column for the 'paymentmethodsnapshot' table. |
creditcardstate | String | The 'creditcardstate' column for the 'paymentmethodsnapshot' table. |
banktransferaccountnumbermask | String | The 'banktransferaccountnumbermask' column for the 'paymentmethodsnapshot' table. |
numconsecutivefailures | String | The 'numconsecutivefailures' column for the 'paymentmethodsnapshot' table. |
paypaltype | String | The 'paypaltype' column for the 'paymentmethodsnapshot' table. |
maxconsecutivepaymentfailures | String | The 'maxconsecutivepaymentfailures' column for the 'paymentmethodsnapshot' table. |
postalcode | String | The 'postalcode' column for the 'paymentmethodsnapshot' table. |
creditcardcountry | String | The 'creditcardcountry' column for the 'paymentmethodsnapshot' table. |
businessidentificationcode | String | The 'businessidentificationcode' column for the 'paymentmethodsnapshot' table. |
mandateupdatedate | Date | The 'mandateupdatedate' column for the 'paymentmethodsnapshot' table. |
creditcardmasknumber | String | The 'creditcardmasknumber' column for the 'paymentmethodsnapshot' table. |
mandatestatus | String | The 'mandatestatus' column for the 'paymentmethodsnapshot' table. |
phone | String | The 'phone' column for the 'paymentmethodsnapshot' table. |
bankidentificationnumber | String | The 'bankidentificationnumber' column for the 'paymentmethodsnapshot' table. |
iscompany | Bool | The 'iscompany' column for the 'paymentmethodsnapshot' table. |
devicesessionid | String | The 'devicesessionid' column for the 'paymentmethodsnapshot' table. |
totalnumberofprocessedpayments | String | The 'totalnumberofprocessedpayments' column for the 'paymentmethodsnapshot' table. |
tokenid | String | The 'tokenid' column for the 'paymentmethodsnapshot' table. |
usedefaultretryrule | Bool | The 'usedefaultretryrule' column for the 'paymentmethodsnapshot' table. |
lasttransactiondatetime | Datetime | The 'lasttransactiondatetime' column for the 'paymentmethodsnapshot' table. |
lasttransactionstatus | String | The 'lasttransactionstatus' column for the 'paymentmethodsnapshot' table. |
bankcity | String | The 'bankcity' column for the 'paymentmethodsnapshot' table. |
firstname | String | The 'firstname' column for the 'paymentmethodsnapshot' table. |
paypalemail | String | The 'paypalemail' column for the 'paymentmethodsnapshot' table. |
bankcode | String | The 'bankcode' column for the 'paymentmethodsnapshot' table. |
creditcardtype | String | The 'creditcardtype' column for the 'paymentmethodsnapshot' table. |
paypalbaid | String | The 'paypalbaid' column for the 'paymentmethodsnapshot' table. |
mandatereason | String | The 'mandatereason' column for the 'paymentmethodsnapshot' table. |
achaccounttype | String | The 'achaccounttype' column for the 'paymentmethodsnapshot' table. |
banktransferaccountname | String | The 'banktransferaccountname' column for the 'paymentmethodsnapshot' table. |
type | String | The 'type' column for the 'paymentmethodsnapshot' table. |
totalnumberoferrorpayments | String | The 'totalnumberoferrorpayments' column for the 'paymentmethodsnapshot' table. |
ipaddress | String | The 'ipaddress' column for the 'paymentmethodsnapshot' table. |
identitynumber | String | The 'identitynumber' column for the 'paymentmethodsnapshot' table. |