Appraisal Vendor Merge Fields

Contents

APPRAISAL VENDOR MERGE FIELDS

Mail Merge Field Name	Data Field Name
CONTACT
(For Appraisal Vendor) ADDRESS
Conatct_ReAddr_Barcode	Contact Residential Address Barcode
Contact_ReAddr_CountryName	Contact_ReAddr_CountryName
Contact_ReAddr_Level	Contact Residential Level
Contact_ReAddr_Postcode	Contact Residential Postcode
Contact_ReAddr_PropertyAddress	Contact Residential Property Address
Contact_ReAddr_SiteName	Contact Residential Site Name
Contact_ReAddr_State	Contact Residential State
Contact_ReAddr_StreetAddress	Contact Residential Street Address
Contact_ReAddr_StreetName	Contact Residential Street Name
Contact_ReAddr_StreetNumber	Contact Residential Street Number
Contact_ReAddr_StreetTypeName	Contact Residential Street Type
Contact_ReAddr_SuburbName	Contact Residential Suburb Name
Contact_ReAddr_Unit	Contact Residential Unit

COMPANY
+ADDRESS
Contact_Co_ReAddr_Barcode	Company Contact Residential Address Barcode
Contact_Co_ReAddr_CountryName	Company Contact_ReAddr_CountryName
Contact_Co_ReAddr_Level	Company Contact Residential Level
Contact_Co_ReAddr_Postcode	Company Contact Residential Postcode
Contact_Co_ReAddr_PropertyAddress	Company Contact Residential Property Address
Contact_ Co_ReAddr_SiteName	Company Contact Residential Site Name
Contact_ Co_ReAddr_State	Company Contact Residential State
Contact_ Co_ReAddr_StreetAddress	Company Contact Residential Street Address
Contact_ Co_ReAddr_StreetName	Company Contact Residential Street Name
Contact_ Co_ReAddr_StreetNumber	Company Contact Residential Street Number
Contact_ Co_ReAddr_StreetTypeName	Company Contact Residential Street Type
Contact_ Co_ReAddr_SuburbName	Company Contact Residential Suburb Name
Contact_ Co_ReAddr_Unit	Company Contact Residential Unit

Contact_Co_Attention	Company Contact Attention
Contact_Co_DXNumber	Company Contact DX Number
Contact_Co_Email	Company Contact E-mail Address
Contact_Co_Fax	Company Contact Fax Number
Contact_Co_HomePhone	Company Contact Home Phone Number
Contact_Co_LeadSource	Company Contact Lead Source
Contact_Co_LetterName	Company Contact Letter Name (Salutation)
Contact_Co_MobilePhone	Company Contact Mobile Phone Number
Contact_Co_Name	Company Contact Name

+POSTAL ADDRESS
Contact_Co_Addr_Barcode	Company Contact Postal Address Barcode
Contact_Co_Addr_CountryName	Company Contact Postal Address Country
Contact_Co_Addr_Level	Company Contact Postal Address Level Number
Contact_Co_Addr_Postcode	Company Contact Postal Address Postcode
Contact_Co_Addr_PropertyAddress	Company Contact Postal Full Street Address
Contact_Co_Addr_SiteName	Company Contact Postal Address Site Name
Contact_Co_Addr_State	Company Contact Postal Address State
Contact_Co_Addr_StreetAddress	Company Contact Postal Street Address
Contact_Co_Addr_StreetName	Company Contact Postal Address Street Name
Contact_Co_Addr_StreetNumber	Company Contact Postal Address Street Number
Contact_Co_Addr_StreetTypeName	Company Contact Postal Address Street Type
Contact_Co_Addr_SuburbName	Company Contact Postal Address Suburb
Contact_Co_Addr_Unit	Company Contact Postal Address Unit Number
+PRIMARY SALES PERSON
Contact_Co_SP_Email	Company Contact’s Primary Sales Person E-mail address
Contact_Co_SP_GivenNames	Company Contact’s Primary Sales Person Given Names
Contact_Co_SP_HomePhone	Company Contact’s Primary Sales Person Home Phone
Contact_Co_SP_JobTitle	Company Contact’s Primary Sales Person Job Title (Position)
Contact_Co_SP_LetterName	Company Contact’s Primary Sales Person Letter Name (Salutation)
Contact_Co_SP_MailMergeName	Company Contact’s Primary Sales Person Web Display Name
Contact_Co_SP_MobilePhone	Company Contact’s Primary Sales Person Mobile Phone
Contact_Co_SP_Surname	Company Contact’s Primary Sales Person Surname
Contact_Co_SP_Title	Company Contact’s Primary Sales Person Title
Contact_Co_SP_WebPageAddress	Company Contact’s Primary Sales Person Web Page Address
Contact_Co_SP_WorkPhone	Company Contact’s Primary Sales Person Work Phone
Contact_SP_WorkPhoneExt	Company Contact’s Primary Sales Person Work Phone Extension

