Template Merge Fields

Last updated 4 days ago

This guide provides a comprehensive list of all merge fields available in ParcVu, separated by record type

Owner Fields

Merge Field

Description

Required Source

Medium

OWNER_NO

Owner number

None

Email, Letter, SMS

NAME

Owner name

None

Email, Letter, SMS

FIRST_NAME

First name

None

Email, Letter, SMS

LAST_NAME

Last name

None

Email, Letter, SMS

TITLE_DESC

Title description

None

Email, Letter, SMS

SALUTATION

Salutation

None

Email, Letter, SMS

ADD_1 to ADD_4

Owner address lines 1 to 4

None

Email, Letter

POST_CODE

Owner postcode

None

Email, Letter

EMAIL

Email address

None

Email, Letter

NUMDAY

Work phone number

None

Email, Letter

NUMEVE

Home phone number

None

Email, Letter

NUMMOB

Mobile phone number

None

Email, Letter, SMS

FULL_OWNER_ADDRESS_LIST

Multi-line formatted owner address

OLP Form

Email, Letter

BANK_ACCT_NO

Owner's bank account number

OLP Form

Email, Letter

BANK_SORT_CODE

Owner's bank sort code

OLP Form

Email, Letter

Prospect & Interest Fields

Merge Field

Description

Required Source

Medium

APPOINT_DT_START

Next appointment date

None

Email, Letter, SMS

NAME

Salesman name (Interest context)

None

Email, Letter, SMS

ProspectName

Full name of the prospect

Interest Summary

Email, Letter, SMS

ProspectSalutation

Prospect formal greeting

Interest Summary

Email, Letter, SMS

ProspectAddress1-4

Prospect address lines

Interest Summary

Email, Letter

ProspectPostCode

Prospect postcode

Interest Summary

Email, Letter

ProspectEmail

Prospect email address

Interest Summary

Email, Letter

ProspectSource

Lead source description

Interest Summary

Email, Letter

InterestLeadDate

Date the lead was created

Interest Summary

Email, Letter

InterestSalesman

Name of assigned salesman

Interest Summary

Email, Letter

Account & Finance Fields

Merge Field

Description

Required Source

Medium

ACCOUNT_NO

Account number

None

Email, Letter, SMS

CURRENT_RENT_LEDGER_BALANCE

Current rent ledger balance

None

Email, Letter

CURRENT_BOOKING_LEDGER_BALANCE

Current booking ledger balance

None

Email, Letter

INSURANCE_TYPE

Insurance type

None

Email, Letter

INSURANCE_PREMIUM

Insurance premium

None

Email, Letter

UNALLOCATED_CASH

Cash not assigned to an invoice

Account Summary

Email, Letter

DAY30 / DAY60 / DAY90

Aged debt amounts

Account Summary

Email, Letter

TOTAL_BALANCE

Total outstanding balance

Account Summary

Email, Letter, SMS

PAYMENT_LINK

URL for online payment

Account Summary

Email, SMS

PAY_BY_LINK

Invoice-specific payment link

None

Email

TOTAL_PAYABLE

Total amount due including finance

OLP Form

Email, Letter

COMPANY_NAME

Finance company name

OLP Form

Email, Letter

Holiday Home Fields

Merge Field

Description

Required Source

Medium

VAN_STOCK_NO

Van stock number

None

Email, Letter, SMS

MAKE

Van make

None

Email, Letter, SMS

MODEL

Van model

None

Email, Letter, SMS

SERIAL_NO

Serial number

None

Email, Letter

YEAR_MADE

Year manufactured

OLP Form

Email, Letter

PITCH_NO

Pitch number

None

Email, Letter, SMS

PITCH_DESC

Pitch description

None

Email, Letter

KEY_NO

Key number

None

Email, Letter

NO_BERTHS

Number of berths

None

Email, Letter

Booking Fields

Looking for fields relating to the customer, such as name and address? You’ll find these under the Owner Fields section!

Field Label

Description

Required Source

Medium

BOOKING_REF

Unique booking reference number

None

Email, Letter, SMS

ON_SITE_FROM_DT

Arrival date (combined date/time field)

None

Email, Letter, SMS

ON_SITE_TO_DT

Departure date (combined date/time field)

None

