Import Fields

Updated on September 5, 2025

Fields	Definition
Job Reference Number	A unique number that used to group rows into one job. Leaving this empty will use a system-generated order number instead. Inputting a similar Job Reference Number and indicating ‘P’ on Stop Type will combine the two rows into one job.
Stop Type	Mark as ‘P’ if the job is a 2-stop location. ‘P’ will signify that the row is the pick-up point.
Stop No	Merging rows into one stop if there are multiple items in one location.
Driver Name	Indicate the driver for the job to be assigned to. (Driver needs to be already created for this to function.)
Route Name	Indicates the route for the job to be assigned to. (Route needs to be already created for this to function.)
Scheduled Delivery Date and Allowed Start	Input a scheduled delivery date for your job. Format: yyyy-mm-dd hh:mm
Priority	Can set priority for jobs. Format: regular (by default if empty), high, low.
Job Labels	Indicate a label for your job. (Label needs to be already created for this to function.)
Special Requirement	Indicate a Special Requirement for the job. (Special Requirement needs to be already created for this to function.)
Customer ID	A valid Customer ID is all it needs to create a single-type job with a system-generated Job number. The system will get all customer information based on the existing customer ID record. You can find this number by web app > address book > select address > on the top right corner
Customer Name	Indicate the name of your customer for your job.
Phone Country Code	Country Code for phone number.
Phone	Indicate the phone number for the customer.
Email	Indicate the email for the customer.
GPS	Input a valid GPS coordinate for customer address. (If Address Line 1 is indicated, this column is not necessary.)
Lat	Latitude of the job location.
Lng	Longitude of the job location.
Country Code	Enter the country code abbreviation to ensure accurate location mapping. E.g. SG, MY, ZA
Address Line 1	The Address Line 1 will be used to retrieve geolocation. Although this normally should be sufficient to provide a valid geolocation to use. But due to duplication addresses might exist in multiple different countries, a valid Country Code is highly recommended.
Address Line 2	Additional address information like Building name or Unit number
City	Input the City of the location
State	Input the State of the location
Postal Code	Input the Postal Code of the location.
Note	Any Additional notes to inform the driver.
Scheduled Arrival Time	Set a specific arrival time or time window if needed to inform the driver of the expected arrival time or to track job lateness. For example: Single time: 8:30 AM Time window: 8:30 AM, 9:40 AM (separated by a comma)
Scheduled Duration	How long the job will take on each stop. Default to 5 (min).
Stop Todos	This value represents a series of stop-level to dos in sequence. 1. signature 2. POD 5. note
Item Type	Specify one of the three item types: 'Package,' 'Person,' or 'Service.'
Item Name	Indicate the Item Name.
Item Quantity	Indicate the quantity of the specific item.
Item Weight	Indicate the weight of the specific item.
Item Weight Unit	Define the unit of measurement. E.g. kg or lb
Item Dimensions	Indicate the Length, Width and Height of the item.
Item Dimensions Unit	Define the unit of measurement. E.g. cm or inch
Tracking Code	Indicate the string of Tracking Code number
SKU	Indicate the SKU Code
UPC	Indicate the UPC Code
Item Todos	This value represents a series of item-level to dos in sequence. 1. signature 2. POD 3. scan to attach 5. note

Was this article helpful?

Import Fields

Vision

MiFleet

Delivery

FleetWeb

Reports

Carpool

Scorecard

Import Fields

Sign up to our newsletter!

Simplifying IT
for a complex world.

Platform partnerships

Import Fields

Share This Article :

Simplifying IT for a complex world.

Platform partnerships

Simplifying IT
for a complex world.