Refer to the sample query below:
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
[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.
No comments:
Post a Comment