vrpt_AreaRecallsByTech

Updated December 19, 2025 15:49

Field Name	Field Description	Data Type	FK Join
fo_code	Task Code	nvarchar
fo_description	Task Description	nvarchar
fu_description	Area Description	nvarchar
fu_unitID	Area Location Id	nvarchar
fwor_wk_fk	Labor Technician Id	int	vrpt_Technician
Hours	Hours	decimal
Id	Work Order Id	int	vr_WorkOrder
laborcost	Labor Cost	decimal
othercost	Total Other Cost	numeric
partcost	Part Cost	numeric
wc_code	Work Order Type Code	nvarchar
wc_description	Work Order Type Description	nvarchar
wk_firstName	Technician First Name	nvarchar
wk_id	Technician Record Id	nvarchar
wk_lastName	Technician Last Name	nvarchar
WK_NAME	Technician Name	nvarchar
wo_completionDate	Completion (Closed) Date	datetime
wo_fu_fk	Area Record Id	int	vr_area
wo_itemType_fk	Item Type Id	int
wo_number	Work Order Number	nvarchar
wo_pk	Work Order Id	int
wo_requestDate	Request Date	datetime
woTask_fo_fk	Task Id	int	vrpt_task
woTask_wo_fk	Work Order Id	int	vr_WorkOrder