vrpt_WorkOrderContractor

Updated January 27, 2026 15:16

Field Name	Field Description	Data Type	FK Join
cont_code	Contractor Code	nvarchar
cont_name	Contractor Name	nvarchar
cst_code	Account Code	nvarchar
cst_name	Account Name	nvarchar
fo_code	Task Code	nvarchar
fo_description	Task Description	nvarchar
Id	Work Order Contractor Id	int
wo_pk	Work Order Id	int	vr_WorkOrder
woc_arrival	Arrival	datetime
woc_comments	Comments	nvarchar
woc_cst_fk	Account Id	int	vr_account
woc_departure	Departure	datetime
woc_description	Description	nvarchar
woc_flatRate	Indicates if the Record is a flat rate	bit
woc_noCharge	Indicates if the Record is not chargeable	bit
woc_pk	Work Order Contractor Id	int
woc_postDate	Post Date	datetime
woc_quantity	Quantity	decimal
woc_rate	Rate	decimal
woc_slPostDate	Sub Ledger Post Date	datetime
woc_totalcost	Total Cost	decimal
woc_totalRetail	Total Retail	decimal
woc_transDate	Transaction Date	datetime
woc_type	Type	nvarchar
woc_woTask_fk	Work Order Task Id	int	vr_WorkOrderTask
woTask_completionDate	Completion Date (Closed Date)	datetime
woTask_finishDate	Finish Date	datetime
wotask_rts_fk	Rate Schedule Id	int	vr_rateSchedule