vr_WorkOrderCost

Updated February 05, 2026 16:34

Field Name	Field Description	Data Type	FK Join
AccountCode	Account Code	nvarchar
AccountName	Account Name	nvarchar
CostType	Cost Type	varchar
HasLaborAdjust	Indicates if this Work Order Cost has a labor adjustment	bit
Hours	Hours	decimal
ItemDescription	Item Description	nvarchar
LineID	Line Id	int
PostDate	Post Date	datetime
Quantity	Quantity	decimal
SLPostDate	Sub Ledger Post Date	datetime
TaskCode	Task Code	nvarchar
TaskDescription	Task Description	nvarchar
Taxable	Indicates if this Work Order Cost is taxable	bit
TaxAmount	Tax Amount	decimal
TotalCost	Total Cost	decimal
TotalRetail	Total Retail Cost	decimal
TransDate	Transaction Date	datetime
UnitCost	Unit Cost	decimal
UnitOfMeasure	Unit of Measure	nvarchar
WorkOrderAreaID	Area Id	int	vr_area
WorkOrderBuildingID	Building Id	int	vr_building
WorkOrderFacilityID	Facility Id	int	vr_facility
WorkOrderFloorID	Floor Id	int	vr_floor
WorkOrderNumber	Work Order Number	nvarchar
WorkOrderRepairCenterID	Repair Center Id	int	vr_RepairCenter
WorkOrderTaskID	Work Order Task Id	int	vr_WorkOrderTask
WorkOrderTaskWorkOrderID	Work Order Id	int	vr_WorkOrder