...
...
Info |
---|
This guide has been reviewed against our global client base and classed as relevant to all regions |
This article contains a list of merge codes that are not currently available in the Letter Template Editor (LTE)
...
...
output |
---|
Company attention name | <Applicant.CmpAttnName> | John Doe | Negotiator Image | | | Financial Services Permission Given | <Applicant.FSGiven ? "Yes" : "No"> | Yes / No | Has made offers (sales only) | <Referral.Applicant.HasOffers ? "Yes" : "No"> | Yes / No | Most Recent Offer Property Address | <Applicant.LastOffer.Property.Address.FullAddress> | Atlantic Terrace, New Polzeath, PL27 6UG |
Data | Merge Code | Example Output |
---|
Contact Categories | <Applicant.PrimaryContact.CategoryString.Replace("; ", Convert.ToChar(13).ToString())> | Age Range: 20-29, 30-39 Nationality: American Lists all ticked contact categories with each catagory on a seperate line. It is not possible to only list a specific category. |
RequirementsData | Merge Code | Example Output |
---|
List All Requirements | <Applicant.Requirements.ToString()> | House, 1+ Total Bedrooms, Share of freehold, Leasehold, Lease 30+ years, Areas: LEE,DEV | Areas List | <Applicant.Requirements.GetAreaOrAddressInfo()> | Areas: LEE,DEV | Lettings Tenure | <Applicant.Requirements.GetAttributeListValue (Applicant.Requirements.Department.LetTenureList, Applicant.Requirements.LetTenure, "tenure")> | Long Let | Sales Tenure | <Applicant.Requirements.GetAttributeListValue (Applicant.Requirements.Department.TenureList, Applicant.Requirements.Tenure, "tenure")> | Leasehold, Share of freehold |
|
Expand |
---|
|
Landlord statementData | Merge Code | Example Output |
---|
Landlord's 1st property code | <Statement.Landlord.Properties[0].Code> | LDS140001 | Individual item VAT rate | <VatRate.GetRate(StatItem.NomTran.VatCode, StatItem.NomTran.Date)> | 20.00 | Statement Notes - General statement notes | <Statement.Landlord.StatFloatNote> |
| Statement Notes - Per property note | <Statement.Layout == "PP" ? Statement.Landlord.GetPrpLldSettings (StatItem.PrpCode).GetValue("StmNote", "") : ""> |
|
Landlord |
...
& tenant invoicesData | Merge Code | Example Output |
---|
Individual item VAT rate | <VatRate.GetRate(NomTran.VatCode,NomTran.Date)> | 20.00 | Associated Property Address | {script: if (Charge.Property != null && Charge.Property.IsPartial) { Charge.Property.Refresh(); } return (Charge.Property != null && String.IsNullOrEmpty(Charge.Property.Address.FullAddress) ? "Payment Receipt" : Charge.Property.Address.FullAddress);} | 1 Park Court, 40 Park Cross Street, Leeds, LS1 2QH |
Direct |
...
DebitData | Merge code | Example Output |
---|
Tenant - Envelope Name | <DirectDebit.Tenant.EnvelopeName> | Mr J Doe | Tenant - All mailing salutations | <DirectDebit.Tenant.MailingSaltn> | Mr Doe | Tenant - Mailing Address (envelope format) | <DirectDebit.Tenant.MailingAddress.AddressWithReturns> | 1 Park Court 40 Park Cross St Leeds LS1 2QH | Tenant - Bank Account Number | <DirectDebit.Tenant.MainAccount.AccountNum> | 00000000 | Tenant - Sort Code | <DirectDebit.Tenant.MainAccount.SortCode> | 00-00-00 | Direct Debit - Service User Number | <LoggedNegotiator.Config.DirectDebitServiceUserNo> | XXXXXX | Direct Debit - Next collection date | <DirectDebit.NextCollection.ToShortDateString()> | 21/11/2016 | Direct Debit - Amount | <Formatter.FormatPrice(DirectDebit.Amount, 2)> | £333.33 | Direct Debit - Next Collection Date | <DirectDebit.Frequency == 1 ? (DirectDebit.FrequencyType == "M" ? "on or immediately after the " + Formatter.GetFullDateString(DirectDebit.NextCollection, "dd") + " day of each month" : "every " + DirectDebit.FreqTypeName.TrimEnd("s".ToCharArray())) : "every " + DirectDebit.Frequency.ToString() + " " + DirectDebit.FreqTypeName> | on or after the 21 day of the month | Direct Debit - Reference | <DirectDebit.Reference> | XXXXXXXX |
|
Expand |
---|
|
AppointmentsData | Merge Code | Example Output |
---|
Created date | <Entry.Register.ToShortDateString()> | 16/05/2016 | Created by | <Entry.MadeBy.Name> | John Doe | Start time | <Entry.DateTime.ToShortTimeString()> | 13:51 | End time | <Entry.DateTime.AddMinutes (Entry.Duration).ToShortTimeString()> | 14:51 | Appointment type (in lower case) | <Entry.TypeName.ToLower()> | market appraisal | Appointment type, including the word "Appointment" | <Entry.TypeName + (Entry.TypeName.ToLower().Contains("appointment") ? "" : " Appointment")> | Market Appraisal Appointment | Appointment type, including the word "Appointment" (in lower case) | <(Entry.TypeName + (Entry.TypeName.ToLower().Contains("appointment") ? "" : " Appointment")).ToLower()> | Market appraisal appointment | Accompanied? | <Entry.UnAcc ? "Accompanied" : "Unaccompanied"> | Accompanied Unaccompanied | Negotiator Image |
|
| Associated Contact Salutation | <!String.IsNullOrEmpty(Entry.TableCode) ? Entry.AssociatedContact.MailingSaltn : Entry.Property.AllMailingSaltns> | Mr Doe | Property Address (if a property has been added) | <!String.IsNullOrEmpty(Entry.PrpCode) ? Property.Address.FullAddress : ""> | 1 Park Court, 40 Park Cross Street, Leeds, LS1 2QH | Property URL | <String.IsNullOrEmpty(Entry.Property.URL) ? MergeHelper.MergeString(LoggedNegotiator.Config.PrpUrl, Entry.Property) : Entry.Property.URL> | http:// www.example .com /sales/ LDS140003 |
Additional negotiatorsData | Merge Code | Example Output |
---|
List all additional negotiator names | <script: string ret = ""; foreach (Negotiator otherNegotiator in Entry.OtherNegotiators) { ret += otherNegotiator.Name + ", "; } ret = Formatter.CleanList(ret); return ret;> | John Doe, Joe Bloggs | Negotiator 1 - Name | <Entry.OtherNegotiators[0].Name> | John Doe | Negotiator 1 - Title | <Entry.OtherNegotiators[0].Title> | Senior Negotiator | Negotiator 1 - Phone | <Entry.OtherNegotiators[0].GetPhone("b")> | 0113 288 2903 | Negotiator 1 - Email | <Entry.OtherNegotiators[0].GetPhone("e")> | jdoe@ example.com | Negotiator 1 - Address | <Entry.OtherNegotiators[0].Office.Address.FullAddress> | 1 Park Court, 40 Park Cross St, Leeds LS1 2QH | Negotiator 1 - Image file path | <Entry.OtherNegotiators[0].ImgFilePath> | jdoe@ example.com |
|
Expand |
---|
|
Tenancy guarantors (arranging tenancy only)Data | Merge Code | Example Output |
---|
Additional tenant 1 - guarantor name | <Tenancy.GetTenantGuarantors()[1].Contact.Name> | John Doe | Additional tenant 1 - guarantor address | <Tenancy.GetTenantGuarantors()[1].Contact.Address.AddressWithReturns> | 1 The Headrow Leeds LS1 1AA | Additional tenant 1 - guarantor email | <Tenancy.GetTenantGuarantors()[1].Contact.GetPhone("e")> | jdoe@ example.com | Additional tenant 1 - guarantor home | <Tenancy.GetTenantGuarantors()[1].Contact.GetPhone("h")> | 0113 288 2903 | Additional tenant 2 - guarantor name | <Tenancy.GetTenantGuarantors()[2].Contact.Name> | John Doe | Additional tenant 2 - guarantor address | <Tenancy.GetTenantGuarantors()[2].Contact.Address.AddressWithReturns> | 1 The Headrow Leeds LS1 1AA | Additional tenant 2 - guarantor email | <Tenancy.GetTenantGuarantors()[1].Contact.GetPhone("e")> | jdoe@ example.com | Additional tenant 2 - guarantor home | <Tenancy.GetTenantGuarantors()[1].Contact.GetPhone("h")> | 0113 288 2903 |
Tenancy guarantors (current tenancy only)Data | Merge Code | Example Output |
---|
Additional tenant 1 - guarantor name | <Tenancy.GetTenantGuarantors(Tenancy.Tenants[1])[0].Contact.Name> | John Doe | Additional tenant 1 - guarantor address | <Tenancy.GetTenantGuarantors(Tenancy.Tenants[1])[0].Contact.Address.AddressWithReturns> | 1 The Headrow Leeds LS1 1AA | Additional tenant 1 - guarantor email | <Tenancy.GetTenantGuarantors(Tenancy.Tenants[1])[0].Contact.GetPhone("e")> | jdoe@ example.com | Additional tenant 1 - guarantor home | <Tenancy.GetTenantGuarantors(Tenancy.Tenants[1])[0].Contact.GetPhone("h")> | 0113 288 2903 | Additional tenant 2 - guarantor name | <Tenancy.GetTenantGuarantors(Tenancy.Tenants[2])[0].Contact.Name> | John Doe | Additional tenant 2 - guarantor address | <Tenancy.GetTenantGuarantors(Tenancy.Tenants[2])[0].Contact.Address.AddressWithReturns> | 1 The Headrow Leeds LS1 1AA | Additional tenant 2 - guarantor email | <Tenancy.GetTenantGuarantors(Tenancy.Tenants[2])[0].Contact.GetPhone("e")> | jdoe@ example.com | Additional tenant 2 - guarantor home | <Tenancy.GetTenantGuarantors(Tenancy.Tenants[2])[0].Contact.GetPhone("h")> | 0113 288 2903 |
Guarantor screen lettersData | Merge Code | Example Output |
---|
Guarantor name | <Extra.Contact.Name> | John Doe | Guarantor address | <Extra.Contact.Address.AddressWithReturns> | 1 The Headrow Leeds LS1 1AA | Guarantor email | <Extra.Contact.GetPhone("e")> | jdoe@ example.com | Guarantor home phone | <Extra.Contact.GetPhone("h")> | 0113 288 2903 |
|
Expand |
---|
|
Data | Merge Code | Example Output |
---|
Landlord Registration Details | <Property.Lettings.GetLandlordRegistration().ID1> | LL1456789 | Joint Landlord Registration Number | <script: Contact secLandlord =
Property.Lettings.Landlord.
GetJointLandlord(0); if
(secLandlord != null && secLandlord.
IDChecks.Count!= 0 &&
Property.LocalAuthority != null)
{ IDCheck idchk = (from ci in
secLandlord.IDChecks
orderby ci.ID1Expire descending
where ci.IsRegistration
&& ci.Active && ci.RegCode ==
Property.LocalAuthority.Code
select ci).FirstOrDefault();
return idchk != null ? idchk.
ID1 : ""; } return ""; >
| LL1456790 | NOTES | Code Block |
---|
1.To pull though, the Property must exist
2.the property cannot be 'Newly Added'
3.the Property Must have a Local Authority
4.There must be a Landlord Primary Contact
5.ID Check must be a Landlord Registration |
|
|
...
Expand |
---|
|
Data | Merge Code | Example Output |
---|
Sales or lettings | <LoggedNegotiator.Config.CurrentAppMode == "L"> | True / False | Brief Description (with ellipsis) | <Formatter.WordEllipsis(Property.Brief, |
|
...
300)> |
| Price (for advertising) | <LoggedNegotiator.Config.CurrentAppMode == "L" ? (Property.Lettings.RentQual == "PA" ? "Rent on application" : Property.Lettings.RentUIFormattedWithPeriod) : (Property.Sales.PriceQual == "PA" ? Property.Sales.PriceQualName : Property.Sales.PriceQualName + ": " + Property.Sales.PriceRangeFormatted)> | £500 per month / Guide price: £250,000 | Price (for advertising - short) | <LoggedNegotiator.Config.CurrentAppMode == "L" ? (Property.Lettings.RentQual == "PA" ? "Rent on application" : Property.Lettings.RentUIFormattedWithPeriod.Replace ("per month", "PCM").Replace("per week", "PW").Replace ("per annum", "PA")) : (Property.Sales.PriceQual == "PA" ? Property.Sales.PriceQualName : (Property.Sales.PriceQual == "OR" ? "OIRO " : Property.Sales.PriceQual == "OE" ? "OIEO " : Property.Sales.PriceQualName) + ": " + Property.Sales.PriceRangeFormatted)> | £500 PCM / OIRO: £250,000 | Price (for advertising - no sales qualifer) | <LoggedNegotiator.Config.CurrentAppMode == "L" ? (Property.Lettings.RentQual == "PA" ? "Rent on application" : Property.Lettings.RentUIFormattedWithPeriod) : (Property.Sales.PriceQual == "PA" ? Property.Sales.PriceQualName : Property.Sales.PriceRangeFormatted)> | £500 per month / £250,000 | Price Qualifier (with Price Reduction Qualifier) | <LoggedNegotiator.Config.CurrentAppMode == "S" ? ((Property.Sales.Reduced != DateTime.MinValue) && (7 <= (DateTime.Now - Property.Sales.Reduced).Days) ? "NEW PRICE" : Property.Sales.StatusName.Replace (" - Available", "").Replace(" STC", "").Replace (" - Unavailable", "").ToUpper()) : (Property.Lettings.StatusName.Replace (" - Available", "").Replace(" STC", "").Replace (" - Unavailable", "").ToUpper())> | NEW PRICE / FOR SALE | Rent (in words) | <Formatter.PriceWord(Convert.ToInt32 (Math.Floor(Property.Lettings.RentUI)) + " pounds" + (Property.Lettings.RentUI % 1 != 0 ? " and " + Formatter.PriceWord (Convert.ToInt32((Property.Lettings.RentUI - Math.Floor(Property.Lettings.RentUI))*100)) + " pence" : "")> | five hundred and thirty-five pounds | Annual Rent | <Formatter.FormatPrice(Property.Lettings.ARent, 2)> | £57,204.05 | Annual Rent (in words) | <Formatter.PriceWord(Convert.ToInt32(Math.Floor (Property.Lettings.ARent))) + " pounds" + (Property.Lettings.ARent % 1 != 0 ? " and " + Formatter.PriceWord(Convert.ToInt32 ((Property.Lettings.ARent - Math.Floor (Property.Lettings.ARent))*100)) + " pence" : "")> | fifty-seven thousand, two hundred and four pounds and five pence | Sales Price (in words) | <Formatter.PriceWord(Convert.ToInt32(Property. Sales.Price))> pounds | twenty-two thousand, one hundred and one pounds | Offer Price (in words) | <Formatter.PriceWord(Convert.ToInt32(Offer.OfferPrice)) > pounds | twenty-two thousand, one hundred and one pounds | Available From | <Property.AvFrom < DateTime.Now ? "Available Now" : "Available from " + Property.AvFrom.ToShortDateString()> | Available Now / Available from 05/01/2016 | Negotiator Image |
|
| Company Vendor Staff Contact | <Property.PrimaryContact.AsCompany().GetStaffPhone (Property.PrimaryContact.AsCompany().CurrentAttn, "e")> | jbloggs@reapit.com | Vendor Solicitor Bank - Account name | <Property.Sales.Vendor.Solicitor. MainAccount.AccountName> | Lloyds | Vendor Solicitor Bank - Account number | <Property.Sales.Vendor.Solicitor.MainAccount.Account Num> | 01234567 | Vendor Solicitor Bank - Sort Code | <Property.Sales.Vendor.Solicitor.MainAccount. SortCode> | 01-23-45 |
|
...
DevelopmentData | Merge Code | Example Output |
---|
Site phone | <Property.GetSiteMasterPrp().SiteOffice.SitePhone> |
| Open hours | <Property.GetSiteMasterPrp().SiteOffice.OpenHours> |
| Staff name 1 | <Property.GetSiteMasterPrp().SiteOffice.AllStaff[0].ToString()> |
| Staff name 2 | <Property.GetSiteMasterPrp().SiteOffice.AllStaff[1].ToString()> |
|
MarketingData | Merge Code | Example Output |
---|
Sales Board Type | <Property.Sales.SBType == "F" ? "Flag Board" : Property.Sales.SBType == "V" ? "V Board" : "None"> | Flag Board | Sales Board Status | <Formatter.CodesToNames(Property.Sales.SBStat, UserEnvironment.SBStatusList)> | Sold | Sales Board Previous Status | <Formatter.CodesToNames(origPrpExtra.GetExtra("pSBStat", ""), UserEnvironment.Instance.SBStatusList)> | For Sale | Sales Board Date | <Property.Sales.SBDate.ToShortDateString()> | 14/12/2015 | Sales Board Notes | <Property.BoardNotes> |
| Internet URL | <String.IsNullOrEmpty(Property.URL) ? MergeHelper.MergeString(LoggedNegotiator.Config.PrpUrl, Property) : Property.URL> | http://www. example.com /sales/ LDS150001 | URL Text | <Property.UrlText> | Property Link | No Internet Advertising | <Property.NoIntAdv> | True/False | Council Tax Band | <Property.ExtrasField.GetExtra("pCouncilTaxBand", "")> | D | Old Property Reference | <Property.OldCode> | CHLCH_814 | Extra descriptions | <Property.ExtrasField.GetExtra("pLongDesc", "")> |
| Legal Matter Number | <Property.ExtrasField.GetExtra("pMatterNo", "")> | 366853 |
EPC screenData | Merge Code | Example Output |
---|
BER Rating | <Property.ExtrasField.GetExtra("pBERExempt", false) ? "Exempt" : Property.ExtrasField.GetExtra("pBERRating", "To be confirmed")> | C3 | EPC Band | <Property.HipEerBand> | C |
Attributes screenData | Merge Code | Example Output |
---|
Department Code | <Property.Attributes.DepCode> | G | All Attributes | <Property.Attributes.ToString()> | 2 Plots, Leasehold 2 years 10 months, 4 Total Bedrooms [...] | All Attributes (bullet point list) | <Convert.ToChar(8226).ToString()+ " " + Property.Attributes.ToString().Replace(", ", Convert.ToChar(13).ToString() + Convert.ToChar(8226).ToString() + " ")> | |
Attribute columnsData | Merge Code | Example Output |
---|
Attribute column 1 value (Type) | <Property.Attributes.MakeAtts("1")> | House | Attribute column 2 value (Style) | <Property.Attributes.MakeAtts("2")> | End of terrace | Attribute column 3 value (Situation) | <Property.Attributes.MakeAtts("3")> | Garden, Patio | Attribute column 4 value (Special) | <Property.Attributes.MakeAtts("4")> | Outbuilding | Attribute column 5 value (Parking) | <Property.Attributes.MakeAtts("5")> | Garage, Residential Parking | Attribute column 6 value (Age) | <Property.Attributes.MakeAtts("6")> | Period | Attribute column 7 value (Locality) | <Property.Attributes.MakeAtts("7")> | Rural |
Rooms/areaData | Merge Code | Example Output |
---|
Square Metres | <Property.Attributes.Metres> | 300 | Square Metres To | <Property.Attributes.MetresTo> | 400 | Price Per Square Foot (Sales) | <Formatter.FormatPrice(Property.Sales.Price / Property.Attributes.Feet)> | £2,500.00 | Price per square foot (lettings) | <String.Format("{0}/Sq.Ft. {1}", Formatter.FormatPrice(Property.Lettings.RentUI / Property.Attributes.Feet, 2), Property.Lettings.RentPeriodNameShort)> | £25.00/Sq.Ft. p/a | Hectares | <Math.Round(Property.Attributes.Acres * 0.4047, 1)> | 2.6 | Number of units | <Property.Attributes.Plots> | 4 |
Appliances, insurance |
...
& safetyData | Merge Code | Example Output |
---|
Start Date | <Property.Lettings.GetLastCert("GS"). StartDate.ToShortDateString()> | 05/04/2016 | Expiry Date | <Property.Lettings.GetLastCert("GS"). EndDate.ToShortDateString()> | 05/04/2017 | Policy Number | <Property.Lettings.GetLastCert("GS"). PolicyNo> | AA65413 | Supplier | <Property.Lettings.GetLastCert("GS"). Supplier.Name> | British Gas, Leeds | Notes | <Property.Lettings.GetLastCert("GS").Notes> |
|
Financial screen (sales only)Data | Merge Code | Example Output |
---|
Date Instructed - New Instruction | <(DateTime.Now - Property.Sales.ForSDate).Days <= 14 ? "New Instruction" : ""> | New Instruction | Agency Agreement Expiry Weeks | <(Property.Sales.AgExpiry - Property.Sales.ForSDate).Days / 7> | 6 | Joint Agent 1 Name | <Property.Sales.JointAgents[0].Name> | Savills | Joint Agent 1 Address | <Property.Sales.JointAgents[0].Address.AddressWithReturns> | PO Box 227 Rotherham S98 1PD | Joint Agent 2 Name | <Property.Sales.JointAgents[1].Name> | Savills | Joint Agent 2 Address | <Property.Sales.JointAgents[2].Address.AddressWithReturns> | PO Box 227 Rotherham S98 1PD | Estimated Commission VAT | <Formatter.FormatPrice((Convert.ToDecimal(Property.Sales. CommAmount) * LoggedNegotiator.Config.Vat) /100, 2)> | £6,000.00 | Estimated Commission Amount (without VAT) | <Property.Sales.CommAmountFormatted> | £30,000 | Estimated Commission plus VAT | <Formatter.FormatPrice(Convert.ToDecimal(Property.Sales. CommAmount) + (Convert.ToDecimal(Property.Sales. CommAmount) * LoggedNegotiator.Config.Vat) /100, 2)> | £36,000.00 | Estimated Commission plus VAT formatted as % | <(Convert.ToDecimal(Property.Sales.Comm) + Decimal.Multiply((LoggedNegotiator.Config.Vat / 100.00), Convert.ToDecimal(Property.Sales.Comm))).ToString("#.#") + "%"> | 1.6% | Estimated Commission plus VAT formatted as % | <(Convert.ToDecimal(Property.Sales.Comm) + Decimal.Multiply((LoggedNegotiator.Config.Vat / 100.00), Convert.ToDecimal(Property.Sales.Comm))).ToString("#.#") + "%"> | 1.6% | Estimated Commission with decimals from Asking Price (if record is Exchanged it will pull through Exchange Commission) | <Property.Sales.ExchComm != 0 ? Property.Sales.ExchCommFormatted : Property.Sales.Comm != 0.0 ? Formatter.FormatPrice(Math.Round(Convert.ToDecimal(Property.Sales. Comm) / 100.0 * Convert.ToDecimal(Property.Sales.Price), 2),2) : Property.Sales.FixedCommFormatted> | £3249.38 | Vendor Estimated Price | <Formatter.FormatPrice(Convert.ToDouble(Property.ExtrasField.GetExtra ("pVendEst", "")),2)> | £21,000 | Minimum match price | <Property.Sales.MinPriceFormatted> | £400,000 | Maximum match price | <Property.Sales.MaxPriceFormatted> | £500,000 | Matching price range | <String.Format("{0} to {1}", Property.Sales.PriceFormatted, Property.Sales.MaxPriceFormatted)> | £400,000 to £500,000 |
Rent/fee details (lettings)Data | Merge Code | Example Output |
---|
Letting Fee Reducing to % (1) | <Formatter.GetPercentString(Property.Lettings.FeeRedPer1)> | 5% | Letting Fee Reducing to months (1) | <Property.Lettings.FeeRedMonth1> | 6 | Letting Fee Reducing to % (2) | <Formatter.GetPercentString(Property.Lettings.FeeRedPer2)> | 2.5% | Letting Fee Reducing to months (2) | <Property.Lettings.FeeRedMonth2> | 12 | Joint Agent 1 Name | <Property.Lettings.JointAgents[0].Name> | Savills | Joint Agent 1 Address | <Property.Lettings.JointAgents[0].Address.AddressWithReturns> | PO Box 227 Rotherham S98 1PD | Joint Agent 2 Name | <Property.Lettings.JointAgents[1].Name> | Savills | Joint Agent 2 Address | <Property.Lettings.JointAgents[2].Address.AddressWithReturns> | PO Box 227 Rotherham S98 1PD | Deposit required | <LoggedNegotiator.Config.CurrentAppMode == "L" ? Property.Lettings.DepositSumFormatted : ""> | £500.00 |
RoomsData | Merge Codes | Example Output |
---|
Accommodation Summary - comma separated | <Property.AccSum.Trim().Replace(Convert.ToChar(13).ToString(), ", ")> | 21 houses, 716 acres, Two main boat houses, A harbour, Bantham Ham, Bantham Beach, | Accommodation Summary - bullet point separated inline | <Property.AccSum.Trim().Replace(Convert.ToChar(13).ToString(), " • ")> | 21 houses • 716 acres • Two main boat houses • A harbour • Bantham Ham • Bantham Beach | Accommodation Summary - with bullet point on each line | <"• " + Property.AccSum.Trim().Replace(Convert.ToChar(13).ToString(), Convert.ToChar(13).ToString() + "• ")> | • 21 houses • 716 acres • Two main boat houses • A harbour • Bantham Ham • Bantham Beach |
KeysKeys held office name | <UserEnvironment.Offices[Property.KeyOffCode].Name> | Leeds |
---|
Keys held office address | <UserEnvironment.Offices[Property.KeyOffCode]. Address.AddressWithReturns> | 1 The Headrow Leeds LS1 1AA | Key Number | <Property.KeyNo> | 123 | Viewing arrangements | <Property.Viewing> | Lorem ipsum dolor sit amet, consectetur adipiscing elit. | Keys out with | <Property.KeyWith> | John Doe |
|
Expand |
---|
title | Property Pictures / Virtual Tour |
---|
|
Details (brochures |
...
& window cards)Data | Merge Code | Example Output |
|
---|
Virtual Tour | <Property.Vtour> <Property.Vtour2> |
|
| Main Photo | <Picture> | <Picture Hires> |
| Photo 2 | <Picture 1> | <Picture 1 Hires> |
| Photo 3 | <Picture 2> | <Picture 2 Hires> |
| Floorplan 1 | <Floorplan> | <Floorplan Hires> |
| Floorplan 2 | <Floorplan 1> | <Floorplan 1 Hires> | If there is more than 2 floors, use these merge codes as <Floorplan> will not work. Use this instead: <"{Image " + Property.GetPictures("FP")[0].URL + "}">, <"{Image " + Property.GetPictures("FP")[1].URL + "}"> and continue with numbering system if there are more floors. | Map 1 | <Map> | <Map Hires> |
| Map 2 | <Map 1> | <Map Hires 1> |
| EPC | <EPC> | N/A | High resolution EPCs are not stored | Map or Photo | <"{Image " + (0 < Property.GetPictures("MA").Count ? Property.GetPictures("MA")[0] : Property.GetPictures("PH")[3]).URL + "}"> |
| Print a map if one has been added to the property, else print photo 3. Change the number 3 to a photo which has not been used within the template so the image is not duplicated. |
|
Expand |
---|
|
Data | Merge Code | Example Output |
---|
Offer Estimated Commission Amount | <Formatter.FormatPrice(Offer.OfferPrice / 100 * Property.Sales.Comm)> | £3,200.00 | Offer Estimated Commission Amount In Words | Formatter.PriceWord(Offer.OfferPrice / 100 * Property.Sales.Comm, false, true) | Fourteen Thousand, Eight Hundred and Eighty Pounds | Vendor Solicitor Staff Member Attention | <Offer.VendorSolicitor.Attention> | John Doe | Vendor Solicitor Staff Member Salutation | <Offer.VendorSolicitor.MailingSaltn> | Mr Doe | Vendor Solicitor Staff Member Phone | <Offer.VendorSolicitor.GetStaffPhone (Offer.Property.Sales.Vendor.SolAttn, "b")> | 01234 567 890 | Vendor Solicitor Staff Member Email | <Offer.VendorSolicitor.GetStaffPhone (Offer.Property.Sales.Vendor.SolAttn, "e")> | jdoe@ example.com | Buyer Solicitor Staff Member Attention | <Offer.BuyerSolicitor.Attention> | John Doe | Buyer Solicitor Staff Member Salutation | <Offer.BuyerSolicitor.MailingSaltn> | Mr Doe | Buyer Solicitor Staff Member Phone | <Offer.BuyerSolicitor.GetStaffPhone (Offer.SolAttn, "b")> | 01234 567 890 | Buyer Solicitor Staff Member Email | <Offer.BuyerSolicitor.GetStaffPhone (Offer.SolAttn, "e")> | jdoe@ example.com | Current Offer Name (Applicant) | <Property.CurrentOffer.AllNames> | Joe Bloggs | Exchange date without ordinal number (i.e. th/nd/rd/st) | <Property.Sales.ExchDate.ToString ("dd MMMM yyyy")> | 20 April 2018 |
Buyer |
...
& sales detailsData | Merge Code | Example Output |
---|
Exchange Commission VAT | <Formatter.FormatPrice(((Convert.ToDecimal (Property.Sales.ExchComm) * LoggedNegotiator.Config.Vat) /100), 2)> | £200.00 | Exchange Commission Percentage | <Math.Round(100.00 * (Property.Sales.ExchComm / Property.Sales.ExchPrice), 3).ToString("#.###") + "%"> | 1.5% |
Data | Merge Code | Example Output |
---|
Company Staff Member Attention | <Property.PrimaryContactAttnName> | John Doe | Landlord specific details | See Landlord section on this page |
| Vendor Company Staff Member Attention Contact | <Property.PrimaryContact.AsCompany(). GetStaffPhone(Property.PrimaryContact.AsCompany().CurrentAttn, "e")> | John Doe |
|
Expand |
---|
title | System Configuration |
---|
|
Data | Merge Code | Example Output |
---|
Company Code | <LoggedNegotiator.Config.CompanyCode> | RPT | VAT Number | <LoggedNegotiator.Config.VatNumber> | 999 9999 73 | Enable Australia Features | <LoggedNegotiator.Config.Australia> | TRUE / FALSE |
|
Expand |
---|
|
Data | Merge Code | Example Output |
---|
Total Rent Amount | <Formatter.FormatPrice(Tenancy.GetTotalRent (Tenancy.FrDate, Tenancy.ToDate), 2)> | £9,785.00 | Annual Rent | <Formatter.FormatPrice(Tenancy.ARent, 2)> | £57,204.05 | Annual rent in words | <Formatter.PriceWord(Convert.ToInt32(Math.Floor (Tenancy.ARent))) + " pounds" + (Tenancy.ARent % 1 != 0 ? " and " + Formatter.PriceWord(Convert.ToInt32 ((Tenancy.ARent - Math.Floor(Tenancy.ARent))*100)) + " pence" : "")> | fifty-seven thousand, two hundred and four pounds and five pence | Monthly rent in words | <Formatter.PriceWord(Tenancy.CurrentDetails.MRent, false, false)> | six thousand, nine hundred and eleven pounds and sixty-seven pence | Arrears Amount | <Formatter.FormatPrice(Tenancy.GetRentArrears(), 2)> | £719.67 | All Tenant's Email Addresses | <String.Join("", Tenancy.GetTenantPhoneDetails("e", true))> | tenant1@ reapit.com; tenant2@ reapit.com; tenant3@ reapit.com; | Number of tenants | <Tenancy.Tenants.Count> | 5 | Tenancy Length in years, months and days | Code Block |
---|
<script:
int years = 0, months = 0, days = 0;
while (Tenancy.FrDate.AddMonths(months + 1) |
Code Block |
---|
<= Tenancy.ToDate.AddDays(1))
{
months++;
}
years = months / 12;
months = months % 12;
days = (Tenancy.ToDate.AddDays(1) - |
Code Block |
---|
Tenancy.FrDate.AddYears(years).AddMonths |
Code Block |
---|
(months)).Days;
return ((years != 0 ? years + " year" + |
Code Block |
---|
(years == 1 ? "" : "s") + ", " : "") +
(months != 0 ? months + " month" + |
Code Block |
---|
(months == 1 ? "" : "s") + ", " : "") +
(days != 0 ? days + " day" + (days == |
Code Block |
---|
1 ? "" : "s") : "")).Trim(", ".ToCharArray());
>
|
| 1 year, 2 months , 5 days | Tenancy Finished Reason
| <Tenancy.FinishReasonName> | Conditions of contract not met | Multiple Tenant Names and contact details (removes carriage returns when N/A) | <script:
string ret = ""; foreach (Contact con in Tenancy.Tenants) { Code Block |
---|
ret += "Name: ";
ret += con.Name;
ret += "\t";
ret += "Mobile: ";
ret += con.GetPhone("m");
ret += "\t";
ret += "Email: ";
ret += con.GetPhone("e");
ret += "\r\n";
|
} return ret.Trim();>
| Name: Mr Tenant Mobile: 0777888444 Email: support@ reapit.com | Last Inspection | <Tenancy.LastInsp> |
| Next Inspection Due By | <Tenancy.NextInspDueBy.ToShortDateString()> | 01/01/2019 |
Financial & |
...
renewalsData | Merge Code | Example Output |
---|
Deposit Held By | <Formatter.CodesToNames(Tenancy.DpstHeld, UserEnvironment.dpstHeldList)> | Us - Stakeholder | Deposit | Tenancy.DpstType == "GU" ? "Guarantee" : Tenancy.DpstType == "FS" ? Tenancy.DpstSumFormatted : String.Format("{0} {1} rent", Tenancy.DpstTimes, Tenancy.DpstType == "WE" ? "Weeks" : "Months") | 2 Weeks rent | Deposit plus rent | Formatter.FormatPrice(Tenancy.CurrentDetails.RentUIC + Tenancy.DpstSumC, 2) |
| Extension total months | <Math.Round((Tenancy.LastExtension.ToDate - Tenancy.LastExtension.FrDate).TotalDays / 365.25 * 12)> | 13 | Total Commission | <Formatter.FormatPrice(Convert.ToDecimal(Tenancy.Comm) / 100.0 * (Tenancy.GetTotalRent(Tenancy.FrDate, Tenancy.ToDate)), 2)> | £6000.00 | Total Commission VAT | <Formatter.FormatPrice(LoggedNegotiator.Config.Vat /100.0 * (Convert.ToDecimal(Tenancy.Comm) / 100 * (Tenancy.GetTotalRent(Tenancy.FrDate, Tenancy.ToDate))), 2)> | £1200.00 | Total Commission inc. VAT | <Formatter.FormatPrice((Convert.ToDecimal(Tenancy.Comm) / 100.0 * (Tenancy.GetTotalRent(Tenancy.FrDate, Tenancy.ToDate))) + (LoggedNegotiator.Config.Vat /100.0 * (Convert.ToDecimal(Tenancy.Comm) / 100 * (Tenancy.GetTotalRent(Tenancy.FrDate, Tenancy.ToDate)))), 2)> | £7200.00 | Letting fee frequency | <Tenancy.CommCollName> | Monthly | Management fee frequency | <Tenancy.CommManCollName> | Monthly |
AgreementsData | Merge Code |
---|
Renewal Option | <Tenancy.GetRenewMergeText()> | Break Clauses | <Tenancy.GetBreakMergeText()> | Break Clause (Specific Clause) | <script: string ret = ""; foreach (TenCheck chk in Tenancy.BreakClauses) { if (chk.Source.BreakDesc.Contains("Rent Clause")) { ret += chk.MergeText.GetFullText(chk, chk.Tenancy) + "\r\n\r\n"; } } return ret.Trim();> | Allowed / Disallowed | <Tenancy.GetAllowMergeText()> | Responsibilities | <Tenancy.GetRespMergeText()> |
RenewalsData | Merge Code | Example Output |
---|
Renewal length in months | <Math.Round(Math.Floor((Renewal.toDate - Renewal.frDate).TotalDays) / 365.25 * 12.0)> | 14 | Landlord's Break Clauses | <script: string ret = ""; foreach (TenCheck chk in Renewal.TenancyTerms.BreakClauses) { if (chk.Status== "L") { ret += chk.Source.BreakDesc + "\r\n" + chk.MergeText.GetFullText(chk, Renewal.Tenancy, rptObj) + "\r\n\r\n"; } } return ret.Trim();> |
| Tenant's Break Clauses | <script: string ret = ""; foreach (TenCheck chk in Renewal.TenancyTerms.BreakClauses) { if (chk.Status== "T") { ret += chk.Source.BreakDesc + "\r\n" + chk.MergeText.GetFullText(chk, Renewal.Tenancy, rptObj) + "\r\n\r\n"; } } return ret.Trim();> |
|
|
...
...
...
...
...
...
<%WorkOrd.OrdDate%> | Chase Days | <%WorkOrd.ChaseDays%> | Charge To | <%WorkOrd.ChargeTo%> | Commission | <%WorkOrd.ExtrasField.GetSetExtra("GET", "ktSuppComm", null, false, false)%> | Completed | <%WorkOrd.Complete%> | Description/Title | <%WorkOrd.Descr%> | Estate Unit | <%WorkOrd.EstateUnit.NameUI%> | Estimate | <%WorkOrd.Estimate%> | Full property address | <%WorkOrd.PrpAddress.FullAddress%> | Gross Amount | <%WorkOrd.Total%> | Key Contact | <%WorkOrd.Property.Negotiator.Name%> | Landlord email | <%WorkOrd.Property.Lettings.Landlord.PrimaryContact.Email%> | Landlord Full Address | <%WorkOrd.Property.Lettings.Landlord.PrimaryContact.Address.FullAddress%> | Landlord Initials | <%WorkOrd.PrimaryContact.Initials%> | Landlord name | <%WorkOrd.Property.Lettings.Landlord.Name%> | Landlord phone | <%WorkOrd.Property.Lettings.Landlord.PrimaryContact.Phone%> | Landlord Short Address | <%WorkOrd.Property.Lettings.Landlord.PrimaryContact.Address.GridAddress%> | Logged | <%WorkOrd.Register%> | Manager code | <%WorkOrd.NegCode%> | Manager name | <%WorkOrd.Negotiator.Name%> | Net Amount | <%WorkOrd.TotalNet%> | Notes | <%WorkOrd.Notes%> | Office | <%WorkOrd.property.lettings.office.name%> | Quote Summary | <%WorkOrd.QuoteSummary%> | Reference | <%WorkOrd.Code%> | Reported by | <%WorkOrd.RepBy%> | Required by | <%WorkOrd.ReqBy%> | Short property address | <%WorkOrd.PrpAddress.GridAddress%> | Status | <%WorkOrd.StatusName%> | Contractor/Supplier Name | <%WorkOrd.Supplier%> | Contractor/Supplier Full Address | <%WorkOrd.Supplier.Address.FullAddress%> | Contractor/Supplier Short Address | <%WorkOrd.Supplier.Address.GridAddress%> | Contractor/Supplier telephone/e-mail | <%WorkOrd.Supplier.Phone%> | Ten End Date | <%WorkOrd.Tenancy.ToDate%> | Type | <%WorkOrd.TypeName%> | VAT Amount | <%WorkOrd.TotalVat%> |
|
Related articles
Filter by label (Content by label) |
---|
showLabels | false |
---|
max | 5 |
---|
spaces | com.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@a45 |
---|
sort | modified |
---|
showSpace | false |
---|
|
...
reverse | true |
---|
type | page |
---|
cql | label in ( "templates" , "letters" ) and type = "page" and space = "RW" |
---|
labels | lte merge codes template |
---|
|
...
...
This article contains a list of merge codes that are not currently available in the Letter Template Editor (LTE) |