can i get the

billingaddress_key

for a transaction via suiteanalytics dataset?

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that you can't directly get the

billingaddress_key

for a transaction via SuiteAnalytics dataset. However, you can get the billing address details from a transaction search in NetSuite using SuiteScript. Here is an example of how you can do it:

javascript
var searchResult = search.lookupFields({
  type: search.Type.TRANSACTION,
  id: internalId,
  columns : [ 'billaddress' ]
});

In this example,

billaddress

is used to get the billing address from the transaction. If you need individual pieces of the billing address, you can use columns like

billaddress3

or you can use columns from the billing address join

billingaddress.address1

. If you need to access the billing address from a customer, you can pull in

address1

,

city

, etc using search columns for your customer search, and use a filter of

isdefaultbilling = 'T'

. Here is an example of how you can do it:

javascript
const billingAddr = _.find(customer.addressbook, a => a.defaultbilling == true)

In this example,

defaultbilling

is used to find the default billing address from the customer's address book. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******