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

Primary Bank Account for Expenses - sql table

edited Mar 14, 2019 3:00PM in Payables, Payments & Cash Management 4 comments

Summary

How to identify the Bank Account marked as 'Primary' in sql

Content

Hi,

Would you be able to indicate the SQL Table / Field corresponding to the "Primary" check mark for Expense Bank Accounts (see attached image).

In the IBY_EXT_BANK_ACCOUNTS table, which stores the Bank Accounts, we cannot find any field or flag indicating which is the PRIMARY Bank Account of a particular employee. 

Background: some employees might have one bank account added but without marking it as Primary. We would like to identify these records to be able to correct the issue. 

Best Regards,

Tudor Hanga

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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