vr_WorkOrderLabor

Updated February 05, 2026 16:36

Field Name	Field Description	Data Type	FK Join
AccountCode	Account Code	nvarchar
AccountId	Account Id	int	vr_account
AccountName	Account Name	nvarchar
ApplyMultiplier	Apply Multiplier	bit
ApprovedDate	Approved Date	datetime
ApproverId	User Id (Approver)	int	vr_Users
approverName	Approver Name	varchar
BatchJobId	Batch Job Id	int	vr_BatchJob
BatchNumber	Batch Number	int
BeginingXCoordinate	Beginning X Coordinate	nvarchar
BeginingYCoordinate	Beginning Y Coordinate	nvarchar
Charge	Indicates Whether the Work Order is Chargeable	bit
ChargeHours	Hours	decimal
ChargeRate	Charge Rate	decimal
CloseDateLocked	Close Date Locked	bit
CostRate	Cost Rate	decimal
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
CrewId	Crew Id	int	vrpt_crew
CurrencyExchangeDate	Currency Exchange Date	datetime
CurrencyExchangeId	Currency Exchange Id	int
CurrencyId	Currency Id	int	vrpt_Currency
Differential	Differential	decimal
DirectHours	Direct Hours	decimal
ExtendedBaseCost	Extended Base Cost	decimal
ExtendedBaseRetail	Extended Base Retail	decimal
ExtendedCost	Extended Cost	decimal
ExtendedRetail	Extended Retail	decimal
FailedPM	Indicates if the PM Failed	bit
HierarchyLevel	Hierarchy Level	nvarchar
Hours	Hours	decimal
Id	Work Order Labor Id	int
IndirectHours	Indirect Hours	decimal
ipAddress	IP Address	nvarchar
LaborComment	Labor Comment	nvarchar
LaborPercentage	Labor Percentage	decimal
LeaseBatchJobId	Lease Batch Job Id	int
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Nocharge	No Charge	bit
NotLocated	Not Located	bit
PositionCode	Position Code	nvarchar
PositionDescription	Position Description	nvarchar
PositionId	Position Id	int	vr_Position
PostDate	Post Date	datetime
PriorityId	Priority Id	int	vr_Priority
RateMultiplier	Rate Multiplier	decimal
ResolutionId	Resolution Id	int	vr_Resolution
ShiftCode	Shift Code	nvarchar
ShiftDescription	Shift Description	nvarchar
ShiftId	Shift Id	int	vr_shift
SLPostDate	Sub Ledger Post Date	datetime
TaskCode	Task Code	nvarchar
TaskCompletionDate	Task Completion Date	datetime
TaskDescription	Task Description	nvarchar
TaskFinishDate	Task Finish Date	datetime
TaskId	Task Id	int	vrpt_Task
Taxable	Indicates if this Work Order Labor is taxable	bit
TaxAmount	Tax Amount	decimal
TechnicianChargeRate	Technician Charge Rate	decimal
TechnicianCode	Technician Code	nvarchar
TechnicianHasEmail	Indicates if the Technician has email	bit
TechnicianId	Technician Id	int	vrpt_Technician
TechnicianName	Technician Name	nvarchar
TechnicianWorkGroupId	Technician Work Group Id	int
TimeSubTypeCode	Time Sub Type Code	nvarchar
TimeSubTypeDescription	Time Sub Type Description	nvarchar
TimeSubTypeId	Time Sub Type Id	int
TimeTypeChargeRate	Time Type Charge Rate	decimal
TimeTypeCode	Time Type Code	nvarchar
TimeTypeDescription	Time Type Description	nvarchar
TimeTypeEarnsCompTime	Indicates if the time type allows comp time	bit
TimeTypeId	Time Type Id	int	vr_timeType
TimeTypeProductiveTime	Indicates if the time type is productive time	bit
TradeCode	Trade Code	nvarchar
TradeDescription	Trade Description	nvarchar
TradeId	Trade Id	int	vr_Trade
TransDateTime	Trans Date Time	datetime
UIExport	UI Export	bit
WorkNotDone	Work Not Done	bit
WorkOrderBuildingId	Building Id	int	vr_building
WorkOrderFacilityId	Facility Id	int	vr_facility
WorkOrderId	Work Order Id	int	vr_WorkOrder
WorkOrderNumber	Work Order Number	nvarchar
WorkOrderProjectId	Project Id	int	vr_project
WorkOrderRepairCenterId	Repair Center Id	int	vr_RepairCenter
WorkOrderTaskId	Work Order Task Id	int	vr_WorkOrderTask
WorkOrderTaskScheduleId	Work Order Task Schedule Id	int	vrpt_Workordertaskschedule
WorkOrderTypeId	Work Order Type Id	int	vr_WorkOrderType
XCoordinate	X Coordinate	nvarchar
YCoordinate	Y Coordinate	nvarchar

Articles in this section