vrpt_WorkOrderTaskItem

Updated January 27, 2026 16:35

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
fo_averagetime	Task Average Time	decimal
fo_code	Task Code	nvarchar
fo_description	Task Description	nvarchar
fo_estimatedcost	Task Estimated Cost	decimal
fu_description	Area Description	nvarchar
fu_roomNumber	Area Room Number	nvarchar
fu_unitID	Area Location Id	nvarchar
Id	Work Order Id	int	vr_WorkOrder
itemType_name	Item Type Name	nvarchar
itemtype_pk	Item Type Id	int	vr_WebTMAItemTypes
rc_code	Repair Center Code	nvarchar
rc_name	Repair Center Name	nvarchar
tagDescription	Tag Description	nvarchar
tagNumber	Tag Number	nvarchar
TaskHours	Total Labor Hours	decimal
TaskLabor	Total Labor Cost	decimal
TaskLaborRetail	Total Labor Retail Cost	decimal
TaskOther	Total Other Cost	decimal
TaskOtherRetail	Total Other Retail Cost	decimal
TaskParts	Total Parts Cost	decimal
TaskPartsRetail	Total Parts Retail Cost	decimal
ven_isContractor	Is Contractor	bit
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_fb_fk	Building Id	int	vr_building
wo_fd_fk	Facility Id	int	vr_Facility
wo_number	Work Order Number	nvarchar
wo_pk	Work Order Id	int	vr_WorkOrder
wo_rc_fk	Repair Center Id	int	vr_RepairCenter
wo_requestDate	Request Date	datetime
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

Articles in this section