FROM

tls-prod-data-lake.<http://looker_pdt.LR|looker_pdt.LR>_BX1NF1741993277677_inventory

AS inventory LEFT JOIN

tls-prod-data-lake.<http://looker_pdt.LR|looker_pdt.LR>_BXW9O1741993314456_transaction_details

AS transaction_details ON inventory.item_id = transaction_details.item_id

I don't think anyone is helping because I don't think these are SuiteQL queries. Based on the column names for those tables I don't think they map to a NS table... I could be wrong, but this looks like a query of a datalake table which potentially had NetSuite source data but actually modified it, or had views setup so the querying will be different than NetSuite. for example, transaction data in NS is mostly on the

transaction

and

transactionLine

tables, but they're two separate tables based on the columns i see here for transaction_details it has columns that would be in both those NetSuite tables, not one single table.