vrpt_WorkOrderContractorList

Updated January 27, 2026 15:19

Field Name	Field Description	Data Type	FK Join
CON_Number	Contract Number	nvarchar
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_number	Work Order Number	nvarchar
wo_pk	Work Order Id	int	vr_WorkOrder
woc_arrival	Arrival	datetime
woc_bj_fk	Batch Job Id	int	vr_BatchJob
woc_comments	Comments	nvarchar
woc_createdDate	Record Creation Date	datetime
woc_creator_fk	User Id (Record Creator)	int	vr_users
woc_cst_fk	Account Id	int	vr_account
woc_curr_fk	Currency Id	int	vrpt_Currency
woc_departure	Departure	datetime
woc_description	Description	nvarchar
woc_exch_date	Currency Exchange Date	datetime
woc_exch_fk	Currency Exchange Id	int
woc_flatRate	Indicates if the record is a flat rate	bit
woc_flatrate_str	Flat Rate	varchar
woc_modifiedDate	Last Modified Date	datetime
woc_modifier_fk	User Id (Record Modifier)	int	vr_users
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_taxable	Indicates if this Work Order Contractor Charge is taxable	bit
woc_taxamount	Tax Amount	decimal
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
woTask_ven_fk	Vendor Id	int	vr_Vendor

Articles in this section