query
RESULTSET	query   ACCOUNTINGCLAIMID ADJUSTMENTAMOUNT ADMINFEE ARCHIVED ARCHIVEDATE CALCVERSION CHECKISSUED CLAIMAMOUNT CLAIMDATE CLAIMDESCRIPTION CLAIMEDREQUESTID CLAIMID CLAIMINVOICE CLAIMPERIODEND CLAIMPERIODSTART CLAIMREF CLAIMSTATUS CLAIMSTATUSCOMMENT CLAIMSTATUSDATE CLAIMSTATUSUSERID CLAIMTYPE CLEARINGTS CREATEDATE CREATEUSERID CURRENCYCODE CURRENCYCONVERSIONRATE DEDUCTIONDATE DEDUCTIONREF EDI EDIREADY FOREIGNCLAIMAMOUNT HISTORICAL MAPPINGCHECKED MAPPINGCOMPLETED PARTNERID PARTNERPAYABLEID PARTNERTYPE PAYEEID POD PROCESSORUSERID READYTOAUDIT READYTOAUDIT READYTOCLEAR READYTOCLEARMESSAGE RECONCILEDAMOUNT REQUESTID STATUSREASONID UPDATEDATE UPDATEUSERID VARIANCE VERIFICATIONVARIANCE VERIFIEDAMOUNT VOLUMEBASED paymentAmount
CACHED	false
EXECUTIONTIME	3
SQL	select c.claimId, c.claimType, c.claimDate, c.claimStatus, c.claimDescription, c.claimAmount, c.createUserId, c.createDate, c.updateUserId, c.updateDate, c.partnerId, c.partnerType, c.requestId, c.verifiedAmount, c.adjustmentAmount, c.claimStatusComment, c.claimStatusDate, c.claimStatusUserId, c.claimPeriodStart, c.claimPeriodEnd, c.claimInvoice, c.claimRef, c.adminFee, c.statusReasonId, c.payeeId, c.reconciledAmount, c.claimedRequestId, c.partnerPayableId, c.volumeBased, c.checkIssued, c.calcVersion, c.pod, c.verificationVariance, c.readyToAudit, c.clearingTs, c.deductionRef, c.deductionDate, c.processorUserId, c.readyToAudit, c.edi, c.ediReady, coalesce( c.accountingClaimId, 0 ) accountingClaimId, c.readyToClear, c.readyToClearMessage, c.currencyCode, c.currencyConversionRate, c.foreignClaimAmount as foreignClaimAmount, c.historical , c.archived, c.archiveDate , ( c.claimAmount - ( coalesce( c.verifiedAmount, 0.0 ) + coalesce( c.adminFee, 0.0 ))) variance , c.mappingCompleted, c.mappingChecked from tbl_TPM_Claims c with (nolock) where c.ownerId = 1 and c.ownerType = 'MFR' and c.claimId = ?
SQLPARAMETERS	array - Top 1 of 1 rows 1 61579

query
RESULTSET	query   APPROVALSTATUS APPROVEDAMOUNT ASSIGNEDCONTRACTNBR AUDITORNAME AVGSKUCOST AVGSKUCOSTSOURCE AVGSKUCOSTSOURCEDATE CLAIMAMOUNT CLAIMANTCUSTOMERNBR CLAIMANTPARTNERID CLAIMANTPARTNERNAME CLAIMANTPARTNERTYPE CLAIMAUDITCOMMENTS CLAIMDATE CLAIMID CLAIMINVOICE CLAIMITEMCOST CLAIMPRICE CLAIMQUANTITY CLAIMREF CLAIMSTATUS CLAIMSTATUSDATE CLAIMSTATUSDATE CLAIMSTATUSUSERID CLAIMTYPE CLAIMVERIFIEDAMOUNT CLEARED CONTRACTALLOWANCE CONTRACTBASERATE CONTRACTBASERATETYPE CONTRACTDESCRIPTION CONTRACTNBR CONTRACTPARTNERID CONTRACTPARTNERNAME CONTRACTPARTNERTYPE CONTRACTPERCENT CONTRACTPRICE CONTRACTRATEAMT CONTRACTREFERENCE CONTRACTTYPE CONTRACTVERSION CURRENCYCODE CURRENCYCONVERSIONRATE DATECLEARED DEDUCTIONREF EMAIL FIRSTNAME FLAGCOMMENT FLAGGED FSPRO_USERID GENERALLEDGERCODE INCENTIVEPCT ITEMCODE LASTNAME PERCONTRACTAMOUNT PODSTATUS PREPARERNAME PROCESSINGAMOUNT REBATEUNITPRICE RECONCILEDDATE REQUESTEDAMOUNT SKU SKUDESC SKUID STATUSDATE SUBCLAIMCURRENCYCODE SUBCLAIMCURRENCYCONVERSIONRATE TERRITORYID VERIFIEDAMOUNT
CACHED	false
EXECUTIONTIME	0
SQL	select * from qmd_getClaimDetail