Mastodon Mastodon Skip to main content

Better Transaction Details

When you pull data from the TransactionDetails table, you get a bunch of numeric codes that are FK relations to other tables in the Transactions and Polaris databases. Unless you've memorized all these numbers and what they mean, it's hard to know what you're looking at. This query allows you to throw a TransactionID into a variable, run that against TransactionDetails, and get human readable information on that transaction. In the case of a numValue that corresponds to a TransactionSubTypeCode, this query will also pull the SubTypeCode description.

-- Declare a variable
DECLARE @TransactionID INT;

-- Put in your TransactionID
SET @TransactionID = 740657;

SELECT
    td.TransactionID,
    td.TransactionSubTypeID,
    tst.TransactionSubTypeDescription,
    td.numValue,
    tstc.TransactionSubTypeCodeDesc

FROM
    PolarisTransactions.Polaris.TransactionDetails td WITH (NOLOCK)

INNER JOIN
    PolarisTransactions.Polaris.TransactionSubTypes tst WITH (NOLOCK)
    ON (tst.TransactionSubTypeID = td.TransactionSubTypeID)

WHERE --Utilize your variable
    td.TransactionID = @TransactionID

ORDER BY
    TransactionSubTypeID ASC