TUTORIAL

Detrack Fields For Jobs

This article is regarding the fields and descriptions of the Job in Detrack.

Field Description Data Type Example Variable Tags for SMS / Email Notifications
Detrack Job Type There two types of jobs in Detrack. They are Delivery or Collection jobs. When creating a job, you have to indicate the type of job by choosing the corresponding Delivery or Collection tab on the dashboard.

How To Add A Delivery

How To Add A Collection

String Delivery or Collection only. {{type}}
Primary Job Status The starting job status of the job when the job is first created.

Statuses Of Tracking
Widget And Notifications

String In-Progress
Info Received
In Transit
{{primary_job_status}}
Open to Marketplace For indicating whether the job can appear in the marketplace for drivers to grab.

How To Use The Marketplace

Boolean true, false, 1, 0
true = 1, false = 0
{{open_to_marketplace}}
Marketplace Offer Refers to the price/offer for drivers when shown on the marketplace.

How To Use The Marketplace

Float 7.50 {{marketplace_offer}}
D.O. No. Unique identifier of the job for the day.
It can be entered manually or it can be generated automatically by the system.

How To Auto Generate Delivery Order No
Required.

String DO123 {{do_number}}
Attempt The number of times the job has been attempted.
Default number: 1
If there is a reattempt of a job, the number will increase accordingly.

How To Reattempt Failed Job

Integer 2 {{attempt}}
Date Date of delivery/collection. The date that the delivery or collection job will be performed.
Required.
Date 2019-12-24 {{date}}
Start Date To indicate when the job was started.
By default, it will be the same as the Date for performing the Delivery/Collection job.
Date 2019-12-24 {{start_date}}
Job Age The number of days since the job is active.
For jobs of future dates: 0
For past of active jobs: Job Age = Date – Start Date + 1
Integer 3 {{job_age}}
Job Release Time Refers to the timing for the job to appear in the Driver App.

How To Set Timer To Show Jobs On Driver’s App At A Certain Time

Time 09:00 AM {{job_release_time}}
Job Time The time of delivery or collection that the driver is supposed to perform. String 12:30 pm, 9 am, 3 – 4 pm {{job_time}}
Time Window The time window for performing the job. String 0900 – 1100 hrs {{time_window}}
Job Received Date Date when the job was received from the requestor. Date 2019-12-24 {{job_received_date}}
Tracking No. Tracking number of the job.
Customers can use this number to check the status of their deliveries or collection job via our tracking widget.
String T1234567 {{tracking_number}}
Order No. Order number of the job. It can be the Purchase order number. String O123 {{order_number}}
Job Type For indicating the various job types that the job belongs to.
You can place the types of jobs that require special attention at the top of the job list in the Driver App.

How To Place Priority Jobs On Top Of Drivers List

String Urgent, Express, Same day {{job_type}}
Job Sequence The order of the jobs appearing in the Driver App.
The job with the smallest number will be placed at the top of the list.

How To Manually Sort Deliveries For Drivers

How To Manually Sort Collections For Drivers

Float 10 {{job_sequence}}
Job Fee The amount that the customer pays for performing the job. String 100 {{job_fee}}
Address Latitude The latitude of the address. To be used with Address Longitude.

How To Enable Address Using Your Own Latitude And Longitude

How To Manually Locate Your Address For Delivery / Collection

Float 1.3356456 {{address_lat}}
Address Longitude The longitude of the address. To be used with Address Latitude.

How To Enable Address Using Your Own Latitude And Longitude

How To Manually Locate Your Address For Delivery / Collection

