How to filter SalesTaxItem by subsidiary internal Id using suiteql

AI generated answer (using internal Slack threads):

To filter SalesTaxItem by subsidiary internal Id using SuiteQL, you can use a JOIN statement to connect the

item

table with the

kititemsubsidiarymap

table. The

kititemsubsidiarymap

table contains the mapping between items and subsidiaries. Here is a sample SuiteQL query:

sql
SELECT * FROM item 
JOIN kititemsubsidiarymap ON item.id = kititemsubsidiarymap.item 
WHERE item.type = 'SalesTaxItem' AND kititemsubsidiarymap.subsidiary = 'subsidiary_internal_id'

Replace

'subsidiary_internal_id'

with the actual internal Id of the subsidiary you are interested in. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******