select * from qmd_getClaimDetail

Claim Detail
Date Recieved: #dateformat(qmd_getClaim.claimDate,"mm/dd/yyyy")# Invoice Date: ? Invoice ##: #qmd_getClaim.claimInvoice# Invoice Start \ End: #dateformat(qmd_getClaim.claimPeriodStart,"mm/dd/yyyy")# - #dateformat(qmd_getClaim.claimPeriodEnd,"mm/dd/yyyy")# Claim Period Desc: #qmd_getClaim.claimStatusComment#	Calculated Variance Summary Calculated Type ## of Cases Total Variance Incorrect Allowance Rates: Excluded Products: Unrecognized Products: Product not in Contract : Variance Total
Variance Summary Rebate Amount: #dollarFormat(qmd_getClaim.claimAmount)# Calulated Variance: #dollarFormat( val(qmd_getClaim.claimAmount) - val(qmd_getClaim.verificationVariance) )# Net Claim Amount Due: #dollarFormat( (val(qmd_getClaim.claimAmount) + val(qmd_getClaim.verificationVariance)) - val(qmd_getClaim.claimAmount))# Manual Adjust \ Admin Fees: #dollarFormat( val(qmd_getClaim.adminFee) )# Total Amount Paid:	Administration Fee: Paid: Requested: Total Here:

Excluded
				Rebate Claimed		Contract
Code	Sku	Description	Quantity	Rate	Rebate	Rate	Rebate	Variance
1	22	333	4444	55555	666666	7777777	88888888	999999999
Excluded Total:

Incorrect Allowance Rate
				Rebate Claimed		Contract
Code	Sku	Description	Quantity	Rate	Rebate	Rate	Rebate	Variance
1	22	333	4444	55555	666666	7777777	88888888	999999999
Incorrect Allowance Rate Total:

Unrecognized Product
				Rebate Claimed		Contract
Code	Sku	Description	Quantity	Rate	Rebate	Rate	Rebate	Variance
1	22	333	4444	55555	666666	7777777	88888888	999999999
Unrecognized Product: