xMatix
Sign in Request demo
xMatix
PRODUCTS
SalesField SalesCRMRewardsClaimsInventoryProcurementWarehouse ManagementField ServiceServiceSupportTelephony & MessagingFinance & AccountingPayrollExpense ManagementCommercePortalsAnalytics & ReportingData StudioMobile AppSee all products →
PLATFORM
Platform overviewApp BuilderAutomationIntegrationsSecurity & GovernanceChange ManagementDevelopers
SENSE AI
Sense AI overviewSense AssistSense ControlSense VisionAI StudioTrust & governanceIn Claude & ChatGPTUse cases
SOLUTIONS
FMCG & DistributionManufacturing & Dealer NetworksAutomotive & DealershipsPharma & HealthcareConsumer DurablesAgri-InputsBuilding MaterialsService NetworksWarehousing & 3PLFinancial AccountingERP SoftwareIndia GST ComplianceUAE VAT & e-InvoicingSaudi ZATCA & VATAll solutions →
RESOURCES
Knowledge CenterDeveloper & CLIBlogGuidesWhat is xMatix?Company facts
COMPANY
AboutCareersPartnersEventsContactAuthorsLegal
Sign in Request demo
Home/Docs/Entity Reference/Service Order Time Sheet — entity reference
REFERENCE · Last reviewed

Service Order Time Sheet — entity reference

A labour-capture sheet attached to a service order, created by the service order's Create Time Sheet action; one sheet is raised per invocation with a child ServiceOrderTimeSheetLine for every selected line whose Item is a Work Item (part lines are excluded). The sheet carries the work-stage flags WorkStarted/WorkPaused/WorkEnded and their dates, and its own server actions stamp the selected sheet lines and then raise the matching IsWorkStarted/IsWorkPaused/IsWorkEnded flag on the parent service order once every line has reached that stage. It does not price or bill anything — hours are read by resource-wise profitability reporting, while invoicing still comes from the service order lines.

Fields

FieldLabelTypeRequiredWhat it does
ActualDurationHoursActual Duration HoursCalculated (calculated)Roll-up of the actual hours on the sheet's lines. It is a protected system field — the handler rejects direct edits — so change the underlying line hours instead.
CreatedByIdCreated ByLookup → UserAccountYes
CreatedDateTimeCreated DateDateAndTimeYes
ExternalIdExternalText, unique
IdIdGuidYes
ModifiedByIdModified ByLookup → UserAccountYes
NameNameTextYes
OwnerIdOwnerLookup → UserAccountYes
RecordTypeIdRecord TypeGuid, hidden
RepairPauseReasonWork Pause ReasonPickListValues: Paused-Non Availability of Stock.
ResourceIdResourceLookup → ResourceThe default technician for the sheet, copied from the parent service order's Resource when the sheet is created. A sheet line with its own resource overrides it for that line's hours.
ServiceOrderIdService OrderLookup → ServiceOrderYes
ServiceOrderLineIdService Order LineLookup → ServiceOrderLineAn optional single service order line the whole sheet relates to. Profitability only falls back to it when the sheet has no lines of its own naming the work — normally attribution comes from the sheet lines.
StandardDurationHoursStandard Duration HoursCalculated (calculated)
UIPropsUI PropsText
UpdatedDateTimeModified DateDateAndTimeYes
WorkEndDateWork End DateDateAndTime
WorkEndedWork EndedBooleanYesSet when work on the sheet has finished; it raises the parent service order's IsWorkEnded flag, and only once every line of the sheet carries a work end date.
WorkPausedWork PausedBooleanYes
WorkPauseDateWork Pause DateDateAndTime
WorkRemarksWork RemarksText
WorkStartDateWork Start DateDateAndTime
WorkStartedWork StartedBooleanYesSet when the sheet's work has begun, and mirrored up onto the parent service order's IsWorkStarted. It is raise-only at the order level, so clearing it here does not clear the order's flag.
WorkStatusWork StatusCalculated (calculated)Derived stage of the sheet: the service writes Started when work has begun, Paused when it is paused and Completed when it has ended. None of those three values are in this field's seeded picklist, which offers only two paused reasons, so filtering on the seeded values will not match what the engine writes. Values: Work Started, Work Paused, Work Ended.

Actions

ActionLabelTypeWhat it does
BulkDeleteDeleteDeleteDelete
CloneCloneServerAction (Clone)Create a copy of this record
DeleteDeleteDeleteDelete
DeleteInListDeleteDeleteDelete
EditEditEditEdit
Edit1EditEditInlineEdit
EditEntityEditEditEdit Entity
EditInLineEditEditEdit
EditInLineEntityEditEditInlineEditInLine Entity
EndEndServerAction (PerformWorkEnd)End Work
NewNewNewNew
PausePauseServerAction (PerformWorkPause)Pause Work
StartStartServerAction (PerformWorkStart)Start Work

Validations

ValidationApplies toError messageNotes
Work Pause Reason RequiredRepairPauseReason, ErrorWork Pause Reason is required when the work is set to Paused.Work Pause Reason is required when the work is set to Paused.
Work End Validation RuleWorkStartDate, ErrorWork End Date cannot be before Work Start DateWork End Date cannot be before Work Start Date
Work Pause Validation RuleWorkStartDate, ErrorWork Pause Date cannot be before Work Start DateWork Pause Date cannot be before Work Start Date
Work must be started before pause/endWorkStarted, ErrorWork cannot be paused or ended before it has been started.Work cannot be paused or ended before it is started.