vrpt_WorkOrderLaborWithWOInfo

Updated January 27, 2026 15:53

Field Name	Field Description	Data Type	FK Join
AccountCode	Account Code	nvarchar
AccountId	Account Id	int	vr_account
AccountName	Account Name	nvarchar
ActionRequested	Action Requested	nvarchar
ApplyMultiplier	Apply Multiplier	bit
ApprovedDate	Approved Date	datetime
approverName	Approver Name	nvarchar
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
ChargeRate	Charge Rate	decimal
ClassId	Class Id	int	vrpt_ClassList
CompletionDate	Completion (Closed) Date	datetime
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
ExtendedCost	Extended Cost	decimal
ExtendedRetail	Extended Retail Cost	decimal
FailedPM	Indicates if the PM Failed	bit
hasLaborAdj	Indicates if the Labor Line has a Labor Adjustment or Not	bit
HierarchyLevel	Hierarchy Level	nvarchar
Hours	Hours	decimal
Id	Work Order Labor Id	int	vr_WorkOrderLabor
IndirectHours	Indirect Hours	decimal
ipAddress	IP Address	nvarchar
ItemId	Item Id	int
ItemTagNumber	Item Tag Number	nvarchar
ItemTypeId	Item Type Id	int	vr_WebTMAItemTypes
LaborComment	Labor Comment	nvarchar
LaborPercentage	Labor Percentage	decimal
LeaseBatchJobId	Lease Batch Job Id	int
LocationCode	Location Code	nvarchar
LocationId	Location Id	int
LocationName	Location Name	nvarchar
LocationTypeId	Location Type 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
RateMultiplier	Rate Multiplier	decimal
ReferenceNumber	Reference Number	nvarchar
RequestDate	Request Date	datetime
Requestor	Requestor	nvarchar
ResolutionId	Resolution Id	int	vr_taskResolution
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 Record has an Email or Not	bit
TechnicianId	Technician Id	int	vrpt_Technician
TechnicianName	Technician Name	nvarchar
TechnicianWorkGroupId	Work Group Id	int
TimeSubTypeCode	Time SubType Code	nvarchar
TimeSubTypeDescription	Time SubType Description	nvarchar
TimeSubTypeId	Time SubType Id	int
TimeTypeChargeRate	Time Type Charge Rate	decimal
TimeTypeCode	Time Type Code	nvarchar
TimeTypeDescription	Time Type Description	nvarchar
TimeTypeEarnsCompTime	Indicates if the Time Type Earns Comp Time or Not	bit
TimeTypeId	Time Type Id	int	vr_TimeType
TimeTypeProductiveTime	Indicates if the Time Type is used for Productive Time (Work Order Time)	bit
TradeCode	Trade Code	nvarchar
TradeDescription	Trade Description	nvarchar
TradeId	Trade Id	int	vr_Trade
TransDateTime	Transaction Date Time	datetime
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
WorkOrderRepairCenterId	Repair Center Id	int	vr_RepairCenter
WorkOrderTaskId	Work Order Task Id	int	vr_WorkOrderTask
WorkOrderTaskScheduleId	Work Order Task Schedule Id	int	vrpt_Workordertaskschedule
XCoordinate	X Coordinate	nvarchar
YCoordinate	Y Coordinate	nvarchar

Articles in this section