Contact_Co_Surname	Company Contact Surname
Contact_Co_TaxFileNumber	Company Contact Tax File Number
Contact_Co_TradingAs	Company Contact Business Trading As Name
Contact_Co_WorkPhone	Company Contact Work Phone Number

+WORK POSTAL ADDRESS
Contact_Co_WkAddr_Barcode	Company Contact Work Address Barcode
Contact_Co_WkAddr_CountryName	Company Contact Work Address Country
Contact_Co_WkAddr_Level	Company Contact Work Address Level Number
Contact_Co_WkAddr_Postcode	Company Contact Work Address Postcode
Contact_Co_WkAddr_PropertyWkAddress	Company Contact Work Full Street Address
Contact_Co_WkAddr_SiteName	Company Contact Work Address Site Name
Contact_Co_WkAddr_State	Company Contact Work Address State
Contact_Co_WkAddr_StreetWkAddress	Company Contact Work Street Address
Contact_Co_WkAddr_StreetName	Company Contact Work Address Street Name
Contact_Co_WkAddr_StreetNumber	Company Contact Work Address Street Number
Contact_Co_WkAddr_StreetTypeName	Company Contact Work Address Street Type
Contact_Co_WkAddr_SuburbName	Company Contact Work Address Suburb
Contact_Co_WkAddr_Unit	Company Contact Work Address Unit Number

DETAILS
Contact_Attention	Contact Attention
Contact_DXNumber	Contact DX Number
Contact_Email	Contact E-mail Address
Contact_Fax	Contact Fax Number
Contact_HomePhone	Contact Home Phone Number
Contact_LeadSource	Contact Lead Source
Contact_LetterName	Contact Letter Name (Salutation)
Contact_MobilePhone	Contact Mobile Phone Number
Contact_Name	Contact Name
Contact_Surname	Contact Surname
Contact_TaxFileNumber	Contact Tax File Number
Contact_TradingAs	Contact Business Trading As Name
Contact_WorkPhone	Contact Work Phone Number

POSTAL ADDRESS
Contact_Addr_Barcode	Contact Postal Address Barcode
Contact_Addr_CountryName	Contact Postal Address Country
Contact_Addr_Level	Contact Postal Address Level Number
Contact_Addr_Postcode	Contact Postal Address Postcode
Contact_Addr_PropertyAddress	Contact Postal Full Street Address
Contact_Addr_SiteName	Contact Postal Address Site Name
Contact_Addr_State	Contact Postal Address State
Contact_Addr_StreetAddress	Contact Postal Street Address
Contact_Addr_StreetName	Contact Postal Address Street Name
Contact_Addr_StreetNumber	Contact Postal Address Street Number
Contact_Addr_StreetTypeName	Contact Postal Address Street Type
Contact_Addr_SuburbName	Contact Postal Address Suburb
Contact_Addr_Unit	Contact Postal Address Unit Number

PRIMARY SALES PERSON
Contact_SP_Email	Contact’s Primary Sales Person E-mail address
Contact_SP_GivenNames	Contact’s Primary Sales Person Given Names
Contact_SP_HomePhone	Contact’s Primary Sales Person Home Phone
Contact_SP_JobTitle	Contact’s Primary Sales Person Job Title (Position)
Contact_SP_LetterName	Contact’s Primary Sales Person Letter Name (Salutation)
Contact_SP_MailMergeName	Contact’s Primary Sales Person Web Display Name
Contact_SP_MobilePhone	Contact’s Primary Sales Person Mobile Phone
Contact_SP_Surname	Contact’s Primary Sales Person Surname
Contact_SP_Title	Contact’s Primary Sales Person Title
Contact_SP_WebPageAddress	Contact’s Primary Sales Person Web Page Address
Contact_SP_WorkPhone	Contact’s Primary Sales Person Work Phone
Contact_SP_WorkPhoneExt	Contact’s Primary Sales Person Work Phone Ext

