readyToAudit eq "N"

readyToAudit eq "Y"

Checking Prepare 2

 update tbl_TPM_Claims set processorUserId = where claimId = and ownerId = and ownerType = and nullif( processorUserId, 0 ) is null update tbl_TPM_ClaimContracts set auditorUserId = where claimId = and contractnbr = and ownerId = and ownerType = and nullif( auditorUserId, 0 ) is null select * from qmd_claimContract where contractnbr <> '$MISCELLANEOUS' select c.claimId, c.partnerId, c.partnerType, cc.subClaimAmount claimAmount, cc.status as claimStatus, c.claimDate, c.claimRef, cc.contractNbr, r.requestId, r.assignedContractNbr from tbl_TPM_Claims c inner join tbl_TPM_ClaimContracts cc with (nolock) on cc.claimid = c.claimId and cc.ownerId = c.ownerId and cc.ownerType = c.ownerType inner join tbl_TPM_Requests r with (nolock) on r.requestId = cc.requestId and r.ownerId = cc.ownerId and r.ownerType = cc.ownerType inner join tbl_TPM_Contracts ct with (nolock) on ct.contractId = r.contractId and ct.ownerId = r.ownerId and ct.ownerType = r.ownertype where ct.ownerId = and ct.ownertype = and ct.assignedContractNbr = select * from qmd_otherClaims order by masterSort, partnerType, partnerId, claimDate desc

DistributorOperator #htmleditformat( _claimtypeLabel )#
DistributorCustomer: #htmleditformat( qmd_claimPartner.partnerName )#
#htmleditformat(qmd_claim.deductionRef)# #lsDateFormat( qmd_claim.deductionDate, "MM/DD/YYYY" )# #htmleditformat( qmd_claim.claimRef )# #lsDateFormat( qmd_claim.claimDate, "MM/DD/YYYY" )# #htmleditformat( qmd_claim.claimInvoice )# #lscurrencyFormat( qmd_claim.claimAmount )# [#lscurrencyFormat( _foreignClaimAmount )# #qmd_claim.currencyCode#]
--->
Save Request Save Distributors Save Products --->
select min ( coalesce( lastResetVersion, 0 )) lastResetVersion from tbl_TPM_ClaimContracts with (nolock) where ownerId = and ownerType = and claimId = and contractNbr != '$MISCELLANEOUS' select top 1 proofOfDeliveryId from tbl_TPM_ProofOfDelivery with (nolock) where ownerId = and ownerType = and claimId =

Not Implemented Yet!