General informations

Name: WorkOrder
Label: Work Order
Type: Standard Object
Deployed:

Fields (76)
Name Label Type Description
Id Work Order ID ID
OwnerId Owner ID LOOKUP
IsDeleted Deleted CHECKBOX
WorkOrderNumber Work Order Number AUTO NUMBER
RecordTypeId Record Type ID LOOKUP
CreatedDate Created Date DATETIME
CreatedById Created By ID LOOKUP
LastModifiedDate Last Modified Date DATETIME
LastModifiedById Last Modified By ID LOOKUP
SystemModstamp System Modstamp DATETIME
LastViewedDate Last Viewed Date DATETIME
LastReferencedDate Last Referenced Date DATETIME
AccountId Account ID LOOKUP
ContactId Contact ID LOOKUP
CaseId Case ID LOOKUP
EntitlementId Entitlement ID LOOKUP
ServiceContractId Service Contract ID LOOKUP
AssetId Asset ID LOOKUP
Street Street TEXT AREA(255)
City City TEXT(40)
State State/Province TEXT(80)
PostalCode Zip/Postal Code TEXT(20)
Country Country TEXT(80)
StateCode State/Province Code PICKLIST
CountryCode Country Code PICKLIST
Latitude Latitude NUMBER(3,15)
Longitude Longitude NUMBER(3,15)
GeocodeAccuracy Geocode Accuracy PICKLIST
Address Address AUTO NUMBER
Description Description TEXT AREA (LONG)(32000)
StartDate Start Date DATETIME
EndDate End Date DATETIME
Subject Subject TEXT(255)
RootWorkOrderId Root Work Order ID LOOKUP
Status Status PICKLIST
Priority Priority PICKLIST
Tax Tax CURRENCY(16,2)
Subtotal Subtotal ROLL-UP SUMMARY
TotalPrice Total Price ROLL-UP SUMMARY
LineItemCount Line Items ROLL-UP SUMMARY
Pricebook2Id Price Book ID LOOKUP
Discount Discount PERCENT(3,2)
GrandTotal Grand Total CURRENCY(16,2)
ParentWorkOrderId Parent Work Order ID LOOKUP
IsClosed Is Closed CHECKBOX
IsStopped Stopped CHECKBOX
StopStartDate Stopped Since DATETIME
SlaStartDate Entitlement Process Start Time DATETIME
SlaExitDate Entitlement Process End Time DATETIME
BusinessHoursId Business Hours ID LOOKUP
MilestoneStatus Milestone Status TEXT(30)
Duration Duration NUMBER(16,2)
DurationType Duration Type PICKLIST
DurationInMinutes Duration in Minutes NUMBER(16,2)
ServiceAppointmentCount Service Appointment Count AUTO NUMBER
WorkTypeId Work Type ID LOOKUP
ServiceTerritoryId Territory ID LOOKUP
StatusCategory Status Category PICKLIST
LocationId Location ID LOOKUP
MaintenancePlanId Maintenance Plan ID LOOKUP
SuggestedMaintenanceDate Suggested Maintenance Date DATE
MinimumCrewSize Minimum Crew Size AUTO NUMBER
RecommendedCrewSize Recommended Crew Size AUTO NUMBER
ServiceReportTemplateId Service Report Layout ID LOOKUP
ReturnOrderLineItemId Return Order Line Item ID LOOKUP
ReturnOrderId Return Order ID LOOKUP
IsGeneratedFromMaintenancePlan Generated from maintenance plan CHECKBOX
ServiceReportLanguage Service Report Language PICKLIST
MaintenanceWorkRuleId Maintenance Work Rule ID LOOKUP
AssetWarrantyId Asset Warranty ID LOOKUP
ProductServiceCampaignId Product Service Campaign ID LOOKUP
ProductServiceCampaignItemId Product Service Campaign Item ID LOOKUP
FSL__Scheduling_Priority__c Scheduling Priority FORMULA (NUMBER)(18,0)
FSL__IsFillInCandidate__c Is Fill In Candidate CHECKBOX
FSL__Prevent_Geocoding_For_Chatter_Actions__c Prevent Geocoding For Chatter Actions CHECKBOX
FSL__VisitingHours__c Visiting Hours LOOKUP
Fields Details (76)
Name Id
Label Work Order ID
Type ID
Required Yes
Name OwnerId
Label Owner ID
Type LOOKUP
Foreign key Yes
Required Yes
Name IsDeleted
Label Deleted
Type CHECKBOX
Required Yes
Default value false
Name WorkOrderNumber
Label Work Order Number
Type AUTO NUMBER
Required Yes
Name RecordTypeId
Label Record Type ID
Type LOOKUP
Foreign key Yes
Name CreatedDate
Label Created Date
Type DATETIME
Required Yes
Name CreatedById
Label Created By ID
Type LOOKUP
Foreign key Yes
Required Yes
Name LastModifiedDate
Label Last Modified Date
Type DATETIME
Required Yes
Name LastModifiedById
Label Last Modified By ID
Type LOOKUP
Foreign key Yes
Required Yes
Name SystemModstamp
Label System Modstamp
Type DATETIME
Required Yes
Name LastViewedDate
Label Last Viewed Date
Type DATETIME
Name LastReferencedDate
Label Last Referenced Date
Type DATETIME
Name AccountId
Label Account ID
Type LOOKUP
Foreign key Yes
Name ContactId
Label Contact ID
Type LOOKUP
Foreign key Yes
Name CaseId
Label Case ID
Type LOOKUP
Foreign key Yes
Name EntitlementId
Label Entitlement ID
Type LOOKUP
Foreign key Yes
Name ServiceContractId
Label Service Contract ID
Type LOOKUP
Foreign key Yes
Name AssetId
Label Asset ID
Type LOOKUP
Foreign key Yes
Name Street
Label Street
Type TEXT AREA(255)
Name City
Label City
Type TEXT(40)
Name State
Label State/Province
Type TEXT(80)
Name PostalCode
Label Zip/Postal Code
Type TEXT(20)
Name Country
Label Country
Type TEXT(80)
Name StateCode
Label State/Province Code
Type PICKLIST
Picklist values AC AG AG 05 02 AL AL AK AB AL AP AM AN AN AP 34 23 AO AR AZ AR AR AP AS AT ACT AV BA BC BS BA BT 11 BL BN BG BI BR BO BZ BS BR BC CA CA CL CM CB CI CW CE CT CZ CN CE CH CT CS 12 CH CH 50 CE CO CL CO CO CT CO CS CR KR CN DN DD DE DL DC DF DL D DG 38 EN ES DF FM FE FI FL FG FC FR 35 18 40 07 G 62 GE GA 21 GA GO GO GR GT 44 45 GR 52 GJ 10 46 HR HI 13 23 41 HG HP 34 01 91 42 43 28 08 ID IL IM IN IA IS 17 03 JA JK JH 32 36 22 37 46 14 KS KA KY KL KY KE KK 39 43 26 AQ LD LS SP LT LE LC LM 21 LK LI LO LD LA LH LU 92 MC MP MH ME MN MB MN MA MD MS MA MT MT MS MO MH VS ML ME ME MI MI 24 MI MG MN MS MO 04 45 MZ MO MN MT MB MO NL 20 42 NA 29 NA NE 15 NV NB NL NH NJ NM NSW NY 15 64 NC ND NT NT NO NS NL NU NU OA OR OY OG OH 44 33 47 OK OT ON OR OR 27 PD PA PA PB PR PR PV PA PE PG PU PE PC PI PI PT PN PZ PO PE PY PB PB 63 QC QLD QE QR RG RJ RA RC RE RI RI RN RJ RN RS RM RO RR RN RO 41 11 SA SL SC SP SK SS SV SE 61 37 31 14 25 32 22 51 SI SK SI SO SO SO SA SC SD SR TB 71 TM TN TA TAS TG TN TE TR TX 12 TA TL TO 09 36 13 31 16 TP TN TV TS TR TO UD UT UT UP VA VE VE VB VC VT VR VV VI VIC VA VT 30 WA WD WB WA WH WV WX WW WI WY 65 54 06 35 19 YU YT 53 ZA 33
Name CountryCode
Label Country Code
Type PICKLIST
Picklist values AF AX AL DZ AD AO AI AQ AG AR AM AW AU AT AZ BS BH BD BB BY BE BZ BJ BM BT BO BQ BA BW BV BR IO BN BG BF BI KH CM CA CV KY CF TD CL CN CX CC CO KM CG CD CK CR CI HR CW CY CZ DK DJ DM DO EC EG SV GQ ER EE SZ ET FK FO FJ FI FR GF PF TF GA GM GE DE GH GI GR GL GD GP GT GG GN GW GY HT HM VA HN HU IS IN ID IQ IE IM IL IT JM JP JE JO KZ KE KI KR XK KW KG LA LV LB LS LR LY LI LT LU MO MG MW MY MV ML MT MQ MR MU YT MX MD MC MN ME MS MA MZ MM NA NR NP NL NC NZ NI NE NG NU NF MK NO OM PK PS PA PG PY PE PH PN PL PT QA RE RO RU RW BL SH KN LC MF PM VC WS SM ST SA SN RS SC SL SG SX SK SI SB SO ZA GS SS ES LK SR SJ SE CH TW TJ TZ TH TL TG TK TO TT TN TR TM TC TV UG UA AE GB US UY UZ VU VE VN VG WF EH YE ZM ZW
Name Latitude
Label Latitude
Type NUMBER(3,15)
Name Longitude
Label Longitude
Type NUMBER(3,15)
Name GeocodeAccuracy
Label Geocode Accuracy
Type PICKLIST
Picklist values Address NearAddress Block Street ExtendedZip Zip Neighborhood City County State Unknown
Name Address
Label Address
Type AUTO NUMBER
Name Description
Label Description
Type TEXT AREA (LONG)(32000)
Name StartDate
Label Start Date
Type DATETIME
Name EndDate
Label End Date
Type DATETIME
Name Subject
Label Subject
Type TEXT(255)
Name RootWorkOrderId
Label Root Work Order ID
Type LOOKUP
Foreign key Yes
Name Status
Label Status
Type PICKLIST
Picklist values New In Progress On Hold Completed Closed Cannot Complete Canceled
Name Priority
Label Priority
Type PICKLIST
Picklist values Low Medium High Critical
Name Tax
Label Tax
Type CURRENCY(16,2)
Name Subtotal
Label Subtotal
Type ROLL-UP SUMMARY
Name TotalPrice
Label Total Price
Type ROLL-UP SUMMARY
Name LineItemCount
Label Line Items
Type ROLL-UP SUMMARY
Name Pricebook2Id
Label Price Book ID
Type LOOKUP
Foreign key Yes
Name Discount
Label Discount
Type PERCENT(3,2)
Name GrandTotal
Label Grand Total
Type CURRENCY(16,2)
Name ParentWorkOrderId
Label Parent Work Order ID
Type LOOKUP
Foreign key Yes
Name IsClosed
Label Is Closed
Type CHECKBOX
Required Yes
Default value false
Name IsStopped
Label Stopped
Type CHECKBOX
Required Yes
Default value false
Name StopStartDate
Label Stopped Since
Type DATETIME
Name SlaStartDate
Label Entitlement Process Start Time
Type DATETIME
Name SlaExitDate
Label Entitlement Process End Time
Type DATETIME
Name BusinessHoursId
Label Business Hours ID
Type LOOKUP
Name MilestoneStatus
Label Milestone Status
Type TEXT(30)
Name Duration
Label Duration
Type NUMBER(16,2)
Name DurationType
Label Duration Type
Type PICKLIST
Picklist values Hours Minutes
Name DurationInMinutes
Label Duration in Minutes
Type NUMBER(16,2)
Name ServiceAppointmentCount
Label Service Appointment Count
Type AUTO NUMBER
Name WorkTypeId
Label Work Type ID
Type LOOKUP
Foreign key Yes
Name ServiceTerritoryId
Label Territory ID
Type LOOKUP
Foreign key Yes
Name StatusCategory
Label Status Category
Type PICKLIST
Picklist values New InProgress OnHold Completed Closed None CannotComplete Canceled
Name LocationId
Label Location ID
Type LOOKUP
Foreign key Yes
Name MaintenancePlanId
Label Maintenance Plan ID
Type LOOKUP
Foreign key Yes
Name SuggestedMaintenanceDate
Label Suggested Maintenance Date
Type DATE
Name MinimumCrewSize
Label Minimum Crew Size
Type AUTO NUMBER
Name RecommendedCrewSize
Label Recommended Crew Size
Type AUTO NUMBER
Name ServiceReportTemplateId
Label Service Report Layout ID
Type LOOKUP
Name ReturnOrderLineItemId
Label Return Order Line Item ID
Type LOOKUP
Foreign key Yes
Name ReturnOrderId
Label Return Order ID
Type LOOKUP
Foreign key Yes
Name IsGeneratedFromMaintenancePlan
Label Generated from maintenance plan
Type CHECKBOX
Required Yes
Default value false
Name ServiceReportLanguage
Label Service Report Language
Type PICKLIST
Picklist values en_US de es fr it ja sv ko zh_TW zh_CN pt_BR nl_NL da th fi ru es_MX no
Name MaintenanceWorkRuleId
Label Maintenance Work Rule ID
Type LOOKUP
Foreign key Yes
Name AssetWarrantyId
Label Asset Warranty ID
Type LOOKUP
Foreign key Yes
Name ProductServiceCampaignId
Label Product Service Campaign ID
Type LOOKUP
Foreign key Yes
Name ProductServiceCampaignItemId
Label Product Service Campaign Item ID
Type LOOKUP
Foreign key Yes
Name FSL__Scheduling_Priority__c
Label Scheduling Priority
Type FORMULA (NUMBER)(18,0)
Name FSL__IsFillInCandidate__c
Label Is Fill In Candidate
Type CHECKBOX
Required Yes
Default value true
Name FSL__Prevent_Geocoding_For_Chatter_Actions__c
Label Prevent Geocoding For Chatter Actions
Type CHECKBOX
Required Yes
Default value false
Name FSL__VisitingHours__c
Label Visiting Hours
Type LOOKUP
Foreign key Yes
Parents relationships(33)
Name Parent object Child object Parent object field Child object field
ForecastContext WorkOrder AdvAcctForecastSetUse
  • Id
  • ForecastContextId
  • ResponseContext WorkOrder Assessment
  • Id
  • ResponseContextId
  • ContentContext WorkOrder AssessmentTaskContentDocument
  • Id
  • ContentContextId
  • What WorkOrder ContactRequest
  • Id
  • WhatId
  • FirstPublishLocation WorkOrder ContentVersion
  • Id
  • FirstPublishLocationId
  • ParentRecord WorkOrder DocumentChecklistItem
  • Id
  • ParentRecordId
  • ReferenceObject WorkOrder DocumentEnvelope
  • Id
  • ReferenceObjectId
  • RelatedTo WorkOrder EmailMessage
  • Id
  • RelatedToId
  • ParentEntity WorkOrder EntityMilestone
  • Id
  • ParentEntityId
  • What WorkOrder Event
  • Id
  • WhatId
  • WorkOrder WorkOrder Expense
  • Id
  • WorkOrderId
  • RelatedRecord WorkOrder FlowOrchestrationWorkItem
  • Id
  • RelatedRecordId
  • ReferenceObject WorkOrder GeneratedDocument
  • Id
  • ReferenceObjectId
  • Context WorkOrder GenericVisitTaskContext
  • Id
  • ContextId
  • LinkedEntity WorkOrder LinkedArticle
  • Id
  • LinkedEntityId
  • WorkOrder WorkOrder ProductConsumed
  • Id
  • WorkOrderId
  • WorkOrder WorkOrder ProductRequest
  • Id
  • WorkOrderId
  • WorkOrder WorkOrder ProductRequestLineItem
  • Id
  • WorkOrderId
  • ParentRecord WorkOrder ProductRequired
  • Id
  • ParentRecordId
  • RelatedRecord WorkOrder ResourcePreference
  • Id
  • RelatedRecordId
  • ParentRecord WorkOrder ServiceAppointment
  • Id
  • ParentRecordId
  • RelatedRecord WorkOrder SkillRequirement
  • Id
  • RelatedRecordId
  • Subject WorkOrder SurveySubject
  • Id
  • SubjectId
  • What WorkOrder Task
  • Id
  • WhatId
  • Relation WorkOrder TaskRelation
  • Id
  • RelationId
  • WorkOrder WorkOrder TimeSheetEntry
  • Id
  • WorkOrderId
  • RootWorkOrder WorkOrder WorkOrder
  • Id
  • RootWorkOrderId
  • ParentWorkOrder WorkOrder WorkOrder
  • Id
  • ParentWorkOrderId
  • WorkOrder WorkOrder WorkOrderLineItem
  • Id
  • WorkOrderId
  • WorkOrder WorkOrder WorkPlan
  • Id
  • WorkOrderId
  • ParentRecord WorkOrder WorkPlan
  • Id
  • ParentRecordId
  • WorkOrder WorkOrder WorkStep
  • Id
  • WorkOrderId
  • ParentRecord WorkOrder WorkStep
  • Id
  • ParentRecordId