Float 103.9095161 {{address_lng}}
Address The location of the job to perform the delivery/collection.
Required.
String 61 Kaki Bukit Ave 1 Shun Li Industrial Park Singapore 417943 {{address}}
Company Name Recipient or Sender’s company name. String ABC Company {{company_name}}
Address 1 For users who prefer to have their address split up, part of Line Address.
Available for import via Excel / CSV, and Excel / CSV export.
String 61 Kaki Bukit Ave 1 {{address_1}}
Address 2 For users who prefer to have their address split up, part of Line Address.
Available for import via Excel / CSV, and Excel / CSV export.
String #04-34 {{address_2}}
Address 3 For users who prefer to have their address split up, part of Line Address.
Available for import via Excel / CSV, and Excel / CSV export.
String Shun Li Industrial Park {{address_3}}
Postal Code For users who prefer to have their address split up, part of Line Address.
Available for import via Excel / CSV, and Excel / CSV export.
String 417943 {{postal_code}}
City For users who prefer to have their address split up, part of Line Address.
Available for import via Excel / CSV, and Excel / CSV export.
String Singapore {{city}}
State For users who prefer to have their address split up, part of Line Address.
Available for import via Excel / CSV, and Excel / CSV export.
String Singapore {{state}}
Country For users who prefer to have their address split up, part of Line Address.
Available for import via Excel / CSV, and Excel / CSV export.
String Singapore {{country}}
Billing Address Billing address for collecting payment. String 61 Kaki Bukit Ave 1 Shun Li Industrial Park Singapore 417943 {{billing_address}}
Deliver To / Collect From The name of Recipient or Sender. String Patrick {{name}}
Last Name The last name of Recipient or Sender. String Parker {{last_name}}
Phone No. Recipient’s phone number.
Can be used to trigger SMS notifications or call through the Driver App.

How To Set Up Email And Text SMS

Notifications

How To Call Recipient

String 912345678 {{phone_number}}
Sender Phone No. Sender’s phone number.
Can be used to trigger SMS notifications or call through the Driver App.

How To Set Up Email And Text SMS Notifications

How To Call Sender

String 912345678 {{sender_phone_number}}
Other Phone Numbers For populating several phone numbers.
Can be used to trigger SMS notifications.

How To Set Up Email And Text SMS Notifications

String 912345678; 81111111; 72222222 {{other_phone_numbers}}
Fax No. Customer’s fax number. String 912345678 {{fax_number}}
Instructions Instructions for your driver to appear in the Driver App. String Call the recipient upon arrival. {{instructions}}
Assign To The vehicle/driver assigned to the job. String Driver1 {{assign_to}}
Notify Email Email/s to send job notifications to. For more than one email, separate each entry with semi-colon “;”.

How To Set Up Email And Text SMS Notifications

How To Personalize Customer Email Notifications

String john@gmail.com;

mary@yahoo.com;

ben@detrack.com

{{notify_email}}
Webhook URL Webhook URL for receiving the webhook PUSH notifications. For use in integrations with third-party applications.

How To Setup Webhooks In Detrack

String https://yourwebhook.com {{webhook_url}}
Zone An area having a particular characteristic, purpose, or use, or subject to particular restrictions for performing the job.
Can be used to assign a vehicle to a particular zone for jobs.

How To Auto Assign Using Zones

String North {{zone}}
Customer Customer’s name. The customer who requested for the delivery or collection. String Peter {{customer}}
Account No. Customer’s account number. String ACC123 {{account_number}}
Job Owner Requestor/owner of the job. String Mary {{job_owner}}
Invoice No. Invoice number for the job. String Inv123 {{invoice_number}}
Invoice Amount The amount for the job invoice. Float 1.5 {{invoice_amount}}
Payment Mode The mode of payment for the job. String COD
Credit Card
{{payment_mode}}
Payment Amount The Cash On Delivery amount to be collected for the job.
Entering a value in this field will produce a pop-out in the Driver App to inform the driver to collect payment for the job.
Related to Payment Mode and Payment Collected.

How To Use The Cash On Delivery COD Feature

How To Enter Payment Amount for COD

Float 7.50 {{payment_amount}}
Group Name of a group.
Groups are used to separate job information from the rest of the jobs.
Only sub-users within the group is allowed to view jobs under the same group.
You can group your job information by customer name, zones, warehouse, retail stores, etc.

How To Use The Group Feature To Restrict The Information Available To Each Sub-User

How To Create Groups For Users

How To Tag A Delivery To A Group
How To Add Vehicles To A Group

