Scenario
User wish to get a transaction record and its related records through ODBC. The sample SQL code is provided below.
Solution
Notes:
[CUST_INTERNAL_ID] - please specify the internal id of the Entity/Customer.
[SO_INTERNAL_ID] - please specify the internal if of the Sales Order record.
[SO_INTERNAL_ID] - please specify the internal if of the Sales Order record.