vrpt_WorkOrderDetail

Updated January 27, 2026 15:25

Field Name	Field Description	Data Type	FK Join
closeLapseTimeDay	Lapse Time (Days)	numeric
closeLapseTimeHour	Lapse Time (Hours)	int
finishLapseTimeDay	Lapse Time in Days from Work Order Request Date to Finish Date	int
finishLapseTimeHour	Lapse Time in Hours from Work Order Request Date to Finish Date	int
FullStatus	Concatenated field (Status Description + Status Note)	nvarchar
Id	Work Order Task Id	int	vr_WorkOrderTask
ItemTagId	Item Tag Id	int
ItemTypeId	Item Type Id	int	vr_WebTMAItemTypes
StatusDescription	Status Description	nvarchar
StatusNote	Status Note	nvarchar
wo_actionRequested	Action Requested	nvarchar
wo_charge	Indicates Whether the Work Order is Chargeable or Not	bit
wo_completionDate	Completion (Closed) Date	datetime
wo_createdDate	Record Creation Date	datetime
wo_creator_fk	User Id (Record Creator)	int	vr_users
wo_cst_fk	Account Id	int	vr_account
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_modifiedDate	Last Modified Date	datetime
wo_modifier_fk	User Id (Record Modifier)	int	vr_users
wo_number	Work Order Number	nvarchar
wo_pri_fk	Priority Id	int	vr_Priority
wo_proj_fk	Project Id	int	vr_Project
wo_rc_fk	Repair Center Id	int	vr_RepairCenter
wo_requestDate	Request Date	datetime
wo_requestor	Requestor	nvarchar
wo_requestorPhone	Requestor Phone #	nvarchar
wo_techComments	Tech Comments	nvarchar
wo_wc_fk	Work Order Type Id	int	vr_WorkOrderType
wo_wcs_fk	Work Order Sub Type Id	int	vr_WorkOrderSubType
woTask_completionDate	Completion Date (Closed Date)	datetime
wotask_con_fk	Contract Id	int	vr_contract
woTask_DueDate	Task Due Date	datetime
woTask_fa_fk	Failure Code Id	int	vr_failureCode
woTask_failedPM	Indicates if the PM Failed	bit
woTask_finishDate	Finish Date	datetime
wotask_fo_fk	Task Id	int	vrpt_task
woTask_notLocated	Not Located	bit
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
woTask_workNotDone	Work Not Done	bit

Articles in this section