What's new in Customer Journeys?

Connect and learn more!
sql query/data model to get invoice payment information and bank accounts details. — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

sql query/data model to get invoice payment information and bank accounts details.

Accepted answer
393
Views
2
Comments

Summary:

I have an sql query to get Invoice payment information with bank account details. My issue is that some of the bank account details are not appearing for certain invoices. Not sure Why. ?I have attached my script and would appreciate is someone could help. Script attached.

DATA below is missing for some payments but bank account exists.

,ba.bank_number || '-' || ba.branch_number || '-' || ba.bank_account_number || '-' || 

     ba.account_suffix as BANK_ACC_NUMS

     ,ba.Bank_Name

,ba.BRANCH_NUMBER BRANCH_NUM

,ba.Bank_Account_Number BANK_ACC_NUM

Content (please ensure you mask any confidential information):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!