Hello guys, I'm developing with the Netsuite for the first time. The main purpose of developing is integration with in-house WMS system. As a phase 1 for attracting potential customers, my company wants to pulling out orders from Netsuite and update tracking information back. I'm aiming to use SuiteQL for pulling out orders by joining tables "Transaction", "TransactionLine", "Subsidairy" and "InventoryBalance". I can find shipping address information for a customer in each order but I couldn't find any customer "ids" for retrieving their personal record like email address or phone number. Based on my research for few days, I could assume that Transaction.entity would be the id for the Customer table(or record) but this field is mostly filled out with a market place(Target) id. Could anyone advise me for getting customer information? Hello guys, I'm developing with the Netsuite for the first time. The main purpose of developing is integration with in-house WMS system. As a phase 1 for attracting potential customers, my company wants to pulling out orders from Netsuite and update tracking information back. I'm aiming to use SuiteQL for pulling out orders by joining tables "Transaction", "TransactionLine", "Subsidairy" and "InventoryBalance". I can find shipping address information for a customer in each order but I couldn't find any customer "ids" for retrieving their personal record like email address or phone number. Based on my research for few days, I could assume that Transaction.entity would be the id for the Customer table(or record) but this field is mostly filled out with a market place(Target) id. Could anyone advise me for getting customer information? I would very appreciate if you can give any tips or links for item fulfillment (tracking information update).