vrpt_ContractorWorkOrder

Updated December 22, 2025 15:04

Field Name	Field Description	Data Type	FK Join
ContractorCost	Contractor Cost	decimal
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
itemType_name	Item Type Name	nvarchar
itemtype_pk	Item Type Id	int
rc_code	Repair Center Code	nvarchar
rc_name	Repair Center Name	nvarchar
tagDescription	Tag Description	nvarchar
tagNumber	Tag Number	nvarchar
TaskHours	Task Hours	decimal
TaskLabor	Task Labor	decimal
TaskLaborRetail	Task Labor Retail	decimal
TaskOther	Task Other	decimal
TaskOtherRetail	Task Other Retail	decimal
TaskParts	Task Parts	decimal
TaskPartsRetail	Task Parts Retail	decimal
ven_code	Vendor Code	nvarchar
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_completionDate	Completion (Closed) Date	datetime
wo_number	Work Order Number	nvarchar
wo_pk	Work Order Id	int	vr_WorkOrder
woTask_completionDate	Completion Date (Closed Date)	datetime
woTask_pk	Work Order Task Id	int	vr_WorkOrderTask
woTask_wo_fk	Work Order Id	int	vr_WorkOrder