Detrack Fields For Jobs

In the Detrack dashboard, there are many headers/fields for jobs. In this tutorial, we will explain what the fields are.

Field Description Data Type Example Variable Tags
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 lowest 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”. This field is only available for importing Excel / CSV file. If you require this field to appear on the dashboard, you can contact us to add it in. String 61 Kaki Bukit Ave 1 {{address_1}}
Address 2 For users who prefer to have their address split up, part of “Line Address”. This field is only available for importing Excel / CSV file. If you require this field to appear on the dashboard, you can contact us to add it in. String #04-34 {{address_2}}
Address 3 For users who prefer to have their address split up, part of “Line Address”. This field is only available for importing Excel / CSV file. If you require this field to appear on the dashboard, you can contact us to add it in. String Shun Li Industrial Park {{address_3}}
Postal Code For users who prefer to have their address split up, part of “Line Address”. This field is only available for importing Excel / CSV file. If you require this field to appear on the dashboard, you can contact us to add it in. String 417943 {{postal_code}}
City For users who prefer to have their address split up, part of “Line Address”. This field is only available for importing Excel / CSV file. If you require this field to appear on the dashboard, you can contact us to add it in. String Singapore {{city}}
State For users who prefer to have their address split up, part of “Line Address”. This field is only available for importing Excel / CSV file. If you require this field to appear on the dashboard, you can contact us to add it in. String Singapore {{state}}
Country For users who prefer to have their address split up, part of “Line Address”. This field is only available for importing Excel / CSV file. If you require this field to appear on the dashboard, you can contact us to add it in. 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. {{name}} String Patrick
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}}
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 with “; “.
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 Of 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 URL 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”.
Integer 1234 {{verification_code}}
Field Description Data Type Example **Variable Tags
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 why the item was rejected. Reasons can be edited under 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:
{% if items.size > 1 %}
SKU | Description | Qty
{% for item in items %}
{{item.sku}} | {{item.description}} | {{item.quantity}}
{% endfor %} {% endif %}