Hi folks,
I have RMS v2 + Hotfix 40, I need to run a report on No Sale transactions, I found the No Sale transactions on the Journal table as TransactionType = 13, but the Journal table does not have a ReasonCodeID field to store the reason code for the no sale transaction, any idea where I can find it?
*This post is locked for comments
Good thought! Didn't think about that! Found table, NonTenderTransaction ;)
from programmers point of view, you can then search for tables where it contains ReasonCodeId column
SELECT c.name AS 'ColumnName'
,t.name AS 'TableName'
FROM sys.columns c
JOIN sys.tables t ON c.object_id = t.object_id
WHERE c.name LIKE '%ReasonCodeId%'
ORDER BY TableName
,ColumnName;
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
