vrpt_WorkOrderTaskTradeFor

Updated January 27, 2026 16:39

Field Name	Field Description	Data Type	FK Join
fb_code	Building Code	nvarchar
fb_name	Building Name	nvarchar
fd_code	Facility Code	nvarchar
fd_name	Facility Name	nvarchar
fo_averagetime	Task Average Time	decimal
fo_code	Task Code	nvarchar
fo_description	Task Description	nvarchar
fo_estimatedcost	Task Estimated Cost	decimal
ftr_code	Trade Code	nvarchar
ftr_description	Trade Description	nvarchar
ftr_pk	Trade Id	int	vr_Trade
fu_unitID	Area Location Id	nvarchar
FullStatus	Concatenated field (Status Description + Status Note)	nvarchar
Id	Work Order Task Id	int	vr_WorkOrderTask
rc_code	Repair Center Code	nvarchar
rc_name	Repair Center Name	nvarchar
sh_code	Shop Code	nvarchar
sh_name	Shop Name	nvarchar
StatusDescription	Status Description	nvarchar
StatusNote	Status Note	nvarchar
wc_code	Work Order Type Code	nvarchar
wc_description	Work Order Type Description	nvarchar
wo_actionRequested	Action Requested	nvarchar
wo_completionDate	Completion (Closed) Date	datetime
wo_finishDate	Finish Date	datetime
wo_number	Work Order Number	nvarchar
wo_pk	Work Order Id	int	vr_WorkOrder
wo_requestDate	Request Date	datetime
wo_requestor	Requestor	nvarchar
wo_techComments	Tech Comments	nvarchar
woTask_completionDate	Completion Date (Closed Date)	datetime
woTask_pk	Work Order Task Id	int	vr_WorkOrderTask
woTask_wo_fk	Work Order Id	int	vr_WorkOrder