in which table is store full vendor address ( adress row 1, row 2, zip code, country, etc.)

AI generated answer (using internal Slack threads):

The full vendor address in NetSuite is stored in the Vendor record, specifically in the Address subrecord. This includes fields such as Address Line 1, Address Line 2, City, State, Zip, and Country. If you want to manipulate the address data, such as removing certain lines or overriding the address, you would need to do this at the Vendor record level. This can be done manually in the UI, or through CSV import if you're dealing with a large number of vendors. However, please note that any changes made to the Vendor record will affect all transactions associated with that vendor. If you need to maintain different addresses for different purposes (e.g., billing vs. shipping), you may need to consider using multiple address books for the vendor. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******