v_WorkOrderLaborList

Updated November 14, 2025 17:15

Field Name	Field Description	Data Type	FK Join
approverName	Approver Name	nvarchar
chargeRate	Charge Rate	decimal
class_description	Class Description	nvarchar
class_ID	Classs Unique Id	nvarchar
crw_description	Crew Description	nvarchar
crw_tagNumber	Crew Tag Number	nvarchar
cst_code	Account Code	nvarchar
cst_name	Account Name	nvarchar
fa_code	Failure Code Code	varchar
fa_description	Failure Code Description	varchar
fa_pk	Failure Code Id	int	vr_failureCode
fas_code	Failure Code Sub Code	varchar
fas_description	Failure Code Sub Code Description	varchar
fas_pk	Failure Code Sub Code Id	int
fj_code	Task Type Code	nvarchar
fj_description	Task Type Description	nvarchar
fj_pk	Task Type Id	int	vr_TaskType
fo_code	Task Code	nvarchar
fo_description	Task Description	nvarchar
fo_pk	Task Id	int	vrpt_task
ftr_code	Trade Code	nvarchar
ftr_description	Trade Description	nvarchar
fwor_applyMultiplier	Apply Rate Multiplier from Time Type	bit
fwor_approvedDate	Approved Date	datetime
fwor_approver_fk	User Id (Approver)	int	vr_users
fwor_batchID	Sub Ledger Batch Id	int
fwor_beginingxCoordinate	Beginning X Coordinate	nvarchar
fwor_beginingyCoordinate	Beginning Y Coordinate	nvarchar
fwor_bj_fk	Batch Job Id	int	vr_BatchJob
fwor_chargeAccountNeeded	Charge Account Needed	varchar
fwor_chargeRate	Charge Rate	decimal
fwor_class_fk	Status Id	int	vr_Status
fwor_clnt_fk	Obsolete Column (No Longer Used)	int
fwor_contractBaseRate	Contract Base Rate	decimal
fwor_costRate	Cost Rate	decimal
fwor_createdDate	Record Creation Date	datetime
fwor_creator_fk	User Id (Record Creator)	int	vr_Users
fwor_crw_fk	Crew Id	int	vrpt_crew
fwor_cst_fk	Account Id	int	vr_account
fwor_curr_fk	Currency Id	int	vrpt_Currency
fwor_differential	Differential	decimal
fwor_endTime	End Time	datetime
fwor_exch_date	Currency Exchange Date	datetime
fwor_exch_fk	Currency Exchange Id	int
fwor_extendedCost	Extended Cost	decimal
fwor_extendedRetail	Extended Retail Cost	decimal
fwor_ftr_fk	Trade Id	int	vr_Trade
fwor_hours	Hours	decimal
fwor_ipaddress	IP Address	nvarchar
fwor_laborComments	Labor Comments	nvarchar
fwor_lease_bj_fk	Lease Batch Job Id	int	vr_BatchJob
fwor_modifiedDate	Last Modified Date	datetime
fwor_modifier_fk	User Id (Record Modifier)	int	vr_users
fwor_noCharge	Indicates if the Line is No Charge (Non Chargeable) or Not	bit
fwor_pk	Work Order Labor Line Id	int
fwor_pos_fk	Postion Id	int	vr_Position
fwor_postDate	Post Date	datetime
fwor_rateHierarchyLevel	Rate Hiearchy Level	nvarchar
fwor_rateMultiplier	Rate Multiplier	decimal
fwor_rcoverridetechrate	Repair Center Override Technician Rate	bit
fwor_repaircenterMultiplier	Repair Center Multiplier	bit
fwor_repaircenterRate	Repair Center Rate	decimal
fwor_shft_fk	Shift Id	int	vr_Shift
fwor_SLPostDate	Sub Ledger Post Date	datetime
fwor_tassgn_fk	Training Assignment Id	int	vrpt_trainingAssignmentList
fwor_taxable	Indicates if this Work Order Labor is taxable	bit
fwor_taxAmount	Tax Amount	decimal
fwor_ti_fk	Time Type Id	int	vr_TimeType
fwor_transDate	Transaction Date	datetime
fwor_uiexport	UI Export	bit
fwor_wk_fk	Technician Id	int	vrpt_Technician
fwor_wos_fk	Work Order Task Schedule Id	int	vrpt_workordertaskschedule
fwor_woTask_fk	Work Order Task Id	int	vr_WorkOrderTask
fwor_wotypepercentage	Work Order Type Percentage	decimal
fwor_xCoordinate	X Coordinate	nvarchar
fwor_yCoordinate	Y Coordinate	nvarchar
hasanyemail	Has Any Email	bit
hasLaborAdj	Has Labor Adjustment	bit
itemType_name	Item Type Name	nvarchar
pos_code	Position Code	nvarchar
rc_code	Repair Center Code	nvarchar
rc_dupeCheck	Repair Center Dupe Check	bit
rc_name	Repair Center Name	nvarchar
rc_positionBasedrate	Repair Center Position Based Rate	bit
shft_code	Shift Code	nvarchar
shft_description	Shift Description	nvarchar
shft_differential	Shift Differential	decimal
ta_fa_fk	Failure Code Id	int	vr_failureCode
tagDescription	Tag Description	nvarchar
tagNumber	Tag Number	nvarchar
ti_alltime	All Time (Constant Value of 1)	int
ti_chargerate	Time Type Charge Rate	decimal
ti_code	Time Type Code	nvarchar
ti_description	Time Type Description	nvarchar
ti_earnsCompTime	Earns Comp Time	bit
ti_nonproductivetime	Non Productive Time	int
ti_pk	Time Type Id	int	vr_TimeType
ti_productiveTime	Productive Time	bit
tis_code	Time Type Sub Type Code	nvarchar
tis_description	Time Type Sub Type Description	nvarchar
tis_pk	Time Type Sub Type Id	int
wk_id	Technician Record Id	nvarchar
wk_Name	Technician Name	nvarchar
wo_actionRequested	Action Requested	nvarchar
wo_charge	Indicates Whether the Work Order is Chargeable or Not	bit
wo_completionDate	Completion (Closed) Date	datetime
wo_finishDate	Finish Date	datetime
wo_itemType_fk	Item Type Id	int
wo_loc	Work Order Location	nvarchar
wo_number	Work Order Number	nvarchar
wo_pk	Work Order Id	int	vr_WorkOrder
wo_rc_fk	Repair Center Id	int	vr_RepairCenter
wo_ReferenceNumber	Reference Number	nvarchar
wo_requestDate	Request Date	datetime
wo_requestor	Requestor	nvarchar
wo_status	Work Order Status Note	nvarchar
woPKForMobile	Work Order Id	int	vr_WorkOrder
woTask_completionDate	Completion Date (Closed Date)	datetime
woTask_fa_fk	Failure Code Id	int	vr_failureCode
woTask_failedPM	Indicates if the PM Failed	bit
woTask_finishDate	Finish Date	datetime
woTask_notLocated	Not Located	bit
wotasK_pm_fk	PM Schedule Id	int	vr_PMSchedule
wotask_rts_fk	Rate Schedule Id	int	vr_rateSchedule
woTask_ss_fk	Status Id	int	vr_Status
woTask_status	Task Status	varchar
woTask_workNotDone	Work Not Done	bit

Articles in this section