MergeFields

General Items

FIELDNAMEDESCRIPTION
JOB DETAILS
job.generated_job_idJob Number
job.site_nameName of site, otherwise customer's name appears if isn't a job site
job.company_nameCustomer's Company Name (Clients name for individuals and Head office name for sites.) 
job.categoryJob Category
job.statusCurrent Status of Job (Quote / Work Order / Completed / Unsuccessful)
job.job_addressCustomer's Job Address
job.job_address_singlelineCustomer's Job Address (On a single line)
job.billing_addressCustomer's Billing Address
job.instantpost_billing_addressCustomer's Billing Address in Postal Format addressed to the Billing Contact. Details default to Job Contact and Job Address if Billing Contact and Billing Address are not available.
job.descriptionJob Description
job.work_done_descriptionJob Work Completed Details
job.completion_actioned_byStaff Member's name who marked job completed
job.purchase_order_numberJob Purchase Order Number
DATES
calculation.todays_date_extendedToday's Date Extended Format
calculation.todays_dateToday's Date
job.dateJob Creation Date
job.quote_dateDate job was marked as a Quote
job.work_order_dateDate job was marked as a Work Order
job.completion_dateDate job was marked completed
job.unsuccessful_datejob.unsuccessful_date
job.payment_dateDate payment for this job was processed
job.payment_actioned_byStaff Member's name who processed payment
job.invoice_datehttps://support.servicem8.com/hc/en-us/articles/5508739727759-How-to-change-an-invoice-date
job.invoice_date_extendedhttps://support.servicem8.com/hc/en-us/articles/5508739727759-How-to-change-an-invoice-date
CONTACTS
job.contact_firstCustomer's Job Contact First Name
job.contact_lastCustomers Job Contact Last Name
job.phone_1Customer's Job Contact Phone
job.mobileCustomer's Job Contact Mobile
job.emailCustomer's Job Contact Email Address
job.billing_contact_firstCustomer's Billing Contact Last Name
job.billing_contact_lastCustomer's Billing Contact First Name
job.phone_2Customer's Billing Contact Phone
job.billing_mobileCustomer's Billing Contact Mobile
job.billing_emailCustomer's Billing Email Address
job.property_manager_firstProperty Manager Contact First Name
job.property_manager_lastProperty Manager Contact Last Name
job.property_manager_emailProperty Manager Contact Email Address
job.property_manager_phoneProperty Manager Contact Phone Number
job.property_manager_mobileProperty Manager Contact Mobile Number
COMPANY INFORMATION
vendor.nameYour Company Name
vendor.emailYour Company Email Address
vendor.websiteYour Website address
location.nameName given to your current location (Eg. Head Office)
location.line1Your Office Address (Line 1)
location.line2Your Office Address (Line 2)
location.line3Your Office Address (Line 3)
location.cityYour Office Location (City)
location.stateYour Office Location (State) 
location.post_codeYour Office Location (Postal Code / Zip Code)
location.countryYour Office Location (Country)
location.faxYour fax number
location.phone_1Your phone number 
location.mobileYour mobile number 
location.lngGPS Longitude of your Office 
location.latGPS Latitude of your Office 
CALCULATIONS
calculation.todays_date_extendedToday's Date Extended Format
calculation.todays_dateToday's Date
calculation.current_user_fullnameStaff Members name who produced the invoice
job.invoice_due_date_from_todayDate invoice is due (Invoice terms from Invoiced Date). If a non-standard Payment Term is applied to the client, then its settings will be used instead.
calculation.current_user_fullnameCurrent User's Full Name
calculation.current_user_firstCurrent User's First Name
calculation.current_user_lastCurrent User's Last Name
calculation.current_user_mobileCurrent User's Mobile Number
calculation.current_user_emailCurrent User's Email Address
calculation.current_user_customfield_licence_numberCurrent User's License Number
company.bpay_customer_refCustomer BPAY Reference Number *Requires BPAY Addon activated
BOOKING DETAILS
job.booked_by_nameStaff Members name who booked the job
job.last_checkin_staff_nameLast Checkin Details - Staff Members Full Name
job.last_checkin_start_dateLast Checkin Details - Start date/time
job.last_checkin_end_dateLast Checkin Details - Completion date/time
job.last_checkin_durationLast Checkin Details - Checkin Duration
job.total_checkin_durationTotal Checkin time for job
job.next_booking_dateDate of next scheduled Job Booking - short
job.next_booking_date_extendedDate of next scheduled Job Booking - long
job.next_booking_timeTime of next scheduled Job Booking
job.next_booking_arrival_windowTime of next schduled Job Booking, within a time window based on Account Setting
JOB PAYMENT & INVOICING DETAILS
job.payment_dateDate payment for this job was processed
job.payment_actioned_byStaff Member's name who processed payment
job.payment_methodPayment Method (Available after job completion & Invoicing)
job.invoice_due_dateDate invoice is due (Invoice terms from Job Completion Date). If a non-standard Payment Term is applied to the client, then its settings will be used instead.
job.invoice_due_date_from_todayDate invoice is due (Invoice terms from Invoiced Date). If a non-standard Payment Term is applied to the client, then its settings will be used instead.
job.invoice_dateDate invoice is due (Invoice terms from Job Completion Date). This is compatible with the updated "Change Invoice Date workflow.
job.invoice_date_extendedDate invoice is due (Invoice terms from Job Completion Date), populated in the extended formate. This is compatible with the updated "Change Invoice Date workflow.

Invoice Specific

FIELDNAMEDESCRIPTION
job.total_priceTotal price
job.subtotal_priceSubtotal price
job.materials_subtotal_priceTotal materials
job.labour_subtotal_priceTotal labour
job.total_tax_priceTax total price (GST / VAT / etc)
job.amount_paidAmount Paid by Customer (Available after job completion & Invoicing)
job.balance_dueTotal price less any amounts paid
job.deposit_descriptionThe percentage of the total that is being used as the deposit requirement
job.deposit_amountThe dollar amount due as the deposit

Line Items

FIELDNAMEDESCRIPTION
jobMaterial.item_numberMaterial/Service Code
jobMaterial.nameMaterial/Service Name
jobMaterial.descriptionMaterial/Service Description
jobMaterial.quantityQuantity
jobMaterial.tax_rateItem Tax Type
jobMaterial.costPer Item Cost
jobMaterial.pricePer Item Price
jobMaterial.price_ex_taxPer Item Price - Excluding Taxes
jobMaterial.total_price_ex_taxTotal Price for this item (Quantity x Per Item Price - Excluding Taxes)
jobMaterial.total_priceTotal Price for this item (Quantity x Per Item Price - Including Taxes)

Bookmarks

BOOKMARKDESCRIPTION
blockStart_jobMaterialStart of your Material Row
blockEnd_jobMaterialEnd of your Material Row

Additional Items

FIELDNAMEDESCRIPTION
company.customfield_payment_termsPayment Terms
image_customer_signatureCustomer Signature which supports the Remote Signature feature
customer_signature_dateUsed with the Remote Signature feature to provide the date when signed
asset_nameProvide the Asset Name when completing a Form against it
vendor.bus_numberABN Number (Australia Only)

Was this article helpful?

Microsoft Word help