vrpt_SimpleWorkOrderTask

Updated January 20, 2026 15:18

Field Name	Field Description	Data Type	FK Join
cont_code	Contractor Code	nvarchar
cont_name	Contractor Name	nvarchar
fa_code	Failure Code	nvarchar
fa_description	Failure Description	nvarchar
fa_pk	Failure Code Id	int	vr_failureCode
fas_code	Failure Code	nvarchar
fas_description	Failure Description	nvarchar
fas_pk	Failure Code Id	int	vr_failureCode
fj_code	Task Type Code	nvarchar
fj_description	Task Type Description	nvarchar
fo_averageTime	Task Average Time	decimal
fo_code	Task Code	nvarchar
fo_description	Task Description	nvarchar
fo_pk	Task Id	int	vrpt_task
Id	Work Order Task Id	int	vr_WorkOrderTask
scheduled	Indicates if the record is scheduled	bit
woTask_completionDate	Completion Date (Closed Date)	datetime
wotask_con_fk	Contract Id	int	vr_contract
woTask_dueDate	Task Due Date	datetime
woTask_EstimateTime	Estimated Time	decimal
woTask_failedPM	Indicates if the PM Failed	bit
woTask_finishDate	Finish Date	datetime
woTask_fo_fk	Task Id	int	vrpt_task
woTask_notLocated	Not Located	bit
woTask_pk	Work Order Task Id	int	vr_WorkOrderTask
wotask_ven_fk	Vendor Id	int	vr_Vendor
woTask_wo_fk	Work Order Id	int	vr_WorkOrder
woTask_workNotDone	Work Not Done	bit