String Disney
Sydney
Warehouse 1
Store 23
{{group_name}}
Source For indicating the origin of the job. String Jack’s place {{source}}
Weight Weight of the package. Float 1.5 {{weight}}
Parcel Width Width of the parcel (cm). Related to CBM (Cubic Meter). Integer 1 {{parcel_width}}
Parcel Length Length of the parcel (cm). Related to CBM (Cubic Meter). Integer 2 {{parcel_length}}
Parcel Height Height of the parcel (cm). Related to CBM (Cubic Meter). Integer 3 {{parcel_height}}
CBM Cubic Meters/Volume of parcel/item. Equals to Parcel Width x Parcel Length x Parcel Height. Float 1.5 {{cubic_meter}}
Boxes Number of Boxes. You can enter the description as well. String 5
Big
Medium
{{boxes}}
Cartons Number of Cartons. Integer 4 {{cartons}}
Pieces Number of Pieces. Integer 4 {{pieces}}
Envelopes Number of Envelopes. Integer 4 {{envelopes}}
Pallets Number of Pallets. Integer 4 {{pallets}}
Bins Number of Bins. Integer 4 {{bins}}
Trays Number of Trays. Integer 4 {{trays}}
Bundles Number of Bundles. Integer 4 {{bundles}}
Rolls Number of Rolls. Integer 4 {{rolls}}
No. of Shipping Labels Number of copies of shipping labels to be generated.
Entering a value of 5 will generate 5 shipping labels, labeled as 1/5, 2/5, 3/5, 4/5, 5/5.

How To Print Shipping Labels For Deliveries And Collections

Integer 5 {{number_of_shipping_labels}}
Attachment URL URL hyperlink for attachment to be displayed in Driver App.

How To Include Attachment Link For Deliveries/Collections To Show In Driver App