WORK POSTAL ADDRESS
Contact_WkAddr_Barcode	Contact Work Address Barcode
Contact_WkAddr_CountryName	Contact Work Address Country
Contact_WkAddr_Level	Contact Work Address Level Number
Contact_WkAddr_Postcode	Contact Work Address Postcode
Contact_WkAddr_PropertyWkAddress	Contact Work Full Street Address
Contact_WkAddr_SiteName	Contact Work Address Site Name
Contact_WkAddr_State	Contact Work Address State
Contact_WkAddr_StreetWkAddress	Contact Work Street Address
Contact_WkAddr_StreetName	Contact Work Address Street Name
Contact_WkAddr_StreetNumber	Contact Work Address Street Number
Contact_WkAddr_StreetTypeName	Contact Work Address Street Type
Contact_WkAddr_SuburbName	Contact Work Address Suburb
Contact_WkAddr_Unit	Contact Work Address Unit Number

PROPERTY
ADDRESS
Property_Addr_Barcode	Property Address Barcode
Property_Addr_CountryName	Property Address Country
Property_Addr_Level	Property Address Level Number
Property_Addr_Postcode	Property Address Postcode
Property_Addr_PropertyAddress	Property Full Street Address
Property_Addr_SiteName	Property Address Site Name
Property_Addr_State	Property Address State
Property_Addr_StreetAddress	Property Street Address
Property_Addr_StreetName	Property Address Street Name
Property_Addr_StreetNumber	Property Address Street Number
Property_Addr_StreetTypeName	Property Address Street Type
Property_Addr_SuburbName	Property Address Suburb
Property_Addr_Unit	Property Address Unit Number

BUILDING
Property_Building_AreaFromSqM	Property Building Area From Square Metres
Property_Building_AreaToSqM	Property Building Area To Square Metres
Property_Building_OpenAirParking	Property Open Air Parking
Property_Building_SecuredParking	Property Building Secured Parking
Property_Building_UnderCoverParking	Property Under Cover Parking
Property_Building_YearBuilt	Property Year Built

CURRENT TENANT
+ADDRESS
Property_Tenant_Addr_Barcode	Tenant Postal Barcode
Property_Tenant_Addr_CountryName	Tenant Postal Address Country
Property_Tenant_Addr_Level	Tenant Postal Address Level Number
Property_Tenant_Addr_Postcode	Tenant Postal Address Postcode
Property_Tenant_Addr_ PropertyAddress	Tenant Postal Property Address
Property_Tenant_Addr_SiteName	Tenant Postal Site Name
Property_Tenant_Addr_State	Tenant Postal State
Property_Tenant_Addr_StreetAddress	Tenant Postal Street Address
Property_Tenant_Addr_StreetName	Tenant Postal Street Name
Property_Tenant_Addr_StreetNumber	Tenant Postal Street Number
Property_Tenant_Addr_StreetTypeName	Tenant Postal Street Type e.g. Avenue, Street
Property_Tenant_Addr_SuburbName	Tenant Postal Suburb
Property_Tenant_Addr_Unit	Tenant Postal Unit Number


Property_Tenant_Attention	Tenant Attention
Property_Tenant_Bond	Tenant Bond
Property_Tenant_DXNumber	Tenant DX Number
Property_Tenant_Email	Tenant E-mail
Property_Tenant_Fax	Tenant fax Number
Property_Tenant_HomePhone	Tenant Home Phone Number
Property_Tenant_LeadSource	Tenant Lead Source
Property_Tenant_LeaseEndDate	Tenant Lease End Date
Property_Tenant_LeaseStartDate	Tenant Lease Start Date
Property_Tenant_LeaseTermMonths	Tenant Lease Term Months
Property_Tenant_LetterName	Tenant Letter Name (Saluation)
Property_Tenant_MobilePhone	Tenant Mobile Phone Number

