What is the best way to update the NUM_1099 (Taxpayer ID) field for thousands of supplier records?
I need to update a lot of NUM_1099 (Taxpayer ID) records. I wanted to use the API "ap_vendor_pub_pkg.update_vendor_public()" for this task but it appears that NUM_1099 is not included as part of the defined "ap_vendor_pub_pkg.r_vendor_rec_type". What is the best approach to update lots of supplier records without having to look them up one-by-one through the application?