vrpt_cpProjectRequest

Updated April 06, 2026 15:20

Field Name	Field Description	Data Type	FK Join
budgetAmount	Budget Amount	numeric
cfg_active	Indicates whether the Capital Planning Project Request is Active	bit
cfg_cipt_fk	Capital Planning Project Request Type Id	int
cfg_code	Code	int
cfg_cps_fk	Capital Planning Setup Id	int	vrpt_cpSetup
cfg_createdDate	Record Creation Date	datetime
cfg_creator_fk	User Id (Record Creator)	int	vr_users
cfg_curr_fk	Currency Id	int	vrpt_Currency
cfg_date	Date	datetime
cfg_description	Description	nvarchar
cfg_exch_date	Currency Exchange Date	datetime
cfg_exch_fk	Currency Exchange Id	int
cfg_modifiedDate	Last Modified Date	datetime
cfg_modifier_fk	User Id (Record Modifier)	int	vr_users
cfg_pk	Capital Planning Project Request Id	int
cfg_proj_fk	Project Id	int	vr_Project
cfg_projectReference	Project Reference	varchar
cfg_referenceNumber	Reference Number	nvarchar
cfg_targetAmount	Target Amount	numeric
cfg_title	Title	nvarchar
cipt_code	Capital Planning Project Request Type Code	nvarchar
cipt_description	Capital Planning Project Request Type Description	nvarchar
cipt_pk	Capital Planning Project Request Type Id	int
cipts_code	Capital Planning Project Request Sub Type Code	nvarchar
cipts_description	Capital Planning Project Request Sub Type Description	nvarchar
cps_cfg_formula_fk	Capital Planning Project Request Formula Id	int
cps_code	Capital Planning Setup Code	nvarchar
cps_description	Capital Planning Setup Description	nvarchar
cps_pk	Capital Planning Setup Id	int	vrpt_cpSetup
enactedAmount	Enacted Amount	decimal
estimatedAmount	Estimated Amount	decimal
fundedAmount	Funded Amount	numeric
proj_number	Project Number	nvarchar
proj_requestDate	Project Request Date	datetime
unfundedAmount	Unfunded Amount	decimal

Articles in this section