vrpt_WorkOrderLabor

Updated January 27, 2026 15:30

Field Name	Field Description	Data Type	FK Join
creatorname	Creator Name	nvarchar
cst_code	Account Code	nvarchar
cst_name	Account Name	nvarchar
ftr_code	Trade Code	nvarchar
ftr_description	Trade Description	nvarchar
fwor_beginingxCoordinate	Beginning X Coordinate	nvarchar
fwor_beginingyCoordinate	Beginning Y Coordinate	nvarchar
fwor_chargeRate	Charge Rate	decimal
fwor_createdDate	Record Creation Date	datetime
fwor_endTime	End Time	datetime
fwor_extendedCost	Extended Cost	decimal
fwor_extendedRetail	Extended Retail Cost	decimal
fwor_hours	Hours	decimal
fwor_ipaddress	IP Address	nvarchar
fwor_laborcomments	Work Order Labor Comments	nvarchar
fwor_noCharge	Indicates if the Work Order Labor Line is makred as No Charge or Not	bit
fwor_pk	Work Order Labor Id	int
fwor_postDate	Post Date	datetime
fwor_rateMultiplier	Rate Multiplier	decimal
fwor_SLPostDate	SubLedger Post Date	datetime
fwor_TransDate	Transaction Date	datetime
fwor_xCoordinate	X Coordinate	nvarchar
fwor_yCoordinate	Y Coordinate	nvarchar
Id	Work Order Labor Id	int
shft_code	Shift Code	nvarchar
shft_description	Shift Description	nvarchar
ti_code	Time Type Code	nvarchar
ti_description	Time Type Description	nvarchar
wk_id	Technician Record Id	nvarchar
wk_Name	Technician Name	nvarchar
wo_pk	Work Order Id	int	vr_WorkOrder
woTask_completionDate	Completion Date (Closed Date)	datetime
woTask_failedPM	Indicates if the PM Failed	bit
woTask_finishDate	Finish Date	datetime
woTask_notLocated	Not Located	bit
woTask_workNotDone	Work Not Done	bit