Issue
When syncing NetSuite data, the Transaction table's child tables, such as Invoice and Salesorder, are not available in the destination.
Environment
Connector: NetSuite
Resolution
The Invoice table is not synced through the NetSuite connector because this data can be retrieved in the destination by querying transaction_type column in the Transaction table.
Transaction types values are present in the column, transaction_type, in the Transaction table definition. You can create a view filtering transaction_type values to get the data related to the child tables, such as Invoice and Salesorder.
Please see the below sample query to get Invoice data:
create view database.schema.transactions_invoice as (select * from database.schema.transactions t where t. transaction_type = '_invoice')