Vendor ACH fields - which table do I use in SLB?

(0) Share

Report

Posted on by Reid Peters

I am trying to create a smartlist of Vendors that return the Bank account & bank transit routing number fields from the "Vendor EFT Bank Maintenance" but I can't figure out what table they are in. Any ideas where I could find that?

Thanks,

Reid

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (0)

Reid Peters 25 on at

Like (1)

Report

My GP partner found it - Company Table SY06000

Was this reply helpful? Yes No
Suggested answer

sueconrod 337 on at

Like (0)

Report

Use Smart List Builder and create a report linking The PM Vendor Master File with the Address Electronic Funds Transfer Master. Then choose your fields. I have the PM Vendor Master File as the main table and the Vendor ID as the key field between the two. This way I didn't wind up with duplicate records. Good luck

Was this reply helpful? Yes No