Field Name
|
Data Type
|
||
---|---|---|---|
Custom Relationship Fields
|
|||
Account
|
LOOKUP
|
||
Appointment Type
|
LOOKUP
|
||
Case
|
LOOKUP
|
||
Closed By
|
LOOKUP
|
||
Component
|
LOOKUP
|
||
Contact
|
LOOKUP
|
||
Dependency Group
|
LOOKUP
|
||
Dispatch Process
|
LOOKUP
|
||
Investigation
|
LOOKUP
|
||
Master Order Line
|
LOOKUP
|
||
Partner Account
|
LOOKUP
|
||
Partner Contact
|
LOOKUP
|
||
Preferred Business Hours
|
LOOKUP
|
||
Preferred Technician
|
LOOKUP
|
||
Preventive Maintenance Plan
|
LOOKUP
|
||
Primary Territory
|
LOOKUP
|
||
Primary Work Order
|
LOOKUP
|
||
Product
|
LOOKUP
|
||
Service Contract
|
LOOKUP
|
||
Service Request
|
LOOKUP
|
||
Service Team
|
LOOKUP
|
||
Site
|
LOOKUP
|
||
Skill
|
LOOKUP
|
||
SLA Terms
|
LOOKUP
|
||
Technician
|
LOOKUP
|
||
Top-Level
|
LOOKUP
|
||
Warranty
|
LOOKUP
|
||
Roll-up Summary Fields
|
|||
Total Billable Amount
|
ROLL-UP SUMMARY
|
||
Total Estimate
|
ROLL-UP SUMMARY
|
||
Total Expense Cost
|
ROLL-UP SUMMARY (SUM Work Detail)
|
||
Total Labor Cost
|
ROLL-UP SUMMARY (SUM Work Detail)
|
||
Total Parts Cost
|
ROLL-UP SUMMARY (SUM Work Detail)
|
||
Total Travel Cost
|
ROLL-UP SUMMARY (SUM Work Detail)
|
||
Total Work Order Amount
|
ROLL-UP SUMMARY
|
||
Other Fields
|
|||
Acknowledged By Technician Date Time
|
DATETIME
|
||
Actual Initial Response
|
DATETIME
|
||
Actual Onsite Response
|
DATETIME
|
||
Actual Resolution
|
DATETIME
|
||
Actual Restoration
|
DATETIME
|
||
Age
|
FORMULA(NUMBER)
|
||
Age Bucket
|
FORMULA(STRING)
|
||
Apply Business Hours For OptiMax
|
CHECKBOX
|
||
Auto Entitlement Status
|
PICKLIST
|
||
Batch Update
|
PICKLIST
|
||
Billing Type
|
PICKLIST
|
||
Booked Appointment Slot
|
STRING
|
||
Canceled Date Time
|
DATETIME
|
||
Capacity Rule Name
|
STRING
|
||
City
|
STRING
|
||
Clock Paused Forever
|
CHECKBOX
|
||
Closed On
|
DATETIME
|
||
Completed Date Time
|
DATETIME
|
||
Configuration – After
|
STRING
|
||
Configuration - Before
|
STRING
|
||
Corrective Action
|
STRING
|
||
Country
|
PICKLIST
|
||
Crew Assignment
|
CHECKBOX
|
||
Crew Id
|
STRING
|
||
Crew Name
|
STRING
|
||
Customer Down
|
CHECKBOX
|
||
Customer Down Status
|
FORMULA(STRING)
|
||
Customer Failure Feedback
|
STRING
|
||
Dispatch Now
|
PICKLIST
|
||
Dispatch Priority
|
NUMBER(16,2)
|
||
Dispatch Response
|
PICKLIST
|
||
Dispatch Status
|
FORMULA(STRING)
|
||
Drip
|
CHECKBOX
|
||
Driving Time (in Minutes)
|
NUMBER(18,0)
|
||
EndpointURL
|
FORMULA(STRING)
|
||
Entitlement Notes
|
STRING
|
||
Entitlement Type
|
PICKLIST
|
||
Estimated Duration
|
NUMBER(16,2)
|
||
Failed Assembly
|
PICKLIST
|
||
Failure Location
|
PICKLIST
|
||
Finished Onsite Date Time
|
DATETIME
|
||
First Assigned DateTime
|
DATETIME
|
||
First Queued DateTime
|
DATETIME
|
||
First Scheduled DateTime
|
DATETIME
|
||
Group Email
|
EMAIL
|
||
How Fixed
|
PICKLIST
|
||
Idle Time (in Minutes)
|
NUMBER(18,0)
|
||
Initial Response Customer By
|
DATETIME
|
||
Initial Response Internal By
|
DATETIME
|
||
In Jeopardy
|
CHECKBOX
|
||
Integration Source
|
PICKLIST
|
||
Invoice Created
|
CHECKBOX
|
||
Invoice Number
|
STRING
|
||
Is Entitlement Performed
|
CHECKBOX
|
||
Is Exported
|
CHECKBOX
|
||
Is FCO Work Order
|
CHECKBOX
|
||
Is Partner
|
STRING(FORMULA)
|
||
IsPartnerRecord
|
CHECKBOX
|
||
Is PM Work Order
|
CHECKBOX
|
||
Is Service Covered
|
CHECKBOX
|
||
Last Dispatch Event
|
PICKLIST
|
||
Latitude
|
NUMBER(12,6)
|
||
Life Cycle Status
|
STRING
|
||
LJS Minimum Schedule Duration
|
NUMBER(16,2)
|
||
Locked By DC
|
CHECKBOX
|
||
Lock Appointment Schedule
|
PICKLIST
|
||
Longitude
|
NUMBER(12,6)
|
||
Member Email
|
EMAIL
|
||
Multi-resource
|
CHECKBOX
|
||
No Of Times Assigned
|
NUMBER(18,0)
|
||
No Of Times Queued
|
NUMBER(18,0)
|
||
No Of Times Scheduled
|
NUMBER(18,0)
|
||
Number Of Times Assigned Bucket
|
STRING(FORMULA)
|
||
Number Of Times Queued Bucket
|
STRING(FORMULA)
|
||
Number Of Times Scheduled Bucket
|
STRING(FORMULA)
|
||
Ok To Arrive Early
|
CHECKBOX
|
||
Onsite Response Customer By
|
DATETIME
|
||
Onsite Response Internal By
|
DATETIME
|
||
OptiMax Error Email1
|
EMAIL
|
||
OptiMax Error Email2
|
EMAIL
|
||
OptiMax Error Occurred
|
CHECKBOX
|
||
OptiMax Error Text
|
STRING
|
||
OptiMax Last Run Time
|
DATETIME
|
||
OptiMax Status
|
STRING
|
||
Optimizer Connection Name
|
STRING
|
||
Optimizer Message Creation Date Time
|
DATE/TIME
|
||
Order Status
|
PICKLIST
|
||
Order Type
|
PICKLIST
|
||
Perform Auto Entitlement
|
CHECKBOX
|
||
PM Activity
|
FORMULA(STRING)
|
||
PM Service Contract
|
FORMULA(STRING)
|
||
PM Tasks Created
|
CHECKBOX
|
||
Preferred End Time
|
DATETIME
|
||
Preferred Resource Priority
|
NUMBER(16,2)
|
||
Preferred Start Time
|
DATETIME
|
||
Previous Scheduled Date Time
|
DATETIME
|
||
Priority
|
PICKLIST
|
||
Problem Description
|
STRING
|
||
Proforma Invoice
|
STRING
|
||
Proforma Invoice Amount
|
CURRENCY
|
||
Promised Arrival Window (GMT)
|
STRING
|
||
Purpose of Visit
|
PICKLIST
|
||
QTL Status
|
PICKLIST
|
||
Qualified Technicians
|
STRING
|
||
Rate (Pricing Rule)
|
CURRENCY
|
||
Rate Type (Pricing Rule)
|
PICKLIST
|
||
Recalculate SLA
|
CHECKBOX
|
||
Resolution Customer By
|
DATETIME
|
||
Resolution Internal By
|
DATETIME
|
||
Restoration Customer By
|
DATETIME
|
||
Restoration Internal By
|
DATETIME
|
||
Revised Duration
|
FORMULA
|
||
Root Cause
|
PICKLIST
|
||
Schedule As Dependent Work Order
|
CHECKBOX
|
||
Scheduled Date
|
DATETIME
|
||
Scheduled Date Time
|
DATE/TIME
|
||
Scheduled Duration
|
NUMBER(16,2)
|
||
Schedule Violation Penalty
|
NUMBER(8,2)
|
||
Scheduling Change Token
|
STRING
|
||
Scheduling Options
|
PICKLIST
|
||
Scheduling Retry Count
|
NUMBER(3,0)
|
||
Scheduling Status
|
PICKLIST
|
||
Scope Change
|
NUMBER(16,2)
|
||
Service Duration (in Seconds)
|
NUMBER(16,2)
|
||
Service Zone ID
|
STRING
|
||
SESSION_ID
|
STRING(FORMULA)
|
||
Skill Set
|
STRING
|
||
SLA Clock Extension Minutes
|
NUMBER(18,0)
|
||
SLA Clock Pause Days
|
NUMBER(18,0)
|
||
SLA Clock Pause Hours
|
NUMBER(18,0)
|
||
SLA Clock Pause Minutes
|
NUMBER(18,0)
|
||
SLA Clock Pause Reason
|
PICKLIST
|
||
SLA Clock Pause Restart Time
|
DATE/TIME
|
||
SLA Clock Pause Time
|
DATE/TIME
|
||
SLA Clock Paused
|
CHECKBOX
|
||
SLA Initial Response Time (In Mins)
|
NUMBER
|
||
SLA Onsite Response Time (In Mins)
|
NUMBER
|
||
SLA Resolution Time (In Mins)
|
NUMBER
|
||
SLA Restoration Time (In Mins)
|
NUMBER
|
||
Special Instructions
|
STRING
|
||
Started Driving To Location Date Time
|
DATE/TIME
|
||
State
|
STRING
|
||
Street
|
STRING
|
||
Sub Status
|
PICKLIST
|
||
Symptom
|
PICKLIST
|
||
Time Between Assign And Schedule
|
FORMULA(NUMBER)
|
||
Time Between Assign And Schedule Bucket
|
FORMULA(STRING)
|
||
Time Between Queue And Assign
|
FORMULA(NUMBER)
|
||
Time Between Queue And Assign Bucket
|
FORMULA(STRING)
|
||
Time Between Schedule And Close
|
FORMULA(NUMBER)
|
||
Time Between Schedule And Close Bucket
|
FORMULA(STRING)
|
||
Time To Assign
|
FORMULA
|
||
Time to Assign Bucket
|
FORMULA(STRING)
|
||
Time to Close
|
FORMULA(NUMBER)
|
||
Time to Initial Response(In Minutes)
|
NUMBER(16,2)
|
||
Time to Onsite Response(In Minutes)
|
NUMBER(16,2)
|
||
Time To Queue
|
FORMULA(NUMBER)
|
||
Time to Queue Bucket
|
FORMULA(STRING)
|
||
Time to Resolve(In Minutes)
|
NUMBER(16,2)
|
||
Time to Restore(In Minutes)
|
NUMBER(16,2
|
||
Time To Schedule
|
FORMULA(NUMBER)
|
||
Time to Schedule Bucket
|
FORMULA(STRING)
|
||
Total Overall Cost
|
FORMULA (CURRENCY)
|
||
Travel Rate
|
Currency (15,3)
|
||
Travel Unit
|
PICKLIST
|
||
Turnaround Time
|
FORMULA(STRING)
|
||
Unscheduled Duration
|
FORMULA(NUMBER)
|
||
Variance
|
NUMBER (16.2)
|
||
Version Number
|
NUMBER (18, 0)
|
||
Violation Message
|
STRING
|
||
Violation Status
|
PICKLIST
|
||
Work Performed
|
STRING
|
||
Zip
|
STRING
|