This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I'm trying to understand the tables for the transaction tables, Is there a table for the transaction main line  and a separate table for transaction lines   with forgien key of other table per  line ?

what makes it even more confusing is this simple query  the id  is it "internalidnumber" ,"id" "internalid"
``` let myCustomerQuery = query.create({
        type: query.Type.TRANSACTION,
      });
       let a = myCustomerQuery.createCondition({
         fieldId: "id",
        operator: query.Operator.EQUAL,
        values: id,
      })```

Are you using the Records Catalog?  Go to Setup -&gt; Records Catalog (it's the last thing in the list), if not

maybe idont know what im doing but i dont see that

If you are on the records catalog, there is a tab for all the fields, and a tab for all the joins.  The catalog tells you the field id needed for the joins, you will see transactionLines under the joins.  You can click on transactionLines and see the fields that are available

yes that is where im looking
```custrecord_tranchild_join```

this is my fake sql that im trying to get working
```SELECT *
FROM transaction
INNER JOIN transactionline ON transaction.ID = transactionline.transactionID;```

I dont see transactionline.transactionID in the records catalog, so I am not sure why you think that is the way to join

i dont think that is true that was fake sql

my current code
```et myCustomerQuery = query.create({
        type: query.Type.TRANSACTION,
      });
      myCustomerQuery.join({ fieldId: "transactionLines" });
      let a = myCustomerQuery.createCondition({
        fieldId: "id",
        operator: query.Operator.EQUAL,
        values: id,
      });
    myCustomerQuery.condition = myCustomerQuery.and(a);

      myCustomerQuery.columns = [
        myCustomerQuery.createColumn({ fieldId: "billoflading" }),
        myCustomerQuery.createColumn({
          fieldId: "id",
        }),
      ];
      let resultSet = myCustomerQuery.run();
      log.debug("test", resultSet.results);```

One thing I have seen as a problem here is this set of lines

```myCustomerQuery.join({ fieldId: "transactionLines" });
      let a = myCustomerQuery.createCondition({
        fieldId: "id",
        operator: query.Operator.EQUAL,
        values: id,
      });```
you need to something like this

```let newvar = myCustomerQuery.join({ fieldId: "transactionLines" });
newvar.createCondition({
        fieldId: "id",
        operator: query.Operator.EQUAL,
        values: id,
      });```


it looks like you are trying to create the join using the same name as the query.