vrpt_ExpiringContracts

Updated December 22, 2025 16:19

Field Name	Field Description	Data Type	FK Join
con_awardDate	Contract Awarded Date	datetime
con_balance	Contract Balance	decimal
CON_BALANCE4Rpt	Calculated field includes balance values from Contract Change Order, Project Requisition and Work Order actual cost	decimal
con_endDate	Contract End Date	datetime
con_estimate	Contract Estimate	decimal
con_extendedthrough	Contract Extended Through	datetime
con_number	Contract Number	nvarchar
con_startDate	Contract Start Date	datetime
con_status	Constract Status	nvarchar
con_totalValue	Contract Total Value	decimal
ctl_con_fk	Contract Id	int	vr_contract
ctl_fj_fk	Task Type Id	int	vr_TaskType
fj_code	Task Type Code	nvarchar
fj_description	Task Type Description	nvarchar
Id	Contract Take Type Link Id	int
rts_code	Rate Schedule Code	nvarchar
rts_description	Rate Schedule Description	nvarchar
tcon_code	Contract Type Code	nvarchar
tcon_description	Contract Type Description	nvarchar
ven_code	Vendor Code	nvarchar
ven_name	Vendor Name	nvarchar