Find reason Code captured for line discount in table " TrxTransactionAudit "

Find reason Code captured for line discount in table " TrxTransactionAudit "

Environment : 

iVend Version 6.6 with SAPB1 10

Query: 

How to find reason Code  captured for line discount in table " TrxTransactionAudit "

Symptoms : 

How to find reason Code  captured for line discount in table " TrxTransactionAudit "

Resolution/Work Around : 

Kindly follow the below query to find the database from table " TrxTransactionAudit "

select * from TrxTransactionAudit where SourceDetailKey in (select TransactionItemKey from TrxTransactionSaleItem where TransactionKey in (select TransactionKey from TrxTransaction where TransactionId='Enter the transaction ID'))
--------------------------------------------------------------------------------------------------
select * from TrxTransactionAudit where SourceDetailKey in (select TransactionItemKey from TrxTransactionSaleItem where TransactionKey in (select TransactionKey from TrxTransaction where TransactionKey='Enter the transaction key'))