Customer Bank Account Inquiry Database Information

Data for Customer Bank Account Inquiry is stored in multiple tables.

Inquiry Tab Fields

Field

Field Name

Bank Account Number

acct-number in ar-bank-acct

IBAN

iban-code in ar-bank-acct

ABA Routing Number

aba-number in ar-bank-acct

Customers

This grid includes the following columns:

  • ABA Routing Number - aba-number in ar-bank-acct

  • Bank Account Number - acct-number in ar-bank-acct

  • Bank Account Name - acct-name in ar-bank-acct

  • Paying Customer Code - cust-code in custname (using cust-key in custname equal to payer-customer-key in ar-bank-acct)

  • Paying Customer Name - cust-name in custname (using cust-key in custname equal to payer-customer-key in ar-bank-acct)

  • IBAN - iban-code in ar-bank-acct

  • Bank Code - bank-code in ar-bank-acct

  • Bank Name - bank-name in bank-hdr

  • BIC/SWIFT - bic-swift in bank-hdr