{"id":33534,"date":"2021-04-15T17:29:19","date_gmt":"2021-04-15T16:29:19","guid":{"rendered":"https:\/\/support.ospreyapproach.com\/?post_type=pracctice_guide&#038;p=33534"},"modified":"2024-07-30T11:49:36","modified_gmt":"2024-07-30T10:49:36","slug":"where-to-find-osprey-merge-fields","status":"publish","type":"pracctice_guide","link":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/where-to-find-osprey-merge-fields\/","title":{"rendered":"Where to find Osprey Mergefields"},"content":{"rendered":"<div class=\"card\">\n\n    <p class=\"mb-2\"><strong>Who is this guide for?<\/strong><\/p>\n    <p class=\"mb-0\"><i class=\"far fa-user fa-fw mr-2\"><\/i> <strong>Case Management Supervisors<\/strong> and <strong>System Supervisors<\/strong><\/p>    \n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">This guide will help identify the more commonly used mergefields, and which tables the relevant fields are located in<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">You can search within this guide using CTRL + F to bring up your browser&#8217;s search function.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">When creating Word documents or emails in Osprey, you may wish to map a specific merge field to bring through data captured from Osprey.<\/p>\n\n\n\n<p class=\"is-style-info wp-block-paragraph\">Linking any fields from the Contact or Organisation table will result in a pop-up to select a relevant Contact or Organisation prior to generating the correspondence.<\/p>\n\n\n\n<p class=\"h2 wp-block-paragraph\">Standard Osprey merge fields<\/p>\n\n\n\n<figure class=\"wp-block-table alignwide is-style-stripes\"><table><thead><tr><th>Merge field<\/th><th>Notes<\/th><th>Table<\/th><th>Linked by Default<\/th><\/tr><\/thead><tbody><tr><td>Email_Address <\/td><td>Users Email Address <\/td><td>Accuser<\/td><td>No<\/td><\/tr><tr><td>User_ID<\/td><td>Users Username<\/td><td>Accuser<\/td><td>No<\/td><\/tr><tr><td>Branch_Description<\/td><td>Branch Description<\/td><td>Branch<\/td><td>No<\/td><\/tr><tr><td>Area<\/td><td>Branch Address Field<\/td><td>BranchInfo<\/td><td>No<\/td><\/tr><tr><td>County<\/td><td>Branch Address Field<\/td><td>BranchInfo<\/td><td>No<\/td><\/tr><tr><td>DX_No<\/td><td>Branch DX Address<\/td><td>BranchInfo<\/td><td>No<\/td><\/tr><tr><td>E_Mail<\/td><td>Branch Email address<\/td><td>BranchInfo<\/td><td>No<\/td><\/tr><tr><td>Fax_No<\/td><td>Branch Fax Number<\/td><td>BranchInfo<\/td><td>No<\/td><\/tr><tr><td>House<\/td><td>Branch Address Field<\/td><td>BranchInfo<\/td><td>No<\/td><\/tr><tr><td>Phone_No<\/td><td>Branch Phone Number<\/td><td>BranchInfo<\/td><td>No<\/td><\/tr><tr><td>Postal_Town<\/td><td>Branch Address Field<\/td><td>BranchInfo<\/td><td>No<\/td><\/tr><tr><td>Postcode<\/td><td>Branch Address Field<\/td><td>BranchInfo<\/td><td>No<\/td><\/tr><tr><td>Address<\/td><td>Clients Full Postal Address<\/td><td>Calculation<\/td><td>Yes<\/td><\/tr><tr><td>Bill_Address<\/td><td>Clients Billing Postal Address<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>Bill_Date<\/td><td>Date of last bill raised on client ledger<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>Client_Balance<\/td><td>Client Bank Balance on Client Ledger<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>Client_Date<\/td><td>Date of last Client posting on client ledger<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>Daily_Int_At_Issue<\/td><td>Field from the Debt Ledger for use with the focused Debt Recovery workflow.<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>Daily_Int_At_Judgmt<\/td><td>Field from the Debt Ledger for use with the focused Debt Recovery workflow.<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>Daily_Interest_After_Judgmt<\/td><td>Field from the Debt Ledger for use with the focused Debt Recovery workflow.<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>Deposit_Balance<\/td><td>Deposit Bank Balance on Client Ledger<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>Deposit_Date<\/td><td>Date of last Deposit posting on client ledger<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>Disbursements_Balance<\/td><td>Disbursement Balance on Client Ledger<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>Disbursements_Date<\/td><td>Date of last Disbursement posting on client ledger<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>Executive_Name<\/td><td>Matter Supervising Fee Earner Description<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>Fax<\/td><td>Clients Fax Number<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>Fee_Earner_Description<\/td><td>Matter Fee Earner Description<\/td><td>Calculation<\/td><td>Yes<\/td><\/tr><tr><td>Fee_Earner_Email<\/td><td>Matter Fee Earner Email Address<\/td><td>Calculation<\/td><td>Yes<\/td><\/tr><tr><td>Fee_Earner_Mobile<\/td><td>Matter Fee Earner Mobile Number<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>Fee_Earner_Phone<\/td><td>Matter Fee Earner Phone Number<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>First_Invoice_Date<\/td><td>Field from the Debt Ledger for use with the focused Debt Recovery workflow.<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>Fixed_Sum<\/td><td>Field from the Debt Ledger for use with the focused Debt Recovery workflow.<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>Initial_Debt<\/td><td>Field from the Debt Ledger for use with the focused Debt Recovery workflow.<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>Int_At_Issue<\/td><td>Field from the Debt Ledger for use with the focused Debt Recovery workflow.<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>Int_At_Judgmt<\/td><td>Field from the Debt Ledger for use with the focused Debt Recovery workflow.<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>Interest_After_Judgmt<\/td><td>Field from the Debt Ledger for use with the focused Debt Recovery workflow.<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>Irrecoverable_Costs<\/td><td>Field from the Debt Ledger for use with the focused Debt Recovery workflow.<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>Irrecoverable_Fees<\/td><td>Field from the Debt Ledger for use with the focused Debt Recovery workflow.<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>Last_Invoice_Date<\/td><td>Field from the Debt Ledger for use with the focused Debt Recovery workflow.<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>Mobile<\/td><td>Clients Mobile Number<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>Office_Balance<\/td><td>Office Balance on Client Ledger<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>Office_Date<\/td><td>Date of last Office posting on client ledger<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>Phone<\/td><td>Clients Phone Number<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>Recoverable_Costs<\/td><td>Field from the Debt Ledger for use with the focused Debt Recovery workflow.<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>Recoverable_Fees<\/td><td>Field from the Debt Ledger for use with the focused Debt Recovery workflow.<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>Status_Description<\/td><td>Matter Fee Earner Status Descripton<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>Time_Billed<\/td><td>Total of Units Billed<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>Time_Billed_Value<\/td><td>Total Value of Billed Time<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>Total_Credits<\/td><td>Field from the Debt Ledger for use with the focused Debt Recovery workflow.<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>Total_Debt<\/td><td>Field from the Debt Ledger for use with the focused Debt Recovery workflow.<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>Total_Payments<\/td><td>Field from the Debt Ledger for use with the focused Debt Recovery workflow.<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>WIP_Minutes<\/td><td>Total of WIP in Minutes<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>WIP_Value<\/td><td>Total Value of WIP<\/td><td>Calculation<\/td><td>No<\/td><\/tr><tr><td>Area<\/td><td>Clients Address Field<\/td><td>Client<\/td><td>No<\/td><\/tr><tr><td>County<\/td><td>Clients Address Field<\/td><td>Client<\/td><td>No<\/td><\/tr><tr><td>Group_Code<\/td><td>Group Code allocated to the client.<\/td><td>Client<\/td><td>No<\/td><\/tr><tr><td>House<\/td><td>Clients Address Field<\/td><td>Client<\/td><td>No<\/td><\/tr><tr><td>Postal_Town<\/td><td>Clients Address Field<\/td><td>Client<\/td><td>No<\/td><\/tr><tr><td>Postcode<\/td><td>Clients Address Field<\/td><td>Client<\/td><td>No<\/td><\/tr><tr><td>Area<\/td><td>Contact Address Field<\/td><td>Contact<\/td><td>No<\/td><\/tr><tr><td>County<\/td><td>Contact Address Field<\/td><td>Contact<\/td><td>No<\/td><\/tr><tr><td>E_Mail<\/td><td>Contact Email Address <\/td><td>Contact<\/td><td>No<\/td><\/tr><tr><td>Fax_No<\/td><td>Contact Fax Number<\/td><td>Contact<\/td><td>No<\/td><\/tr><tr><td>Forename<\/td><td>Contact Name Field<\/td><td>Contact<\/td><td>No<\/td><\/tr><tr><td>House<\/td><td>Contact Address Field<\/td><td>Contact<\/td><td>No<\/td><\/tr><tr><td>Initials<\/td><td>Contact Name Field<\/td><td>Contact<\/td><td>No<\/td><\/tr><tr><td>Mobile_No<\/td><td>Contact Mobile Number<\/td><td>Contact<\/td><td>No<\/td><\/tr><tr><td>Phone_No<\/td><td>Contact Phone Number<\/td><td>Contact<\/td><td>No<\/td><\/tr><tr><td>Postal_Town<\/td><td>Contact Address Field<\/td><td>Contact<\/td><td>No<\/td><\/tr><tr><td>Postcode<\/td><td>Contact Address Field<\/td><td>Contact<\/td><td>No<\/td><\/tr><tr><td>Surname<\/td><td>Contact Name Field<\/td><td>Contact<\/td><td>No<\/td><\/tr><tr><td>Title<\/td><td>Contact Name Field<\/td><td>Contact<\/td><td>No<\/td><\/tr><tr><td>WWW<\/td><td>Contact Web Address<\/td><td>Contact<\/td><td>No<\/td><\/tr><tr><td>Matter_LMD<\/td><td>Last Date Matter was edited<\/td><td>LastMatterDates<\/td><td>No<\/td><\/tr><tr><td>Time_LMD<\/td><td>Last Date Time was posted<\/td><td>LastMatterDates<\/td><td>No<\/td><\/tr><tr><td>Address_5<\/td><td>Additional Clients Address Field<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>Area_2<\/td><td>Additional Clients Address Field<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>Area_3<\/td><td>Additional Clients Address Field<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>Area_4<\/td><td>Additional Clients Address Field<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>Area_5<\/td><td>Additional Clients Address Field<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>Country_2<\/td><td>Additional Clients Address Field<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>Country_3<\/td><td>Additional Clients Address Field<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>Country_4<\/td><td>Additional Clients Address Field<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>Country_5<\/td><td>Additional Clients Address Field<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>Email_Address_1<\/td><td>Additional Clients Email Address <\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>Email_Address_2<\/td><td>Additional Clients Email Address<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>Email_Address_3<\/td><td>Additional Clients Email Address<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>Email_Address_4<\/td><td>Additional Clients Email Address<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>Email_Address_5<\/td><td>Additional Clients Email Address<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>Forename_1<\/td><td>Additional Clients Name Field<\/td><td>Linkname<\/td><td>Yes<\/td><\/tr><tr><td>Forename_2<\/td><td>Additional Clients Name Field<\/td><td>Linkname<\/td><td>Yes<\/td><\/tr><tr><td>Forename_3<\/td><td>Additional Clients Name Field<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>Forename_4<\/td><td>Additional Clients Name Field<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>Forename_5<\/td><td>Additional Clients Name Field<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>House_2<\/td><td>Additional Clients Address Field<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>House_3<\/td><td>Additional Clients Address Field<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>House_4<\/td><td>Additional Clients Address Field<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>House_5<\/td><td>Additional Clients Address Field<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>Initials_1<\/td><td>Additional Clients Name Field<\/td><td>Linkname<\/td><td>Yes<\/td><\/tr><tr><td>Initials_2<\/td><td>Additional Clients Name Field<\/td><td>Linkname<\/td><td>Yes<\/td><\/tr><tr><td>Initials_3<\/td><td>Additional Clients Name Field<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>Initials_4<\/td><td>Additional Clients Name Field<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>Initials_5<\/td><td>Additional Clients Name Field<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>Postal_Town_2<\/td><td>Additional Clients Address Field<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>Postal_Town_3<\/td><td>Additional Clients Address Field<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>Postal_Town_4<\/td><td>Additional Clients Address Field<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>Postal_Town_5<\/td><td>Additional Clients Address Field<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>Postcode_2<\/td><td>Additional Clients Address Field<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>Postcode_3<\/td><td>Additional Clients Address Field<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>Postcode_4<\/td><td>Additional Clients Address Field<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>Postcode_5<\/td><td>Additional Clients Address Field<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>Surname_1<\/td><td>Additional Clients Name Field<\/td><td>Linkname<\/td><td>Yes<\/td><\/tr><tr><td>Surname_2<\/td><td>Additional Clients Name Field<\/td><td>Linkname<\/td><td>Yes<\/td><\/tr><tr><td>Surname_3<\/td><td>Additional Clients Name Field<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>Surname_4<\/td><td>Additional Clients Name Field<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>Surname_5<\/td><td>Additional Clients Name Field<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>Title_1<\/td><td>Additional Clients Name Field<\/td><td>Linkname<\/td><td>Yes<\/td><\/tr><tr><td>Title_2<\/td><td>Additional Clients Name Field<\/td><td>Linkname<\/td><td>Yes<\/td><\/tr><tr><td>Title_3<\/td><td>Additional Clients Name Field<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>Title_4<\/td><td>Additional Clients Name Field<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>Title_5<\/td><td>Additional Clients Name Field<\/td><td>Linkname<\/td><td>No<\/td><\/tr><tr><td>Archive_Location<\/td><td>Matter Archive Location<\/td><td>Matter<\/td><td>No<\/td><\/tr><tr><td>Archive_Reference<\/td><td>Matter Archive Reference<\/td><td>Matter<\/td><td>No<\/td><\/tr><tr><td>Branch_ID<\/td><td>Matter Branch ID<\/td><td>Matter<\/td><td>No<\/td><\/tr><tr><td>Client_No<\/td><td>Matter Client Number<\/td><td>Matter<\/td><td>No<\/td><\/tr><tr><td>Date_Archived<\/td><td>Date Matter Archived<\/td><td>Matter<\/td><td>No<\/td><\/tr><tr><td>Date_Opened<\/td><td>Date Matter Opened<\/td><td>Matter<\/td><td>No<\/td><\/tr><tr><td>Debtor_Limit<\/td><td>Matter Debtor Limit<\/td><td>Matter<\/td><td>No<\/td><\/tr><tr><td>Department_ID<\/td><td>Matter Department ID<\/td><td>Matter<\/td><td>No<\/td><\/tr><tr><td>Disbursements_Limit<\/td><td>Matter Debtor Limit<\/td><td>Matter<\/td><td>No<\/td><\/tr><tr><td>Email_Address<\/td><td>Matter Email Address<\/td><td>Matter<\/td><td>No<\/td><\/tr><tr><td>Exec_Code<\/td><td>Matter Supervising Fee Earner ID<\/td><td>Matter<\/td><td>No<\/td><\/tr><tr><td>Fee_Earner_ID<\/td><td>Matter Fee Earner ID<\/td><td>Matter<\/td><td>Yes<\/td><\/tr><tr><td>Matter_Description<\/td><td>Matter Description<\/td><td>Matter<\/td><td>Yes<\/td><\/tr><tr><td>Matter_No<\/td><td>Matter  Number<\/td><td>Matter<\/td><td>No<\/td><\/tr><tr><td>Private_Or_LA<\/td><td>Matter Private or Legal Aid<\/td><td>Matter<\/td><td>No<\/td><\/tr><tr><td>Remuneration_Type<\/td><td>Matter Remuneration ID<\/td><td>Matter<\/td><td>No<\/td><\/tr><tr><td>Review_Date<\/td><td>Matter Review Date<\/td><td>Matter<\/td><td>No<\/td><\/tr><tr><td>Review_Period<\/td><td>Matter Review Period<\/td><td>Matter<\/td><td>No<\/td><\/tr><tr><td>Unique_File_No<\/td><td>Matter Unique File Number<\/td><td>Matter<\/td><td>No<\/td><\/tr><tr><td>WIP_Limit<\/td><td>Matter WIP Limit<\/td><td>Matter<\/td><td>No<\/td><\/tr><tr><td>Work_Id<\/td><td>Matter Work Type ID<\/td><td>Matter<\/td><td>No<\/td><\/tr><tr><td>Area<\/td><td>Organisation Address Field<\/td><td>Organisation<\/td><td>No<\/td><\/tr><tr><td>County<\/td><td>Organisation Address Field<\/td><td>Organisation<\/td><td>No<\/td><\/tr><tr><td>DX_No<\/td><td>Organisation DX Address<\/td><td>Organisation<\/td><td>No<\/td><\/tr><tr><td>E_Mail<\/td><td>Organisation Email Address<\/td><td>Organisation<\/td><td>No<\/td><\/tr><tr><td>Fax_No<\/td><td>Organisation Fax Number<\/td><td>Organisation<\/td><td>No<\/td><\/tr><tr><td>House<\/td><td>Organisation Address Field<\/td><td>Organisation<\/td><td>No<\/td><\/tr><tr><td>Organisation_Name<\/td><td>Organisation Description<\/td><td>Organisation<\/td><td>No<\/td><\/tr><tr><td>Phone_No<\/td><td>Organisation Phone Number<\/td><td>Organisation<\/td><td>No<\/td><\/tr><tr><td>Postal_Town<\/td><td>Organisation Address Field<\/td><td>Organisation<\/td><td>No<\/td><\/tr><tr><td>Postcode<\/td><td>Organisation Address Field<\/td><td>Organisation<\/td><td>No<\/td><\/tr><tr><td>WWW<\/td><td>Organisation Web Address <\/td><td>Organisation<\/td><td>No<\/td><\/tr><tr><td>Area<\/td><td>Practice  Address Field<\/td><td>PracticeInfo<\/td><td>No<\/td><\/tr><tr><td>County<\/td><td>Practice Address Field<\/td><td>PracticeInfo<\/td><td>No<\/td><\/tr><tr><td>DX_No<\/td><td>Practice DX Address<\/td><td>PracticeInfo<\/td><td>No<\/td><\/tr><tr><td>E_Mail<\/td><td>Practice Email Address<\/td><td>PracticeInfo<\/td><td>No<\/td><\/tr><tr><td>Fax_No<\/td><td>Practice Fax Number<\/td><td>PracticeInfo<\/td><td>No<\/td><\/tr><tr><td>House<\/td><td>Practice Address Field<\/td><td>PracticeInfo<\/td><td>No<\/td><\/tr><tr><td>Phone_No<\/td><td>Practice Phone Number<\/td><td>PracticeInfo<\/td><td>No<\/td><\/tr><tr><td>Postal_Town<\/td><td>Practice Address Field<\/td><td>PracticeInfo<\/td><td>No<\/td><\/tr><tr><td>Postcode<\/td><td>Practice Address Field<\/td><td>PracticeInfo<\/td><td>No<\/td><\/tr><tr><td>Practice_Id<\/td><td>Practice ID<\/td><td>PracticeInfo<\/td><td>No<\/td><\/tr><tr><td>Practice_Name<\/td><td>Practice Name<\/td><td>PracticeInfo<\/td><td>Yes<\/td><\/tr><tr><td>WWW<\/td><td>Practice Web Address<\/td><td>PracticeInfo<\/td><td>No<\/td><\/tr><tr><td>Area<\/td><td>Associate Address Field<\/td><td>PubAssoc<\/td><td>No<\/td><\/tr><tr><td>Assoc_Id<\/td><td>Associate ID<\/td><td>PubAssoc<\/td><td>No<\/td><\/tr><tr><td>Assoc_Name<\/td><td>Associate Name<\/td><td>PubAssoc<\/td><td>No<\/td><\/tr><tr><td>County<\/td><td>Associate Address Field<\/td><td>PubAssoc<\/td><td>No<\/td><\/tr><tr><td>E_Mail<\/td><td>Associate Email Address <\/td><td>PubAssoc<\/td><td>No<\/td><\/tr><tr><td>GenAssocName<\/td><td>Associate Generated Password<\/td><td>PubAssoc<\/td><td>No<\/td><\/tr><tr><td>House<\/td><td>Associate Address Field<\/td><td>PubAssoc<\/td><td>No<\/td><\/tr><tr><td>Phone_No<\/td><td>Associate Phone Number<\/td><td>PubAssoc<\/td><td>No<\/td><\/tr><tr><td>Postal_Town<\/td><td>Associate Address Field<\/td><td>PubAssoc<\/td><td>No<\/td><\/tr><tr><td>Postcode<\/td><td>Associate Address Field<\/td><td>PubAssoc<\/td><td>No<\/td><\/tr><tr><td>WWW<\/td><td>Associate Web Address<\/td><td>PubAssoc<\/td><td>No<\/td><\/tr><tr><td>Client_Email<\/td><td>Clients Published Email Address<\/td><td>PubData<\/td><td>No<\/td><\/tr><tr><td>Client_No<\/td><td>Clients Published Client Number<\/td><td>PubData<\/td><td>No<\/td><\/tr><tr><td>GenClientName<\/td><td>Clients Generated Password<\/td><td>PubData<\/td><td>No<\/td><\/tr><tr><td>VAT_Number<\/td><td>VAT Number<\/td><td>VATNO<\/td><td>No<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>This guide will help identify the more commonly used mergefields, and which tables the relevant fields are located in You can search within this guide using CTRL + F to bring up your browser&#8217;s search function. When creating Word documents or emails in Osprey, you may wish to map a specific merge field to bring [&hellip;]<\/p>\n","protected":false},"author":22,"featured_media":0,"template":"","categories":[188],"tags":[119],"class_list":["post-33534","pracctice_guide","type-pracctice_guide","status-publish","hentry","category-supervisor-case-management-setup","tag-merge"],"acf":{"display_as_dashboard_announcement":false,"announcement_title":"","announcement_type":"New feature","announcement_link_text":"Learn more","announcement_image":null},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Where to find Osprey Mergefields - Osprey Approach Customer Support &amp; Training | Osprey Academy<\/title>\n<meta name=\"description\" content=\"This guide will help identify the more commonly used mergefields, and which tables the relevant fields are located in\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/where-to-find-osprey-merge-fields\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Where to find Osprey Mergefields - Osprey Approach Customer Support &amp; Training | Osprey Academy\" \/>\n<meta property=\"og:description\" content=\"This guide will help identify the more commonly used mergefields, and which tables the relevant fields are located in\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/where-to-find-osprey-merge-fields\/\" \/>\n<meta property=\"og:site_name\" content=\"Osprey Approach Customer Support &amp; Training | Osprey Academy\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/OspreyApproachUK\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-30T10:49:36+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@OspreyApproach\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/where-to-find-osprey-merge-fields\/\",\"url\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/where-to-find-osprey-merge-fields\/\",\"name\":\"Where to find Osprey Mergefields - Osprey Approach Customer Support &amp; Training | Osprey Academy\",\"isPartOf\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#website\"},\"datePublished\":\"2021-04-15T16:29:19+00:00\",\"dateModified\":\"2024-07-30T10:49:36+00:00\",\"description\":\"This guide will help identify the more commonly used mergefields, and which tables the relevant fields are located in\",\"breadcrumb\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/where-to-find-osprey-merge-fields\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/where-to-find-osprey-merge-fields\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/where-to-find-osprey-merge-fields\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/support.ospreyapproach.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Guides\",\"item\":\"https:\/\/support.ospreyapproach.com\/guides\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Where to find Osprey Mergefields\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#website\",\"url\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/\",\"name\":\"Osprey Approach Customer Support &amp; Training | Osprey Academy\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#organization\",\"name\":\"Osprey Approach Customer Support &amp; Training | Osprey Academy\",\"url\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/10\/Osprey-Logo-200px.png\",\"contentUrl\":\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/10\/Osprey-Logo-200px.png\",\"width\":201,\"height\":61,\"caption\":\"Osprey Approach Customer Support &amp; Training | Osprey Academy\"},\"image\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/OspreyApproachUK\/\",\"https:\/\/x.com\/OspreyApproach\",\"https:\/\/www.linkedin.com\/company\/ospreyapproach\",\"https:\/\/www.youtube.com\/channel\/UClARKUq_3YvaK01GPvI6_qA\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Where to find Osprey Mergefields - Osprey Approach Customer Support &amp; Training | Osprey Academy","description":"This guide will help identify the more commonly used mergefields, and which tables the relevant fields are located in","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/where-to-find-osprey-merge-fields\/","og_locale":"en_GB","og_type":"article","og_title":"Where to find Osprey Mergefields - Osprey Approach Customer Support &amp; Training | Osprey Academy","og_description":"This guide will help identify the more commonly used mergefields, and which tables the relevant fields are located in","og_url":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/where-to-find-osprey-merge-fields\/","og_site_name":"Osprey Approach Customer Support &amp; Training | Osprey Academy","article_publisher":"https:\/\/www.facebook.com\/OspreyApproachUK\/","article_modified_time":"2024-07-30T10:49:36+00:00","twitter_card":"summary_large_image","twitter_site":"@OspreyApproach","twitter_misc":{"Estimated reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/where-to-find-osprey-merge-fields\/","url":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/where-to-find-osprey-merge-fields\/","name":"Where to find Osprey Mergefields - Osprey Approach Customer Support &amp; Training | Osprey Academy","isPartOf":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#website"},"datePublished":"2021-04-15T16:29:19+00:00","dateModified":"2024-07-30T10:49:36+00:00","description":"This guide will help identify the more commonly used mergefields, and which tables the relevant fields are located in","breadcrumb":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/where-to-find-osprey-merge-fields\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/where-to-find-osprey-merge-fields\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/where-to-find-osprey-merge-fields\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/support.ospreyapproach.com\/"},{"@type":"ListItem","position":2,"name":"Guides","item":"https:\/\/support.ospreyapproach.com\/guides\/"},{"@type":"ListItem","position":3,"name":"Where to find Osprey Mergefields"}]},{"@type":"WebSite","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#website","url":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/","name":"Osprey Approach Customer Support &amp; Training | Osprey Academy","description":"","publisher":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#organization","name":"Osprey Approach Customer Support &amp; Training | Osprey Academy","url":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#\/schema\/logo\/image\/","url":"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/10\/Osprey-Logo-200px.png","contentUrl":"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/10\/Osprey-Logo-200px.png","width":201,"height":61,"caption":"Osprey Approach Customer Support &amp; Training | Osprey Academy"},"image":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/OspreyApproachUK\/","https:\/\/x.com\/OspreyApproach","https:\/\/www.linkedin.com\/company\/ospreyapproach","https:\/\/www.youtube.com\/channel\/UClARKUq_3YvaK01GPvI6_qA"]}]}},"_links":{"self":[{"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/pracctice_guide\/33534","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/pracctice_guide"}],"about":[{"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/types\/pracctice_guide"}],"author":[{"embeddable":true,"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/users\/22"}],"version-history":[{"count":3,"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/pracctice_guide\/33534\/revisions"}],"predecessor-version":[{"id":68898,"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/pracctice_guide\/33534\/revisions\/68898"}],"wp:attachment":[{"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/media?parent=33534"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/categories?post=33534"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/tags?post=33534"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}