+RE ADDR
Property_Tenant_ReAddr_Barcode	Tenant Residential Barcode
Property_Tenant_ReAddr_CountryName	Tenant Residential Address Country
Property_Tenant_ReAddr_Level	Tenant Residential Address Level Number
Property_Tenant_ReAddr_Postcode	Tenant Residential Address Postcode
Property_Tenant_ReAddr_PropertyAddress	Tenant Residential Property Address
Property_Tenant_ReAddr_SiteName	Tenant Residential Site Name
Property_Tenant_ReAddr_State	Tenant Residential State
Property_Tenant_ReAddr_StreetAddress	Tenant Residential Street Address
Property_Tenant_ReAddr_StreetName	Tenant Residential Street Name
Property_Tenant_ReAddr_StreetNumber	Tenant Residential Street Number
Property_Tenant_ReAddr_StreetTypeName	Tenant Residential Street Type e.g. Avenue, St
Property_Tenant_ReAddr_SuburbName	Tenant Residential Suburb
Property_Tenant_ReAddr_Unit	Tenant Residential Unit Number

+SP
Property_Tenant_SP_Email	Tenant Salesperson E-mail Address
Property_Tenant_SP_GivenNames	Tenant Salesperson Given Name
Property_Tenant_SP_HomePhone	Tenant Salesperson Home Phone Number
Property_Tenant_SP_JobTitle	Tenant Salesperson Job Title
Property_Tenant_SP_LetterName	Tenant Salesperson Letter Name
Property_Tenant_SP_MailMergeName	Tenant Salesperson Mailmerge Name
Property_Tenant_SP_MobilePhone	Tenant Salesperson Mobile Phone Number
Property_Tenant_SP_Surname	Tenant Salesperson Surname
Property_Tenant_SP_Title	Tenant Salesperson Title e.g. Mr, Mrs.
Property_Tenant_SP_WebPageAddress	Tenant Salesperson Web Page Address
Property_Tenant_SP_WorkPhone	Tenant Salesperson Work Phone Number
Property_Tenant_SP_WorkPhoneExt	Tenant Salesperson Work Phone Extension

Property_Tenant_Surname	Tenant Surname
Property_Tenant_TradingAs	Tenant Trading As Name
Property_Tenant_WeeklyRentGSTInclusive	Tenant Weekly Rent Inc GST


+WK ADDRESS
Property_Tenant_WkAddr_Barcode	Tenant Work Barcode
Property_Tenant_WkAddr_CountryName	Tenant Work Address Country
Property_Tenant_WkAddr_Level	Tenant Work Address Level Number
Property_Tenant_WkAddr_Postcode	Tenant Work Address Postcode
Property_Tenant_WkAddr_PropertyAddress	Tenant Work Property Address
Property_Tenant_WkAddr_SiteName	Tenant Work Site Name
Property_Tenant_WkAddr_State	Tenant Work State
Property_Tenant_WkAddr_StreetAddress	Tenant Work Street Address
Property_Tenant_WkAddr_StreetName	Tenant Work Street Name
Property_Tenant_WkAddr_StreetNumber	Tenant Work Street Number
Property_Tenant_WkAddr_StreetTypeName	Tenant Work Street Type e.g. Avenue, St
Property_Tenant_WkAddr_SuburbName	Tenant Work Suburb
Property_Tenant_WkAddr_Unit	Tenant Work Unit Number

Property_Tenant_WorkPhone	Tenant Work Phone Number
Property_Tenant_YearlyRentGSTInclusive	Tenant Yearly Rent Inc GST

DETAILS
Property_Type	Property Type

IMPROVEMENTS
Property_Improv_BathRooms	Property Number of Bathrooms
Property_Improv_Bedrooms	Property Number of Bedrooms
Property_Improv_BuildingDescription	Property Building Description
Property_Improv_BuiltInsNo	Property Number of Built-ins
Property_Improv_CookTop	Property Cook Top
Property_Improv_EnergyRating	Property Energy Rating
Property_Improv_EnsuiteNo	Property Number of Ensuites
Property_Improv_Features	Property Features
Property_Improv_FirePlace	Property Fire Place (Yes/No)
Property_Improv_HotWater	Property Hot Water System
Property_Improv_Intercom	Property Intercom (Yes/No)
Property_Improv_LivingArea	Property Living Area (square meters)
Property_Improv_OpenAirParking	Property Open Air Parking
Property_Improv_PropertyDescription	Property Property Description
Property_Improv_SecuredParking	Property Secured Parking
Property_Improv_Spa	Property Spa
Property_Improv_Study	Property Study (Yes/No)
Property_Improv_SwimmingPool	Property Swimming Pool
Property_Improv_TennisCourt	Property Tennis Court (Yes/No)
Property_Improv_TotalRooms	Property Total Number of Rooms
Property_Improv_UnderCoverParking	Property Under Cover Parking
Property_Improv_Vacuum	Property Ducted Vacuum System (Yes/No)

