Hi, does anybody know a table I can use to pull back the company bank details set up?
t
tdietrich
07/15/2021, 6:20 PM
@Diogo I think the table that you want is "financialinstitution," However, I don't think we have access to that via SuiteQL.
d
Diogo
07/15/2021, 7:51 PM
Hey, any other idea's of how I can pull through bank account details i.e. sort code etc for the linked assets.bank
c
CD
07/16/2021, 6:53 AM
What do you need it for? What is your end goal?
d
Diogo
07/16/2021, 10:32 AM
1. Confirm that the bank account number set up in accounting (accounttype.bank) match the bank account details set up when setting up company bank details for electronic bank payments
Diogo
07/19/2021, 12:07 PM
customrecord_2663_format_details is a table I've found