vr_WorkOrderTask

Updated February 05, 2026 16:42

Field Name	Field Description	Data Type	FK Join
AcknowledgedDate	Acknowledged Date	datetime
AcknowledgedInitials	Acknowledged Initials	nvarchar
AcknowledgedUserId	User Id (Acknowledged By)	int	vr_Users
AcknowledgedUserName	Acknowledged Users Name	nvarchar
AdditionalInfoDescription	Additonal Info	nvarchar
AdditionalInfoId	Additional Info Id	int
AutoSyncFromMobile	Auto Sync From Mobile Device	bit
CompletionDate	Completion (Closed) Date	datetime
ContractId	Contract Id	int	vr_contract
ContractNumber	Contract Number	nvarchar
ContractorCode	Contractor Code	nvarchar
ContractorCost	Contractor Cost	decimal
ContractorId	Contractor Id	int
ContractorName	Contractor Name	nvarchar
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
DueDate	Due Date	datetime
EstimatedEndTime	Estimated End Time	datetime
EstimatedStartTime	Estimated Start Time	datetime
EstimateTime	Estimate Time	decimal
FailedPM	Indicates if the PM Failed	bit
FailureCodeCode	Failure Code	nvarchar
FailureCodeDescription	Failure Code Description	nvarchar
FailureCodeId	Failure Code Id	int	vr_failureCode
FailureCodeManual	Failure Code Manual	bit
FailureCodeRequireCorrective	Failure Code Require Corrective	bit
FailureSubCodeCode	Failure Sub Code	nvarchar
FailureSubCodeDescription	Failure Sub Code Description	nvarchar
FailureSubCodeId	Failure Sub Code Id	int
FinishDate	Finish Date	datetime
GenInspectionResultId	General Inspection Result Id	int	vrpt_GenInspectionResult
Id	Work Order Task Id	int
KBResolutionDescription	Knowledge Base Resolution Description	nvarchar
KBResolutionId	Knowledge Base Resolution Id	int
KeyDescription	Key Description	nvarchar
KeyHolderCode	Key Holder Code	nvarchar
KeyHolderId	Key Holder Id	int	vr_KeyHolder
KeyHolderName	Key Holder Name	nvarchar
KeyId	Key Id	int	vr_Key
KeyNumber	Key Number	nvarchar
KeySerialized	Key Serialized	bit
LaborCost	Labor Cost	decimal
LaborHours	Labor Hours	decimal
MaterialCost	Total Material Cost	decimal
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
NotLocated	Not Located	bit
OtherCost	Total Other Cost	decimal
OtherResolution	Other Resolution	nvarchar
PMScheduleId	PM Schedule Id	int	vr_PMSchedule
PostDate	Post Date	datetime
Processed	Indicates if the record is processed	bit
RateScheduleCode	Rate Schedule Code	nvarchar
RateScheduleDescription	Rate Schedule Description	nvarchar
RateScheduleId	Rate Schedule Id	int	vr_rateSchedule
ReAuthClosedDate	ReAuthorization Closed Date	datetime
ReAuthClosedUserId	ReAuthorization Closed User Id	int	vr_users
ReAuthFinishedDate	ReAuthorization Finished Date	datetime
ReAuthFinishedUserId	ReAuthorization Finished User Id	int	vr_users
RequireAcknowledgement	Indicates if the record requires acknowledgement	bit
ResolutionDescription	Resolution Description	nvarchar
ResolutionId	Resolution Id	int	vr_Resolution
ResolutionRequireGeneralComment	Indicates if the record requires a general comment for resolution	bit
Scheduled	Scheduled Flag	bit
SLPostDate	Sub Ledger Post Date	datetime
TaskBaseRequireResolution	Indicates if the record requires a resolution	bit
TaskCode	Task Code	nvarchar
TaskDescription	Task Description	nvarchar
TaskDuration	Task Duration	decimal
TaskHasTaskSheet	Indicates if the record has a task sheet	bit
TaskId	Task Id	int	vrpt_Task
TaskIsKey	Indicates if the record is key	bit
TaskRequireFailureCode	Indicates if the record requires a failure code	bit
TaskRequireKBResolution	Indicates if the record requires knowledge base resolution	bit
TaskSubTypeId	Task Sub Type Id	int
TaskTypeCode	Task Type Code	nvarchar
TaskTypeDescription	Task Type Description	nvarchar
TaskTypeId	Task Type Id	int	vr_TaskType
WorkNotDone	Work Not Done	bit
WorkOrderId	Work Order Id	int	vr_WorkOrder

Articles in this section