When syncing Netsuite data, the Transaction table's child tables like Invoice/Salesorder table are not available in the destination.
For example, the Invoice table as mentioned in the Netsuite documentation is not available in the destination.
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
Transaction types values are present in column
transaction_type in Transaction table definition, you can create a view filtering transaction_type values to get the data related to child table like Invoice/salesOrder.
Sample create view query to get
create view database.schema.transactions_invoice as (select * from database.schema.transactions t where t. transaction_type = '_invoice')