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
0 Comments
Add your comment