vrpt_ContractTaskType

Updated December 22, 2025 15:06

Field Name	Field Description	Data Type	FK Join
con_active	Indicates if the Contract is Active or Not	bit
con_awardDate	Contract Awarded Date	datetime
con_EndDate	Contract End Date	datetime
con_number	Contract Number	nvarchar
ctl_con_fk	Contract Id	int	vr_contract
ctl_createdDate	Record Creation Date	datetime
ctl_creator_fk	User Id (Record Creator)	int	vr_users
ctl_fj_fk	Contract Task Type Id	int	vr_TaskType
ctl_modifiedDate	Last Modified Date	datetime
ctl_modifier_fk	User Id (Record Modifier)	int	vr_users
ctl_rts_fk	Contract Rate Schedule Id	int	vr_rateSchedule
fj_active	Indicates if the Record is Active or Not	bit
fj_applyMultiplier	Indicates if the Record has a multiplier applied	bit
fj_bc_fk	Budget Code Id	int
fj_code	Task Type Code	nvarchar
fj_createdDate	Record Creation Date	datetime
fj_creator_fk	User Id (Record Creator)	int	vr_users
fj_description	Task Type Description	nvarchar
fj_filterFromdevice	Indicates if the Record will be filtered from mobile device	bit
fj_ftr_fk	Trade Id	int	vr_Trade
fj_hourlyRate	Task Type Hourly Rate	decimal
fj_mfj_fk	Task Type Master Type Id	int
fj_modifiedDate	Last Modified Date	datetime
fj_modifier_fk	User Id (Record Modifier)	int	vr_users
fj_parent_fk	Parent Id	int
fj_pk	Task Type Id	int	vr_TaskType
fjs_code	Task Sub Type Code	nvarchar
fjs_description	Task Sub Type Description	nvarchar
rts_code	Rate Schedule Code	nvarchar
rts_description	Rate Schedule Description	nvarchar
ven_name	Vendor Name	nvarchar