1: [dbo].[Claims] table contains this information.
  - The required fileld is: ClientClaimID
  - Mailmerge Field - With the client ref: ClaimDetailsClaimRef - Without the client ref: ClaimDetailsClientClaimID

2: [dbo].[Claims] table contains this information.
  - The required fileld is: AlternativeRef
  - Mailmerge Field - ClaimDetailsAlternativeRef

3: [dbo].[Contacts] table contains this information.
  - Link from [dbo].[Claims].[BankID] to [dbo].[Banks].[ID}
  - Link from [dbo].[Banks].[ContactID} to [dbo].[Contacts].[ID}
  - The required fileld is: CompanyName
  - Mailmerge Field - ClaimDetailsBankName

4: [dbo].[Contacts] table contains this information.
  - Link from [dbo].[Claims].[BranchID] to [dbo].[Banks].[ID}
  - Link from [dbo].[Banks].[ContactID} to [dbo].[Contacts].[ID}
  - The required fileld is: CompanyName
  - Mailmerge Field - ClaimDetailsBranchName

5: This is held in 2 bits.
  a: Claim Type
      [dbo].[MatterTypes] table contains this information.
     - Link from [dbo].[Claims].[MatterTypeID] to [dbo].[MaterTypes].[ID}
     - Mailmerge Field - ClaimDetailsClaimTypeDescription
  b: Rate
      [dbo].[MatterTypeRates] table contains this information.
     - Link from [dbo].[Claims].[MatterTypeRateID] to [dbo].[MaterTypeRates].[ID}
    - Mailmerge Field - ClaimDetailsourCommissionPercentage

6: [dbo].[Claims] table contains this information.
  - The required fileld is: AccountNumber
  - Mailmerge Field - ClaimDetailsAccountNumber

7: [dbo].[Claims] table contains this information.
  - The required fileld is: AccountName
  - Mailmerge Field - ClaimDetailsAccountName

8: [dbo].[Claims] table contains this information.
  - The required fileld is: BankRef
  - Mailmerge Field - ClaimDetailsBankRef

9: [dbo].[Statuses] table contains this information.
  - Link from [dbo].[Claims].[StatusID] to [dbo].[Statuses].[ID}
  - The required fileld is: Description
  - Mailmerge Field - ClaimDetailsStatusDescription

10: [dbo].[Claims] table contains this information.
   - The required fileld is: PurposeOfLoan
   - Mailmerge Field - ClaimDetailsPurposeOfLoan