vrpt_WorkOrderTaskFullDetail

Updated January 27, 2026 16:34

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
ContractorId	Contractor Id	int
ContractorName	Contractor Name	nvarchar
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
DueDate	Task Due Date	datetime
EstimatedEndTime	Estimated End Time	datetime
EstimatedStartTime	Estimated Start Time	datetime
EstimateTime	Estimated Time	decimal
FailedPM	Indicates if the PM Failed	bit
FailureCodeCode	Failure Code Code	nvarchar
FailureCodeDescription	Failure Code Description	nvarchar
FailureCodeId	Failure Code Id	int	vr_failureCode
FailureCodeManual	Indicates if the record has a failure code manual	bit
FailureCodeRequireCorrective	Indicates if the Task Failure Code requires a corrective work order	bit
FailureSubCodeCode	Failure Code Sub Code	nvarchar
FailureSubCodeDescription	Failure Code Sub Code Description	nvarchar
FailureSubCodeId	Failure Code Sub Code Id	int
FinishDate	Work Order Task Finish Date	datetime
GenInspectionResultId	General Inspection Result Id	int	vrpt_GenInspectionResult
Id	Work Order Task Id	int	vr_WorkOrderTask
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	Indicates if the Key is Serialized or Not	bit
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
NotLocated	Not Located	bit
OtherResolution	Other Resolution	nvarchar
PMScheduleId	PM Schedule Id	int	vr_PMSchedule
PostDate	Post Date	datetime
Processed	Processed	bit
RateScheduleCode	Rate Schedule Code	nvarchar
RateScheduleDescription	Rate Schedule Description	nvarchar
RateScheduleId	Rate Schedule Id	int	vr_rateSchedule
RequireAcknowledgement	Indicates if the Work Order Requires Acknowledgement or Not	bit
ResolutionDescription	Resolution Description	nvarchar
ResolutionId	Resolution Id	int	vr_Resolution
ResolutionRequireGeneralComment	Indicates if the Resolution Selected Requires General Comments	bit
Scheduled	Indicates if the Task is Scheduled or Not	bit
SLPostDate	Sub Ledger Post Date	datetime
TaskBaseRequireResolution	Indicates if the Task Requires Base Resolution	bit
TaskCode	Task Code	nvarchar
TaskDescription	Task Description	nvarchar
TaskDuration	Task Duration	decimal
TaskHasTaskSheet	Indicates if the Task Has a Task Sheet	bit
TaskId	Task Id	int	vrpt_Task
TaskIsKey	Indicates if the Task is used for Keys	bit
TaskRequireKBResolution	Indicates if the Task Requires KB Resolution	bit
TaskSubTypeId	Task SubType Id	int
TaskTypeCode	Task Type Code	nvarchar
TaskTypeDescription	Task Type Description	nvarchar
TaskTypeId	Task Type Id	int	vr_TaskType
TradeCode	Trade Code	nvarchar
TradeDescription	Trade Description	nvarchar
TradeId	Trade Id	int	vr_Trade
WorkNotDone	Work Not Done	bit
WorkOrderId	Work Order Id	int	vr_WorkOrder
WorkOrderNumber	Work Order Number	nvarchar

Articles in this section