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. |