vrpt_WorkOrderListReportWizard

Updated January 27, 2026 16:13

Field Name	Field Description	Data Type	FK Join
departmentCode	Department Code	nvarchar
departmentName	Department Name	nvarchar
fb_code	Building Code	nvarchar
fb_name	Building Name	nvarchar
fd_code	Facility Code	nvarchar
fd_name	Facility Name	nvarchar
ff_code	Floor Code	nvarchar
ff_description	Floor Description	nvarchar
fo_code	Task Code	nvarchar
fo_description	Task Description	nvarchar
ftr_code	Trade Code	nvarchar
ftr_description	Trade Description	nvarchar
fu_description	Area Description	nvarchar
fu_unitID	Area Location Id	nvarchar
FullStatus	Concatenated field (Status Description + Status Note)	nvarchar
pri_code	Priority Code	nvarchar
pri_description	Priority Description	nvarchar
rc_code	Repair Center Code	nvarchar
rc_name	Repair Center Name	nvarchar
StatusDescription	Status Description	nvarchar
StatusNote	Status Note	nvarchar
tagDescription	Tag Description	nvarchar
tagNumber	Tag Number	nvarchar
wc_code	Work Order Type Code	nvarchar
wc_description	Work Order Type Description	nvarchar
wk_fullname	Technician Full Name	nvarchar
wo_actionRequested	Action Requested	nvarchar
wo_completionDate	Completion (Closed) Date	datetime
wo_dp_fk	Department Id	int	vr_Department
wo_fb_fk	Building Id	int	vr_building
wo_fd_fk	Facility Id	int	vr_Facility
wo_ff_fk	Floor Record Id	int	vr_floor
wo_fu_fk	Area Record Id	int	vr_area
wo_itemType_fk	Item Tye Id	int
wo_number	Work Order Number	nvarchar
wo_pk	Work Order Id	int	vr_WorkOrder
wo_ReferenceNumber	Reference Number	nvarchar
wo_requestDate	Request Date	datetime
wo_requestor	Requestor	nvarchar
wo_status	Work Order Status Note	nvarchar
wo_tag_fk	Item Id	int
wos_duration	Work Order Task Schedule Duration	decimal
woTask_failedPM	Indicates if the PM Failed	bit
woTask_notLocated	Not Located	bit

Articles in this section