v_WorkOrderTaskSimple

Updated November 14, 2025 17:22

Field Name	Field Description	Data Type	FK Join
fo_code	Task Code	nvarchar
fo_description	Task Description	nvarchar
fo_pk	Task Id	int	vrpt_task
ItemTypeId	Item Type Id	int
rts_otherpercentage	Rate Schedule Other Charge Percentage	decimal
rts_partpercentage	Rate Schedule Part Charge Percentage	decimal
rts_pk	Rate Schedule Id	int	vr_rateSchedule
tagDescription	Tag Description	nvarchar
tagNumber	Tag Number	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_number	Work Order Number	nvarchar
wo_pk	Work Order Id	int	vr_WorkOrder
wo_rc_fk	Repair Center Id	int	vr_RepairCenter
wo_ReferenceNumber	Reference Number	nvarchar
wo_requestDate	Request Date	datetime
wo_requestor	Requestor	nvarchar
wo_tax_fk	Tax Rate Id	int	vr_TaxRate
wo_taxCompound	Indicates if the record utilizes tax compound	bit
wo_taxRate	Tax Rate	decimal
wo_taxrate2	Tax Rate 2	decimal
wocstCode	Work Order Account Code	nvarchar
woTask_clnt_fk	Obsolete Column (No Longer Used)	int
woTask_completionDate	Completion Date (Closed Date)	datetime
woTask_con_fk	Contract Id	int	vr_contract
woTask_DueDate	Task Due Date	datetime
woTask_est_endtime	Estimated End Time	datetime
woTask_est_starttime	Estimated Start Time	datetime
woTask_EstimateTime	Estimated Time	decimal
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_foadd_fk	Task Additional Info Id	int
woTask_notLocated	Not Located	bit
woTask_pk	Work Order Task Id	int	vr_WorkOrderTask
woTask_pm_fk	PM Schedule Id	int	vr_PMSchedule
woTask_postDate	Post Date	datetime
woTask_rts_fk	Rate Schedule Id	int	vr_rateSchedule
woTask_SLPostDate	Sub Ledger Post Date	datetime
woTask_ss_fk	Status Id	int	vr_Status
woTask_status	Task Status	nvarchar
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