SELECT *

FROM Polaris.TransactionTypes

WHERE IsImplemented = 1

Order by TransactionTypeID





SELECT TR.TransactionTypeID, TST.TransactionSubTypeID, 

TST.TransactionSubTypeDescription,

TSTC.TransactionSubTypeCode,

TSTC.TransactionSubTypeCodeDesc

FROM Polaris.TransactionRules TR

JOIN Polaris.TransactionSubTypes TST ON

TST.TransactionSubTypeID = TR.TransactionSubTypeID

LEFT JOIN Polaris.TransactionSubTypeCodes TSTC ON

TR.TransactionSubTypeID = TSTC.TransactionSubTypeID

WHERE TR.TransactionTypeID = 6001 -- checkouts





SELECT TH.TransactionID, TH.TranClientDate,

TD.TransactionSubTypeID, TD.numValue,

TST.TransactionSubTypeDescription,

PC.Name,

TSTC.TransactionSubTypeCodeDesc,

CIR.Barcode

FROM Polaris.TransactionHeaders TH

JOIN Polaris.TransactionDetails TD ON

TH.TransactionID = TD.TransactionID

JOIN Polaris.TransactionSubTypes TST ON

TST.TransactionSubTypeID = TD.TransactionSubTypeID

LEFT JOIN Polaris.TransactionSubTypeCodes TSTC ON

TD.TransactionSubTypeID = TSTC.TransactionSubTypeID

AND TD.numValue = TSTC.TransactionSubTypeCode

LEFT JOIN Polaris.Polaris.Collections PC ON

TD.TransactionSubTypeID = 61 -- collection code transactionsubtype

AND TD.numValue = PC.CollectionID

LEFT JOIN Polaris.Polaris.CircItemRecords CIR ON

TD.TransactionSubTypeID = 38 -- itemrecordID subtype

AND TD.numValue = CIR.ItemRecordID

LEFT JOIN Polaris.Polaris.Organizations PO ON

TD.TransactionSubTypeID = 177 -- patrons assigned branch subtype

AND TD.numValue = PO.OrganizationID

WHERE TH.TransactionID = 436187 -- limiting to as single transaction