is there any table that joins products and subsidiary

AI generated answer (using internal Slack threads):

Based on the conversations, it appears that there is a table that joins products (items) and subsidiaries in NetSuite. The table is called

kitItemSubsidiaryMap

. You can query this table using SuiteQL. Here is an example of how you can join the

item

table with the

kitItemSubsidiaryMap

table:

sql
select * from item JOIN kititemsubsidiarymap ON item.id=kititemsubsidiarymap.item WHERE ...

This will return all items and their associated subsidiaries. If you want to get items that belong to a specific subsidiary, you can modify the WHERE clause like this:

sql
select * from item JOIN kititemsubsidiarymap ON item.id=kititemsubsidiarymap.item WHERE subsidiary='A'

This will return all items that belong to subsidiary 'A'. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******