vrpt_WorkOrderCostSummary

Updated January 27, 2026 15:22

Field Name	Field Description	Data Type	FK Join
ContractorPosted	Contractor Posted	decimal
ContractorTotal	Contractor Total	decimal
ContractorTotalRetail	Contractor Total Retail	decimal
ContractorUnposted	Contractor Unposted	decimal
HoursPosted	Total Hours Posted	decimal
HoursTotal	Total Hours	decimal
HoursUnposted	Total Hours Unposted	decimal
Id	Work Order Id	int	vr_WorkOrder
LaborPosted	Total Labor Posted Cost	decimal
LaborTotal	Total Labor Cost	decimal
LaborTotalRetail	Total Labor Retail Cost	decimal
LaborUnposted	Total Labor Unposted Cost	decimal
MaterialPosted	Total Material Posted Cost	decimal
MaterialTotal	Total Material Cost	decimal
MaterialTotalRetail	Total Material Retail Cost	decimal
MaterialUnposted	Total Material Unposted Cost	decimal
OtherPosted	Total Other Posted Cost	decimal
OtherTotal	Total Other Cost	decimal
OtherTotalRetail	Total Other Retail Cost	decimal
OtherUnposted	Total Other Unposted Cost	decimal
wo_number	Work Order Number	nvarchar
wo_pk	Work Order Id	int	vr_WorkOrder
wo_proj_fk	Project Id	int	vr_Project