Skip to Content
author's profile photo PM Chew
0
PM Chew
Jul 13, 2022 at 01:13 PM

Bank account database table

403 Views Last edit Jul 26, 2022 at 10:44 AM 2 rev

Hi all,

Would like to know if there is a table that could maintain all the information below in one?

  1. Company code
  2. Company name
  3. GL account number
  4. Bank account number & IBAN
  5. bank name/bank code
  6. Currency
  7. Person in-charge
  8. Bank statement format/type
  9. Cash pool account (yes/no)
  10. Comment fields
  11. Account opening date
  12. Account closing date.

Any Ideas or Steps to develop this table are appreciated

Thank you.

Regards,

Chew