Query the Related Records of a Sales Order via ODBC – JCurve Solutions

Scenario

User wish to get a transaction record and its related records through ODBC. The sample SQL code is provided below.

Solution

SELECT DISTINCT
    Administrator.transactions.TRANID 'TRAN ID of the Related Record',
    Administrator.TRANSACTION_LINKS.applied_transaction_id 'Related Record Internal ID',
    Administrator.TRANSACTION_LINKS.original_transaction_id 'Sales Order Internal ID'
FROM
    Administrator.transactions, Administrator.TRANSACTION_LINKS
WHERE
    Administrator.transactions.ENTITY_ID= [CUST_INTERNAL_ID]
    AND
    Administrator.TRANSACTION_LINKS.original_transaction_id = [SO_INTERNAL_ID]
    AND
    Administrator.TRANSACTION_LINKS.applied_transaction_id = Administrator.transactions.TRANSACTION_ID

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.

Scenario

Solution

Related articles