Email, Letter, SMS

BOOKING_CHECK_IN_TIME

The specific scheduled arrival date and time

Booking Details

Email, Letter

BOOKING_START_TIME

Arrival time formatted as HH:mm (e.g., 14:00)

Booking Details

Email, Letter

BOOKING_CHECK_OUT_TIME

The specific scheduled departure date and time

Booking Details

Email, Letter

BOOKING_END_TIME

Departure time formatted as HH:mm (e.g., 10:00)

Booking Details

Email, Letter

BOOKING_START_DT

Arrival date formatted as dd/mm/yyyy

Booking Details

Email, Letter

BOOKING_END_DT

Departure date formatted as dd/mm/yyyy

Booking Details

Email, Letter

BOOKING_STATUS_DESC

Current status (e.g., Confirmed, Provision)

None

Email, Letter

DEPOSIT_DUE_AMOUNT

The amount required as a deposit

None

Email, Letter, SMS

DEPOSIT_DUE_DT

The deadline date for the deposit payment

None

Email, Letter

BALANCE_DUE_DT

The deadline date for the final balance payment

None

Email, Letter, SMS

TOTAL_PRICE

The total gross price of the booking

None

Email, Letter

BALANCE

The remaining balance outstanding on the booking

None

Email, Letter

ITEM_SUMMARY

A text summary of items included in the booking

None

Email, Letter

ITEM_SUMMARY_LIST_PRICE

Summary of items including their list prices

None

Email, Letter

AGE_GROUP_SUMMARY

Breakdown of guests by age group (Adults/Children)

None

Email, Letter

PITCH_NO

The number of the pitch assigned to the booking

None

Email, Letter, SMS

PITCH_DESC

Full description of the assigned pitch

None

Email, Letter

GEOTAG

Geotag information for the pitch location

None

Email, Letter

LONGITUDE

Longitudinal coordinate of the pitch

None

Email, Letter

LATITUDE

Latitudinal coordinate of the pitch

None

Email, Letter

PET_COUNT

Total number of pets included in the booking

Booking Details

Email, Letter

CAR_REGISTRATION

List of vehicle registration numbers

Booking Details

Email, Letter

EXTRAS_ITEM_LIST

List of added extras and their individual prices

Booking Details

Email, Letter

NUMBER_OF_ADULTS

Total count of adults on the booking

Booking Details

Email, Letter

NUMBER_OF_CHILDREN

Total count of children on the booking

Booking Details

Email, Letter

PARTY_MEMBERS_COUNT

Total count of all members in the party

Booking Details

Email, Letter

Park & Company Fields

Merge Field

Description

Required Source

Medium

PARK_DESC

Park description

None

Email, Letter, SMS

PARK_POSTCODE

Park postcode

None

Email, Letter

PARK_NUMTEL

Park phone number

None

Email, Letter, SMS

COMPANY_VAT_NO

Company VAT number

None

Email, Letter

BANK_ACCT_NO

Park bank account number

None

Email, Letter

BANK_SORT_CODE

Park bank sort code

None

Email, Letter

FULL_PARK_ADDRESS_LIST

Multi-line formatted park address

OLP Form

Email, Letter

PARK_LOGO

Park logo image

None

Email, Letter

Utility & Meter Fields

Merge Field

Description

Required Source

Medium

OPENING_READING

Start meter reading

Utility Details

Email, Letter

CLOSING_READING

End meter reading

Utility Details

Email, Letter

UNITS

Total units consumed

Utility Details

Email, Letter

RATE

Charge rate per unit

Utility Details

Email, Letter

TOTAL_CHARGE

Total cost for the utility

Utility Details

Email, Letter

Job Details Fields

Merge Field

Description

Required Source

Medium

JOB_NO

Job reference number

Job Details

Email, Letter, SMS

JOB_STATUS

Status of the job

Job Details

Email, Letter, SMS

ASSIGNED_TO

Staff/Contractor assigned

Job Details

Email, Letter

TOTAL_LABOUR_CHARGE

Total labour costs

Job Details

Email, Letter

TOTAL_MATERIALS_CHARGE

Total materials costs

Job Details

Email, Letter

Special Fields

Dynamic tables and system-generated links for use in documents

Merge Field

Description

Required Source

Medium