Happy Business Starts Here

Re: Where to find Bank Account field? and other Payment fields

Kate
Zuora Staff

Where to find Bank Account field? and other Payment fields

For bank account and other fields, PaymentApplication table holds these fields. Use DESCRIBE PAYMENTAPPLICATION to find the column you are looking for. Bank Account is cashaccountingcodeid 

1 REPLY 1
sayam
Valued Scholar

Re: Where to find Bank Account field? and other Payment fields

Hi Kate,

For bank account fields like default Payment Method, Payment Gateway, Currency etc., use Payment Object.

 

Example: Select * from Payment Limit 1

In this, 'PAYMENTMETHODID' is default payment Method,  'GATEWAY' is Payment Gateway.
Also you can access these fields using Reporting under Account Data Source.

 

image.pngReporting: 1st StepReporting: 1st StepReporting: 2nd StepReporting: 2nd Step

Tags (1)