What causes this field to be updated to '1'?
*This post is locked for comments
What causes this field to be updated to '1'?
*This post is locked for comments
Hi Liz and Sanjay
The Field TRX Missing (TRXMISNG) from the RM_Batch_History (RM30502) table is a Boolean field.
It gets set to true (1) when the distributions for a batch of transactions are removed. I found references to the field in a number of scripts used for deleting the distributions when transferring to history.
I would say that if you are keeping your history detail then it will not get set to true.
In my opinion, it is worth keeping the detailed history. Hard disk space is relatively cheap now.
David
I am assuming this is the Paid Transaction Removal program. Under what circumstances does the field get updated? I have run the Paid Transaction Removal with my test data and that field was not updated.
Stored Procedure: dbo.rmPTRCreateHistory
André Arnaud de Cal... 291,391 Super User 2024 Season 2
Martin Dráb 230,445 Most Valuable Professional
nmaenpaa 101,156