vrpt_WorkOrderTaskDetail

Updated January 27, 2026 16:28

Field Name	Field Description	Data Type	FK Join
dp_code	Department Code	nvarchar
dp_name	Department Name	nvarchar
fb_code	Building Code	nvarchar
fb_name	Building Name	nvarchar
fd_code	Facility Code	nvarchar
fd_name	Facility Name	nvarchar
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_estimatedcost	Task Estimated Cost	decimal
fo_fj_fk	Task Type Id	int	vr_TaskType
fu_description	Area Description	nvarchar
fu_roomNumber	Area Room Number	nvarchar
fu_unitID	Area Location Id	nvarchar
Id	Work Order Task Id	int	vr_WorkOrderTaskId
itemtype_name	Item Type Name	nvarchar
itemtype_pk	Item Type Id	int	vr_WebTMAItemTypes
pri_code	Priority Code	nvarchar
pri_description	Priority Description	nvarchar
rc_code	Repair Center Code	nvarchar
rc_name	Repair Center Name	nvarchar
tagDescription	Tag Description	nvarchar
tagNumber	Tag Number	nvarchar
TaskContractorCost	Total Contractor Cost for the Task	decimal
TaskHours	Total Hours for the Task	decimal
TaskLabor	Total Labor Cost for the Task	decimal
TaskOther	Total Other Cost for the Task	decimal
TaskParts	Total Part Cost for the Task	decimal
ven_code	Vendor Code	nvarchar
ven_name	Vendor Name	nvarchar
wc_code	Work Order Type Code	nvarchar
wc_description	Work Order Type Description	nvarchar
wc_designated	Work Order Designation	smallint
wo_actionRequested	Action Requested	nvarchar
wo_completionDate	Completion (Closed) Date	datetime
wo_number	Work Order Number	nvarchar
wo_pk	Work Order Id	int	vr_WorkOrder
wo_requestDate	Request Date	datetime
woTask_completionDate	Completion Date (Closed Date)	datetime
woTask_finishDate	Finish Date	datetime
woTask_pk	Work Order Task Id	int	vr_WorkOrderTask
woTask_wo_fk	Work Order Id	int	vr_WorkOrder

Articles in this section