select requestId from tbl_TPM_Requests where contractId = and ownerId = and ownerType = select distinct pod.skuId from tbl_TPM_ProofOfDelivery pod with (nolock) inner join tbl_TPM_ClaimContracts cc with (nolock) on cc.claimId = pod.claimId and cc.ownerId = pod.ownerId and cc.ownerType = pod.ownerType and cc.contractNbr = pod.contractNbr inner join tbl_TPM_Claims c with (nolock) on c.claimId = cc.claimId and c.ownerId = cc.ownerId and c.ownertype = cc.ownerType where c.ownerId = and c.ownertype = and c.partnerId = and c.partnerType = and c.claimId <> and cc.requestId in ( ) and pod.skuId > 0 and cc.status like 'APPROVED%' and pod.status in ( 'CLAIM', 'CONTRACT' ) select pod.skuId, max( pod.itemQty ) highestItemQty, min( pod.itemQty ) lowestItemQty from tbl_TPM_ProofOfDelivery pod with (nolock) inner join tbl_TPM_ClaimContracts cc with (nolock) on cc.claimId = pod.claimId and cc.ownerId = pod.ownerId and cc.ownerType = pod.ownerType and cc.contractNbr = pod.contractNbr inner join tbl_TPM_Claims c with (nolock) on c.claimId = cc.claimId and c.ownerId = cc.ownerId and c.ownertype = cc.ownerType where c.ownerId = and c.ownertype = and c.partnerId = and c.partnerType = and c.claimId <> and cc.requestId in ( ) and pod.skuId > 0 and cc.status like 'APPROVED%' and pod.status in ( 'CLAIM', 'CONTRACT' ) and pod.operatorId = group by skuId select proofOfDeliveryId from qmd_proofOfDelivery where requestCatalogId = and requestCatalogType = select * from qmd_requestProducts where virtual = 'N' order by priorClaims desc, catalogCode select * from qmd_proofOfdelivery where operatorId = and cdrRecordId = select cs.customerSKU from tbl_PRD_CustomerSKUs cs where cs.customerType in ( 'PDST', 'DST') and cs.ownerId = and cs.fsl_tablecode = and cs.linkType = 'SKU' and cs.skuId = and ( cs.customerId = or cs.customerId = ( select pcdr.cdr_recordId from tbl_CDR_Distributors cdr inner join tbl_DST_Distributors bdst on bdst.dstId = cdr.fsl_dstId inner join tbl_CDR_Distributors pcdr on pcdr.fsl_dstId = bdst.dstParentCo and pcdr.fsl_dstId > 0 and pcdr.ownerId = cdr.ownerId and pcdr.fsl_tablecode = cdr.fsl_tablecode where cdr.ownerId = and cdr.fsl_tablecode = and cdr.cdr_recordId = )) select itemCost, itemQty, contractPrice, rebateUnitPrice, totalRebate, contentId, incentivePct, totalRebate from qmd_proofOfDelivery where requestCatalogId = and requestCatalogType = and manualQualifier is null

Enter all SKU references for the claim. If there are SKUs on the claim that do not exist enter them anyway.
When you tab off the MFR SKU, the Description will fill if it is recognized for this MFR.

If the Distributors SKU is available, please enter it in the box provided.

&##160;	MFR SKU	DST SKU	Description	Paid	Qty	Contract	Rate	Due

update tbl_TPM_ProofOfDelivery set manualQualifier = where proofOfDeliveryId = and ownerId = and ownerType =

E&##160;	#htmleditformat( catalogCode )# #htmleditformat( obsoleteSKU )# #htmleditformat( replacementSKU )#	#htmleditformat( distributorSKU )# na	#htmleditformat( catalogDescription )#	#_minQty# - #_maxQty#
E	onchange="Fse.TPM.skuKeyed( this, #attributes.ownerID#, '#attributes.ownerType#' );" />	&##160;
&##160;	onchange="Fse.TPM.skuKeyed( this, #attributes.ownerID#, '#attributes.ownerType#' );" />	&##160;