Columns

List of columns and their explanation:

Column name	Field name	Functions
Dynamic and job
Delivery Undetermined	DeliveryUndetermined	TRUE/FALSE. If TRUE, the unloading point is automatically cancelled. It is used in combination with stations.
email	email	Customer's email. An e-mail will be sent to this e-mail address if necessary.
Identifier	Identifier	Job identifier (quite often this is the invoice or customer number)
Ignores loading rules	IgnoreLoadingRules
import_event	import_event	What happened to the order during import. Created = newly created. Modified = changed
import_log	import_log	Import log
import_time	import_time	Import time
in_last_import	in_last_import	TRUE/FALSE - if TRUE, the last import contained this job
Maximum number of minutes between loading and unloading	MaxMinutesBetweenPickupAndDelivery	The maximum number of minutes that can elapse between loading and unloading
Maximum number of stops between loading and unloading	MaxStopsBetweenPickupAndDelivery	The maximum number of stops a vehicle can make between loading and unloading.
Quantity of locations	SiteSet	Specifies a subset of locations where the job can be taken. Used in combination with stations.
mobile	mobile	Telephone to the customer - SMS is sent to the specified number if necessary
non_consolidation_count	non_consolidation_count
Turnover	Revenue	Job income. When consolidating, it is added up from individual orders.
Penalties for not serving	NotServedPenalty	How much money does it cost not to set up a job. If the value is high, Tasha will try to load and ship the order, if it is low, Tasha will probably leave it unfilled (it is cheaper to pay the penalty than to ship the order)
Number of orders	OrdersCount	From how many individual orders is the job consolidated
Note 1	Info1	A note on the order, it can contain almost anything. If an order has been consolidated from several orders, the individual notes are separated by ";". Similarly for "Note 2" and "Note 3";
Type of product	ProductType	Determine the product type. Used in combination with stations.
Type of job	JobTypeUser	Job type. Red = delivery, purple = collection, green = pick up and deliver, grey = other
Distance between stops	DistanceBetweenStops	Distance between loading and unloading.
Always try to load	AlwaysTryLoading	TRUE/FALSE - if TRUE, Tasha will always try to load the job.
Source undetermined	SourceUndetermined	TRUE/FALSE. If TRUE, the loading point is automatically cancelled. It is used in combination with stations.
Loading & Unloading		Similarly for unloading, only the fields are named "StopTo..."
Address	StopFromLocationAddress	Loading address
Administration time	StopFromAdminTime
Time of work	StopFromWorkingTime
From Max Demand1 On Stop	StopFromMaxDemand1OnStop	Restriction of the current vehicle load for entering the given location (if the vehicle is loaded more, it will not enter the given location).
Identifier	StopFromIdentifier	Job loading identifier in the format "job name(job identifier)
Location identifier	StopFromLocationIdentifier	Unique location identifier. A new loading/unloading location can be defined by selecting from the menu.
Stop 1 Time	StopFromCloseTime	How many hours can the job be loaded within. "Similar for End 2 Time" to "End 10 Time";
Stop 1 Date	StopFromCloseDate	By which date the job can be loaded
Stop of 1 Day	StopFromCloseDay	By what date after scheduling can be loaded. 0 = loading on the day of scheduling, 1 = loading not later than the day after scheduling...
Stop 1 Penalty for tardiness	StopFromClose1TardinessPenalty
Stop 1 Tolerance	StopFromClose1Tolerance
Name	StopFromName	Name of load
Demand 1	StopFromDemand1	How many goods are to be loaded. It can represent pieces, weight, volume, pallets... Similarly for "Demand 2" to "Demand 5";
Order	StopFromOrder
Ranking on the Head	StopToHeadOrder	Only at the unloading bay. The number indicates how many times the order must be unloaded from the end (1 = order is unloaded last, 2 = order is unloaded next to last...)
Ranking on the Tail	StopToTailOrder	Only at the unloading bay. The number indicates the number of times the order must be unloaded (1 = job is unloaded first, 2 = job is unloaded second...)
Sequence	StopFromPrecedence	Job sequence
Priority admin time	StopFromOverridingAdminTime
Width of time windows	StopFromTimeWindowWidth
Duration	StopFromDuration	Stop dwell time, in minutes
Type of stop	StopFromType	Typ zastávky Stop type - depot pickup, delivery, pickup...
X	StopFromLocationX	GPS coordinates X loading
Y	StopFromLocationY	GPS coordinates Y loading
Start 1 Time	StopFromOpenTime	From what time is it possible to load the job. "Similar for Start 2 Time" to "Start 10 Time";
Start 1 Date	StopFromOpenDate	From which date can the job be loaded
Start 1 Day	StopFromOpenDay	From what day after scheduling can be loaded. 0 = loading on the day of scheduling, 1 = loading on the day after scheduling at the earliest...
Start 1 Penalty for tardiness	StopFromOpen1TardinessPenalty
Start 1 Tolerance	StopFromOpen1Tolerance
Special marks	StopFromSpecialCodes	Special marks at loading (the usual special marks are at unloading)