String https://example.com {{attachment_url}}
Detrack No. Unique Detrack number that is allocated to the job upon job creation and is used for Aftership (https://www.aftership.com/) tracking only. String DET123456789 {{detrack_number}}
Job Status For indicating the status of the job. This is the status that admin/ managers will see in the dashboard. String In Progress
Info Received
Failed
Partially Completed
Completed
{{status}}
Tracking Status For indicating the tracking status of the job. This is the status that customers will see on the tracking widget.

Statuses Of Tracking Widget And Notification

String Info Received
Scheduled
Out For Delivery
Failed
Partially Completed
Completed
{{tracking_status}}
Reason Reasons for job failure or signature not be collected.
Can be customized in Settings > Delivery / Collection > Reasons.

How To Submit Failed Delivery Status

How To Submit Failed Collection Status

How To Customize Non Delivery Reasons

How To Customize Non Collection Reasons

String Recipient not in {{reason}}
Received By Sender/Recipient name.
Name of the signature bearer captured from the Driver App.

How To Make Receiver’s Name Mandatory For Deliveries

How To Make Sender’s Name Mandatory For Collections

String Bob {{received_by_sent_by}}
Note The driver can write a note with regards to the job when he/she is performing the delivery/collection job.
The note is entered through the Driver App by tapping on the Note button.

How To Write Note For Delivery

How To Write Note For Collection

String The parcel is damaged during delivery. {{note}}
Carrier The carrier that transported the parcel. This can be an airplane, a ship, or a courier company. String A809
Belleisle
DHL
{{carrier}}
POD Latitude The latitude of where the proof of delivery (POD) is submitted through the Driver App. Float 1.3356456 {{pod_lat}}
POD Longitude The longitude of where the proof of delivery (POD) is submitted through the Driver App. Float 103.9095161 {{pod_lng}}
POD Address The address where the proof of delivery (POD) is submitted, derived from POD Latitude and POD Longitude. String 1 Raffles Blvd, Singapore 039593 {{pod_address}}
Address Tracked At The last timing of address when the vehicle is tracked at. Date Time 2019-12-24T11:34:05.417+08:00 {{address_tracked_at}}
Arrived Latitude The latitude where driver triggered Arrived At on Driver App.

How To Send Text/SMS When Arrived At Location

Float 1.3356456 {{arrived_lat}}
Arrived Longitude The longitude where driver triggered Arrived At on Driver App.

How To Send Text/SMS When Arrived At Location

Float 103.9095161 {{arrived_lng}}
Arrived Address The address where the driver triggered Arrived At on Driver App.

How To Send Text/SMS When Arrived At Location

String 1 Raffles Blvd, Singapore 039593 {{arrived_address}}
Arrived At The timing when the driver triggered Arrived At on Driver App.

How To Send Text/SMS When Arrived At Location

Date Time 2019-12-24T11:34:05.417+08:00 {{arrived_at}}
Texted At The timing when driver text through Driver App. Tap the Phone icon > Send Pre-delivery text Date Time 2019-12-24T11:34:05.417+08:00 {{texted_at}}
Called At The timing when the driver calls through Driver App. Tap the Phone icon > Call recipient/sender.

How To Call Recipient

How To Call Sender

Date Time 2019-12-24T11:34:05.417+08:00 {{called_at}}
Serial No. Serial No. of the job item. To be captured via the Driver App.

How To Print Serial No Barcode On POD PDF

String SN123 {{serial_number}}
Signed At Timing when the signature is captured in Driver App.

How To Capture Signature For Delivery

How To Capture Signature For Collection

Date Time 2019-12-24T11:34:05.417+08:00 {{signed_at}}
Photo 1 At Timing when Driver takes Photo 1.

How To Capture Photo Proof For Delivery

How To Capture Photo Proof for Collection

Date Time 2019-12-24T11:34:05.417+08:00 {{photo_1_at}}
Photo 2 At Timing when Driver takes Photo 2.

How To Capture Photo Proof For Delivery

How To Capture Photo Proof for Collection

Date Time 2019-12-24T11:34:05.417+08:00 {{photo_2_at}}
Photo 3 At Timing when Driver takes Photo 3.

How To Capture Photo Proof For Delivery

How To Capture Photo Proof for Collection

Date Time 2019-12-24T11:34:05.417+08:00 {{photo_3_at}}
Photo 4 At Timing when Driver takes Photo 4.

How To Capture Photo Proof For Delivery

How To Capture Photo Proof for Collection

Date Time 2019-12-24T11:34:05.417+08:00 {{photo_4_at}}
Photo 5 At Timing when Driver takes Photo 5.

How To Capture Photo Proof For Delivery

How To Capture Photo Proof for Collection

Date Time 2019-12-24T11:34:05.417+08:00 {{photo_5_at}}
Photo 6 At Timing when Driver takes Photo 6.

How To Capture Photo Proof For Delivery

How To Capture Photo Proof for Collection

Date Time 2019-12-24T11:34:05.417+08:00 {{photo_6_at}}
Photo 7 At Timing when Driver takes Photo 7.

How To Capture Photo Proof For Delivery

How To Capture Photo Proof for Collection

Date Time 2019-12-24T11:34:05.417+08:00 {{photo_7_at}}
Photo 8 At Timing when Driver takes Photo 8.

How To Capture Photo Proof For Delivery

How To Capture Photo Proof for Collection

Date Time 2019-12-24T11:34:05.417+08:00 {{photo_8_at}}
Photo 9 At Timing when Driver takes Photo 9.

How To Capture Photo Proof For Delivery

How To Capture Photo Proof for Collection

Date Time 2019-12-24T11:34:05.417+08:00 {{photo_9_at}}
Photo 10 At Timing when Driver takes Photo 10.

How To Capture Photo Proof For Delivery

How To Capture Photo Proof for Collection

Date Time 2019-12-24T11:34:05.417+08:00 {{photo_10_at}}
Actual Weight The weight entered through the Driver App. Tap Camera icon > Enter Weight. Float 1.5 {{actual_weight}}
Temperature The temperature entered through the Driver App. Tap Camera icon > Enter Temperature. Float 1.5 {{temperature}}
Hold Time The hold time entered through the Driver App. Tap Camera icon > Enter Hold Time. Float 1.5 {{hold_time}}
Payment Collected The payment amount collected, entered through the Driver App.
Related to Payment Amount.

How To Use The Cash Of Delivery COD Feature

How To Enter Payment Amount for COD

Float 1.5 {{payment_collected}}
Auto Reschedule Indicates whether the job will be carried forward to the subsequent day at 12 midnight under certain conditions. Yes = 1, No = 0

How To Automatically Reschedule Delivery / Collections Jobs To The Next Day

Boolean 1 {{auto_reschedule}}
Actual Crates The number of crates entered through the Driver App. Tap Camera icon > Enter Crates. Integer 10 {{actual_crates}}
Actual Pallets The number of pallets entered through the Driver App. Tap Camera icon > Enter Pallets. Integer 10 {{actual_pallets}}
Actual Utilization The number of utilization entered through the Driver App. Tap Camera icon > Enter Utilization. Float 1.5 {{actual_utilization}}
Goods / Service Rating Goods service rating performed by your customers. Values: 1 – 5.

How To Let Customer Rate And Leave Feedback On Your Product And Service

How To Let Your Customers Leave Feedback Automatically

Integer 5 {{goods_service_rating}}
Driver Rating Driver rating performed by your customers. Values: 1 – 5.

How To Let Customer Rate And Leave Feedback On Your Product And Service

How To Let Your Customers Leave Feedback Automatically

Integer 5 {{driver_rating}}
Customer Feedback Customer feedback provided by your customers.

How To Let Customer Rate And Leave Feedback On Your Product And Service

How To Let Your Customers Leave Feedback Automatically

String Good job. I like the service. {{customer_feedback}}
ETA Time Estimated time of arrival of the job. String 12:00 {{eta_time}}
Live ETA The Live ETA will be based on the differences between the estimated arrival time (ETA) entered for the job form and the proof of delivery (POD) time submitted from the previous jobs.
For instance, if the ETA Time of the previous job is late by 30 mins, and the ETA Time of the current job in 12:00, the Live ETA will be 12:30.
Time 12:30 {{live_eta}}
Depot Name of depot for the job. String Warehouse 1 {{depot}}
Depot Contact Contact number/person for the depot. String Jerry
91234567
{{depot_contact}}
Department Department to deliver to/collect from for the job. String Marketing {{department}}
Sales Person The salesperson for the job. String Adam {{sales_person}}
Identification No. Identification no for the recipient. String ID123 {{identification_number}}
Bank Prefix Prefix for the bank. String BK123 {{bank_prefix}}
Run No. The run number to which the job belongs to. Can be used to group up several related jobs to be assigned to a driver.

How To Scan QR Codes To Accept Runs

String 1 {{run_number}}
POD At The timing when the POD was performed via Driver’s App. Date Time 2019-12-24T11:34:05.417+08:00 {{pod_at}}
Job Price Price of the job quoted to the customer. String 100 {{job_price}}
Insurance Price Amount of insurance for the job. Related to Insurance Coverage. String 100 {{insurance_price}}
Insurance Coverage To indicate whether is the job being insured. Related to Insurance Price. Yes = 1, No = 0 Boolean 1 {{insurance_coverage}}
Total Price Total price amount for the job. String 100 {{total_price}}
Payer Type Either Buyer or Seller. To indicate the payer of the job. String Buyer {{payer_type}}
Remarks Remarks for the job. Usually for internal staff to view. String Peter wishes to extend the payment. {{remarks}}
Items Count Number of row entries in the Item Details section. Integer 10 {{items_count}}
Service Type Type of service String Express delivery {{service_type}}
Warehouse Address Address of warehouse. String 61 Kaki Bukit Ave 1 Shun Li Industrial Park Singapore 417943 {{warehouse_address}}
Destination Time Window The time window for the driver to arrive at the delivery/collection location. String 1400 – 1500 {{destination_time_window}}
Door The door for the driver to use at delivery/collection. String Door 4 {{door}}
Time Zone Enter the city name to indicate that the job is under a different time zone. The time of POD captured will be in the city’s time. String Sydney {{time_zone}}
Priority Priority of the job. For use with ElasticRoute. For use with ElasticRoute.

How To Set Priority For Your Stops

Integer 1 {{priority}}
Service Time The time required to perform the job, for example, the time taken to find a parking lot, load/unload the goods, time for installation etc. For use with ElasticRoute.

How To Set Service Time For Your Stops

Integer 10 {{service_time}}
Verification Code A code that is automatically generated by the systems for completing the job upon selection of certain Note.

How To Enforce A Verification Code Prior To Completing A Job

Integer 1234 {{verification_code}}
Vehicle Type Information on the type of vehicle used to service the job. String truck {{vehicle_type}}
Field Description Data Type Example Variable Tags for SMS / Email Notifications
SKU Stock keeping unit. Usually, it is the item barcode for identification.

How To Scan Item Barcode To Check Items

String SKU123 sku
Item P.O. No. Item purchase order number. String PO123 purchase_order_number
Item Batch No. Item batch number. String Batch123 batch_number
Expiry Date The expiry date of the item. String 2019-12-24 expiry_date
Item Description Description of the item. String Apple description
Comments Comments on the item. String Black and juicy. comments
Quantity Quantity of item. Integer 10 quantity
Unit of Measure The measuring unit for the item e.g. box, kg, each, pkg String EA unit_of_measure
Item Checked Indicate if the driver has checked if the item belongs to that job based on SKU by using the driver app. This will appear on the dashboard only after POD.

How To Scan Item Barcode To Check Items

How To Scan Item Barcode To Check Items For Drivers

Boolean 1 checked
Actual Quantity The quantity entered by the driver through the driver’s app. Camera icon > Items on driver’s app.

How To Allow Drivers To Change Quantity Under Item Detail

How To Change Quantity For Delivery Item

How To Change Quantity For Collection Item

Integer 10 actual_quantity
Inbound Quantity For inbound items, e.g. to indicate that items have yet to finish processing after job completion. Integer 10 inbound_quantity
Unload Time Estimate Estimated time taken to unload items for delivery/collection. Integer 10 unload_time_estimate
Unload Time Actual The actual time taken to unload items for delivery/collection. Integer 10 unload_time_actual
Follow Up Quantity For follow up quantity after completing the job. Integer 10 follow_up_quantity
Follow Up Reason Reason for follow up items. String Reason1 follow_up_reason
Rework Quantity For changing of item quantity after completing the job. Integer 10 rework_quantity
Rework Reason Reason for reworking the quantity. String Reason1 rework_reason
Reject Quantity The quantity of the item being rejected.

How To Reject Delivery Item

How To Reject Collection Item

Integer 10 reject_quantity
Item Reject Reason The reason for the item rejection.
To edit the reasons, navigate to Settings > Delivery / Collection > Reasons.

How To Customize Non Delivery Reasons

How To Customize Non Collection Reasons

String Reason1 reject_reason
Item Weight Weight of the item entered in the job form. Float 10.5 weight
Item Serial No. Item serial number captured through Driver App.

How To Scan Individual Item Barcode

String SN123 serial_numbers

The information in the items section requires one to perform a loop of the {{items}} to obtain the various information.

For example:

String version

{% if items.size > 1 %}
<p>SKU | Description | Qty</p>
{% for item in items %}
<p>{{item.sku}} | {{item.desc}} | {{item.qty}}</p>
{% endfor %}
{% endif %}

Table version

{% if items.size > 1 %}
<table>
<thead>
<th>SKU</th>
<th>Description</th>
<th>Quantity</th>
</thead>
<tbody>
{% for item in items %}
<tr>
<td>{{item.sku}}</td>
<td>{{item.desc}}</td>
<td>{{item.qty}}</td>
</tr>
{% endfor %}
</tbody>
</table>
{% endif %}

Delivery Dynamics:
Your Detrack Insider!

Subscribe to our newsletter to get tips delivered straight to your inbox