ODBC Driver for Zuora

Build 24.0.9062

PaymentMethod

A payment method.

Columns

Name Type Description
bankname String The 'bankname' column for the 'paymentmethod' table.
secondtokenid String The 'secondtokenid' column for the 'paymentmethod' table.
streetname String The 'streetname' column for the 'paymentmethod' table.
accountid String The 'accountid' column for the 'paymentmethod' table.
email String The 'email' column for the 'paymentmethod' table.
mandateid String The 'mandateid' column for the 'paymentmethod' table.
updateddate Datetime The 'updateddate' column for the 'paymentmethod' table.
achaccountnumbermask String The 'achaccountnumbermask' column for the 'paymentmethod' table.
creditcardexpirationmonth String The 'creditcardexpirationmonth' column for the 'paymentmethod' table.
creditcardexpirationyear String The 'creditcardexpirationyear' column for the 'paymentmethod' table.
bankstreetnumber String The 'bankstreetnumber' column for the 'paymentmethod' table.
creditcardholdername String The 'creditcardholdername' column for the 'paymentmethod' table.
name String The 'name' column for the 'paymentmethod' table.
creditcardaddress2 String The 'creditcardaddress2' column for the 'paymentmethod' table.
paymentmethodstatus String The 'paymentmethodstatus' column for the 'paymentmethod' table.
companyname String The 'companyname' column for the 'paymentmethod' table.
creditcardaddress1 String The 'creditcardaddress1' column for the 'paymentmethod' table.
creditcardcity String The 'creditcardcity' column for the 'paymentmethod' table.
createdbyid String The 'createdbyid' column for the 'paymentmethod' table.
paymentretrywindow String The 'paymentretrywindow' column for the 'paymentmethod' table.
banktransfertype String The 'banktransfertype' column for the 'paymentmethod' table.
streetnumber String The 'streetnumber' column for the 'paymentmethod' table.
achabacode String The 'achabacode' column for the 'paymentmethod' table.
bankbranchcode String The 'bankbranchcode' column for the 'paymentmethod' table.
achbankname String The 'achbankname' column for the 'paymentmethod' table.
banktransferaccounttype String The 'banktransferaccounttype' column for the 'paymentmethod' table.
bankpostalcode String The 'bankpostalcode' column for the 'paymentmethod' table.
iban String The 'iban' column for the 'paymentmethod' table.
bankstreetname String The 'bankstreetname' column for the 'paymentmethod' table.
mandatereceived String The 'mandatereceived' column for the 'paymentmethod' table.
bankcheckdigit String The 'bankcheckdigit' column for the 'paymentmethod' table.
city String The 'city' column for the 'paymentmethod' table.
mandatecreationdate Date The 'mandatecreationdate' column for the 'paymentmethod' table.
lastfailedsaletransactiondate Date The 'lastfailedsaletransactiondate' column for the 'paymentmethod' table.
active Bool The 'active' column for the 'paymentmethod' table.
existingmandate String The 'existingmandate' column for the 'paymentmethod' table.
achcountry String The 'achcountry' column for the 'paymentmethod' table.
state String The 'state' column for the 'paymentmethod' table.
achaddress1 String The 'achaddress1' column for the 'paymentmethod' table.
createddate Datetime The 'createddate' column for the 'paymentmethod' table.
country String The 'country' column for the 'paymentmethod' table.
creditcardpostalcode String The 'creditcardpostalcode' column for the 'paymentmethod' table.
id String The 'id' column for the 'paymentmethod' table.
lastname String The 'lastname' column for the 'paymentmethod' table.
achaccountname String The 'achaccountname' column for the 'paymentmethod' table.
achstate String The 'achstate' column for the 'paymentmethod' table.
achaddress2 String The 'achaddress2' column for the 'paymentmethod' table.
paypalpreapprovalkey String The 'paypalpreapprovalkey' column for the 'paymentmethod' table.
creditcardstate String The 'creditcardstate' column for the 'paymentmethod' table.
banktransferaccountnumbermask String The 'banktransferaccountnumbermask' column for the 'paymentmethod' table.
numconsecutivefailures String The 'numconsecutivefailures' column for the 'paymentmethod' table.
paypaltype String The 'paypaltype' column for the 'paymentmethod' table.
maxconsecutivepaymentfailures String The 'maxconsecutivepaymentfailures' column for the 'paymentmethod' table.
postalcode String The 'postalcode' column for the 'paymentmethod' table.
creditcardcountry String The 'creditcardcountry' column for the 'paymentmethod' table.
businessidentificationcode String The 'businessidentificationcode' column for the 'paymentmethod' table.
achcity String The 'achcity' column for the 'paymentmethod' table.
achpostalcode String The 'achpostalcode' column for the 'paymentmethod' table.
mandateupdatedate Date The 'mandateupdatedate' column for the 'paymentmethod' table.
creditcardmasknumber String The 'creditcardmasknumber' column for the 'paymentmethod' table.
mandatestatus String The 'mandatestatus' column for the 'paymentmethod' table.
phone String The 'phone' column for the 'paymentmethod' table.
bankidentificationnumber String The 'bankidentificationnumber' column for the 'paymentmethod' table.
iscompany Bool The 'iscompany' column for the 'paymentmethod' table.
devicesessionid String The 'devicesessionid' column for the 'paymentmethod' table.
totalnumberofprocessedpayments String The 'totalnumberofprocessedpayments' column for the 'paymentmethod' table.
tokenid String The 'tokenid' column for the 'paymentmethod' table.
usedefaultretryrule Bool The 'usedefaultretryrule' column for the 'paymentmethod' table.
lasttransactiondatetime Datetime The 'lasttransactiondatetime' column for the 'paymentmethod' table.
lasttransactionstatus String The 'lasttransactionstatus' column for the 'paymentmethod' table.
bankcity String The 'bankcity' column for the 'paymentmethod' table.
firstname String The 'firstname' column for the 'paymentmethod' table.
paypalemail String The 'paypalemail' column for the 'paymentmethod' table.
updatedbyid String The 'updatedbyid' column for the 'paymentmethod' table.
bankcode String The 'bankcode' column for the 'paymentmethod' table.
creditcardtype String The 'creditcardtype' column for the 'paymentmethod' table.
paypalbaid String The 'paypalbaid' column for the 'paymentmethod' table.
mandatereason String The 'mandatereason' column for the 'paymentmethod' table.
achaccounttype String The 'achaccounttype' column for the 'paymentmethod' table.
banktransferaccountname String The 'banktransferaccountname' column for the 'paymentmethod' table.
type String The 'type' column for the 'paymentmethod' table.
totalnumberoferrorpayments String The 'totalnumberoferrorpayments' column for the 'paymentmethod' table.
ipaddress String The 'ipaddress' column for the 'paymentmethod' table.
identitynumber String The 'identitynumber' column for the 'paymentmethod' table.

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