vr_CPFundingRequest

Updated February 04, 2026 16:17

Field Name	Field Description	Data Type	FK Join
Active	Indicates if the Record is Active or Not	bit
BudgetYear	Budget Year	int
CloseDate	Closed Date	datetime
Comment	Comments	nvarchar
CPSetupCode	Capital Setup Code	nvarchar
CPSetupDescription	Captial Setup Desription	nvarchar
CPSetupId	Capital Setup Id	int	vrpt_cpSetup
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
CurrencyExchangeDate	Currency Exchange Date	datetime
CurrencyExchangeId	Currency Exchange Id	int
CurrencyId	Currency Id	int	vrpt_Currency
Date	Capital Request (Budget) Date	datetime
DepartmentCode	Department Code	nvarchar
DepartmentId	Department Id	int	vr_Department
DepartmentName	Department Name	nvarchar
Description	Capital Request (Budget) Description	nvarchar
EnactedAmount	Enacted Amount	decimal
EstimatedAmount	Estimated Amount	decimal
FinalizeDate	Finalize Date	datetime
FullStatus	Concatenated field (Status Description + Status Note)	nvarchar
FundedAmount	Funded Amount	numeric
FundedAvailableAmount	Funded Available Amount	numeric
Id	Capital Request (Budget) Id	int
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Number	Capital Request (Budget) Number	int
ReferenceNumber	Reference Number	nvarchar
RepairCenterCode	Repair Center Code	nvarchar
RepairCenterId	Repair Center Id	int	vr_RepairCenter
RepairCenterName	Repair Center Name	nvarchar
RequestComponentBudgetAmount	Request Component Budget Amount	numeric
RequestComponentTaskEstimatedAmount	Request Component Task Estimated Amount	numeric
RequestFundedAmount	Request Funded Amount	numeric
RequestFundingSourceFundedAmount	Request Funding Source Funded Amount	numeric
RequestTargetAmount	Request Target Amount	decimal
StatusAllowNote	Indicates if this record allows a status note	bit
StatusDescription	Status Description	nvarchar
StatusId	Status Id	int	vr_Status
StatusNote	Status Note	nvarchar
TargetAmount	Target Amount	decimal
TechnicianCode	Technician Code	nvarchar
TechnicianEmail	Technician Email	nvarchar
TechnicianId	Technician Id	int	vrpt_Technician
TechnicianName	Technician Name	nvarchar
TechnicianPhoneWork	Technician Work Phone	nvarchar
TechnicianPosition	Technician Position	nvarchar
Title	Capital Request (Budget) Title	nvarchar
WorkFlowCode	Work Flow Code	nvarchar
WorkFlowDescription	Work Flow Description	nvarchar
WorkFlowId	Work Flow Id	int

Articles in this section