Question
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.
Environment
NetSuite
Answer
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 table.
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 Invoice data.
create view database.schema.transactions_invoice as (select * from database.schema.transactions t where t. transaction_type = '_invoice')