LAND
Property_Land_Allotment	Property Allotment Number
Property_Land_AreaSqM	Property Land Area Square Metres Note: The system will convert to square metres if a different unit of area measurement has been selected.
Property_Land_Block	Property Land Block
Property_Land_BodyCorpRate	Property Annual Body Corporate Rates
Property_Land_Council	Property City Council
Property_Land_CouncilRate	Property Annual Council Rates
Property_Land_CouncilZoning	Property Council Zoning
Property_Land_Depth	Property Land Depth
Property_Land_Description	Property Land Description
Property_Land_DPNo	Property Deposited Plan Number
Property_Land_Easements	Property Easements
Property_Land_Folio	Property Folio Number
Property_Land_Frontage	Property Land Frontage
Property_Land_Hundred	Property Hundred Number
Property_Land_MainGas	Property Main Gas
Property_Land_MainWater	Property Main Water
Property_Land_Section	Property Section Number
Proeprty_Land_Septic	Property Septic
Property_Land_Sewer	Property Sewer
Property_Land_Stage	Property Land Stage
Property_Land_StrataLotNo	Property Strata Lot Number
Property_Land_StrataPlanNo	Property Strata Plan Number
Property_Land_StrataUnitNo	Property Strata Unit Number
Property_Land_Value	Property Unimproved Land Value
Property_Land_Volume	Property Volume Number
Property_Land_WaterRate	Property Annual Water Rates

PRIMARY SALES PERSON
Property_SP_Email	Property Salesperson E-mail Address
Property_SP_GivenNames	Property Salesperson Given Name
Property_SP_HomePhone	Property Salesperson Home Phone Number
Property_SP_JobTitle	Property Salesperson Job Title
Property_SP_LetterName	Property Salesperson Letter Name
Property_SP_MailMergeName	Property Salesperson Mailmerge Name
Property_SP_MobilePhone	Property Salesperson Mobile Phone Number
Property_SP_Surname	Property Salesperson Surname
Property_SP_Title	Property Salesperson Title e.g. Mr, Mrs.
Property_SP_WebPageAddress	Property Salesperson Web Page Address
Property_SP_WorkPhone	Property Salesperson Work Phone Number
Property_SP_WorkPhoneExt	Property Salesperson Work Phone Extension

APPRAISAL

DETAILS
Appraisal_DateAppraised	Date Appraised
Appraisal_LeadSource	Appraisal - Lead Source
Appraisal_Notes	Appraisal Notes
Appraisal_Number	Appraisal Number
Appraisal_ReasonForSale	Reason for Sale
Appraisal_SuggestedInitialPrice	Appraisal Suggested Initial Price
Appraisal_ValuedPriceFrom	Appraisal Valued Price From
Appraisal_ValuedPriceTo	Appraisal Valued Price To

PRIMARY APPRAISER
Appraisal_Appraiser_Email	Primary Appraiser E-mail Address
Appraisal_Appraiser_GivenNames	Primary Appraiser Given Names
Appraisal_Appraiser_HomePhone	Primary Appraiser Home Phone Number
Appraisal_Appraiser_JobTitle	Primary Appraiser Job Title (Position)
Appraisal_Appraiser_LetterName	Primary Appraiser Letter Name (Salutation)
Appraisal_Appraiser_MailMergeName	Primary Appraiser Web Display Name
Appraisal_Appraiser_MobilePhone	Primary Appraiser Mobile Phone Number
Appraisal_Appraiser_Surname	Primary Appraiser Surname
Appraisal_Appraiser_Title	Primary Appraiser Title
Appraisal_Appraiser_WebPageAddress	Primary Appraiser Web Page Address
Appraisal_Appraiser_WorkPhone	Primary Appraiser Work Phone Number
Appraisal_Appraiser_WorkPhoneExt	Primary Appraiser Work Phone Extension Number

APPRAISAL VENDOR MERGE FIELDS

Mail Merge Field Name

Data Field Name

CONTACT

(For Appraisal Vendor)

ADDRESS

COMPANY

DETAILS

POSTAL ADDRESS

PRIMARY SALES PERSON

WORK POSTAL ADDRESS

PRIMARY APPRAISER