|
Field Name
|
Data Type
|
|---|---|
|
Idle Time for the Job (Mins)
|
NUMBER(8,0)
|
|
Latitude
|
NUMBER(12,6)
|
|
Longitude
|
NUMBER(12,6)
|
|
Optimizer Message Creation Date Time
|
DATETIME
|
|
Overhead Time at End of the Job (Mins) NUMBER(8,0)
|
NUMBER(8,0)
|
|
Overhead Time at Start of the Job (Mins)
|
NUMBER(8,0)
|
|
Service Time (in Seconds)
|
NUMBER(12,6)
|
|
Status
|
PICKLIST
|
|
Total Break Time (Mins)
|
NUMBER(8,0)
|
|
Travel Time Back to Home Base (Mins)
|
NUMBER(8,0)
|
|
Travel Time to Workorder Location (Mins)
|
NUMBER(8,0)
|