Explain the address tables in NetSuite2 datasource when it comes to customer addresses and transaction addresses

AI generated answer (using internal Slack threads):

In NetSuite, customer addresses and transaction addresses are handled through address subrecords. These subrecords are associated with the customer record and can be accessed and modified through SuiteScript. For customer addresses, they are stored in the customer's address book. When a new transaction (like a sales order) is created for a customer, NetSuite will by default populate the 'ship to' and 'bill to' addresses with the default addresses from the customer's address book. However, these can be overridden on the transaction record itself. If the addresses are not already in the customer's address book, they can be added and then mapped to the Shipping Address fields on the Sales Order. To modify an address on a transaction in SuiteScript 1.0, you can use the

nlapiEditSubrecord('shippingaddress')

function to get the address subrecord. After making changes, don't forget to commit the changes. There can be situations where the billing address on a transaction might appear incorrect or overridden. This could be due to a contact associated with the customer having a role of "Primary Contact" with a different address. NetSuite might copy this address to the Billing Address on all transactions. Removing the "Primary Contact" role from this contact should resolve the issue. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******