Skip to content

Where is the Accounting Data Held?

Going down the list - here are the important fields.

They are all found in [dbo].[Claims]

Database Name MailMerge

AmountReclaimTotal ClaimDetailsAmountReclaimTotal\ AmountOffer ClaimDetailsAmountOffer\ AmountOffset ClaimDetailsAmountOffset\ AmountBilledNet ClaimDetailsAmountBilledNet\ AmountBilledVAT ClaimDetailsAmountBilledVAT\ AmountSurcharge ClaimDetailsAmountSurcharge\ AmountBilled ClaimDetailsAmountAmountBilled\ AmountClientReceives ClaimDetailsAmountAmountClientReceives\ AmountReceivedFromClient ClaimDetailsAmountReceivedFromClient\ AmountOwedByClient ClaimDetailsAmountOwedByClient\ InvoiceDateRaised ClaimDetailsInvoiceDateRaised\ PaymentDate ClaimDetailsPaymentDate\