vrpt_WorkOrderLaborList

Updated January 27, 2026 15:35

Field Name	Field Description	Data Type	FK Join
BaseTransactionId	Base Transaction Id	int
BaseTransactionNumber	Base Transaction Number	nvarchar
cst_code	Account Code	nvarchar
cst_name	Account Name	nvarchar
fo_code	Task Code	nvarchar
fo_description	Task Description	nvarchar
fo_fj_fk	Task Type Id	int	vr_TaskType
fo_pk	Task Id	int	vrpt_task
ftr_code	Trade Code	nvarchar
ftr_description	Trade Description	nvarchar
fwor_applyMultiplier	Indicates if the Multiplier is to be applied to the Work Order Labor Line or Not	bit
fwor_approvedDate	Approved Date	datetime
fwor_batchID	Batch Record Id	int
fwor_beginingxCoordinate	Beginning X Coordinate	nvarchar
fwor_beginingyCoordinate	Beginning Y Coordinate	nvarchar
fwor_bj_fk	Batch Job Id	int	vr_BatchJob
fwor_chargeRate	Charge 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_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	Work Order 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 Work Order Labor Line is makred as No Charge or Not	bit
fwor_pk	Work Order Labor Id	int
fwor_pos_fk	Position Id	int	vr_Position
fwor_postDate	Post Date	datetime
fwor_rateHierarchyLevel	Rate Hiearchy Level	nvarchar
fwor_rateMultiplier	Rate Multiplier	decimal
fwor_rcoverridetechrate	Indicates if the Repair Center overrides the Charge Rate or Not	bit
fwor_repaircenterMultiplier	Indicates if the Repair Center has a Multiplier or Not	bit
fwor_shft_fk	Shift Id	int	vr_Shift
fwor_SLPostDate	Sub Ledger Post Date	datetime
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_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	Indicates if the Technician Record has an Email or Not	bit
Id	Work Order Labor Id	int
LinkCode	Task Code	nvarchar
LinkDescription	Task Description	nvarchar
LinkTransactionId	Work Order Task Id	int	vr_WorkOrderTask
LinkTransactionTypeId	Static Value (24)	int
pos_code	Position Code	nvarchar
rc_code	Repair Center Code	nvarchar
rc_dupeCheck	Indicates if the Repair Center Checks for Duplicate Work Orders	bit
rc_positionBasedrate	Indicates if the Repair Center has a Position Based Rate	bit
RepairCenterId	Repair Center Id	int	vr_RepairCenter
shft_code	Shift Code	nvarchar
shft_description	Shift Description	nvarchar
shft_differential	Shift Differential	decimal
ti_code	Time Type Code	nvarchar
ti_description	Time Type Description	nvarchar
ti_earnsCompTime	Indicates if the Time Type Earns Comp Time or Not	bit
ti_nonproductivetime	Indicates if the Time Type is used for Non Productive Time (Non Work Order Time)	int
ti_pk	Time Type Id	int	vr_TimeType
ti_productiveTime	Indicates if the Time Type is used for Productive Time (Work Order Time)	bit
tis_code	Time Sub Type Code	nvarchar
tis_description	Time Sub Type Description	nvarchar
tis_pk	Time Sub Type Id	int
wk_id	Technician Record Id	nvarchar
wk_Name	Technician Name	nvarchar
wo_completionDate	Completion (Closed) Date	datetime
wo_cst_fk	Account Id	int	vr_account
wo_finishDate	Finish Date	datetime
wo_number	Work Order Number	nvarchar
wo_pk	Work Order Id	int	vr_WorkOrder
wo_rc_fk	Repair Center Id	int	vr_RepairCenter
WorkorderTaskCompletionDate	Work Order Task Completion Date	datetime
WorkorderTaskFinishDate	Work Order Task Finish Date	datetime
WorkorderTaskRateScheduleId	Rate Schedule Id	int	vr_rateSchedule

Articles in this section