vrpt_EquipmentPMWizard

Updated December 22, 2025 15:55

Field Name	Field Description	Data Type	FK Join
apply	Apply	varchar
con_endDate	Contract End Date	datetime
con_number	Contract Number	nvarchar
cont_code	Contractor Code	nvarchar
cst_code	Account Code	nvarchar
departmentCode	Department Code	nvarchar
dp_code	Department Code	nvarchar
dp_name	Department Name	nvarchar
fc_description	Equipment Type Description	nvarchar
fcs_description	Equipment Sub Type Description	nvarchar
fd_name	Facility Name	nvarchar
fj_code	Task Type Code	nvarchar
fj_description	Task Type Description	nvarchar
fm_bmp	Indicates if the Equipment record is on a building maintenance program	bit
fm_description	Equipment Description	nvarchar
fm_modelNumber	Equipment Model Number	nvarchar
fm_pk	Equipment Id	int	vr_equipment
fm_riskFactor	Equipment Risk Factor	int
fm_secondaryID	Equipment Secondary Id	nvarchar
fm_serialNumber	Equipment Serial Number	nvarchar
fm_tagNumber	Equipment Tag Number	nvarchar
fm_warrantyExpires	Equipment Warranty Expires	datetime
fo_averageTime	Task Average Time	decimal
fo_code	Task Code	nvarchar
fo_description	Task Description	nvarchar
ftr_code	Trade Code	nvarchar
ftr_description	Trade Description	nvarchar
groupID	Group Id	nvarchar
hasDeletedDate	Has Deleted Date	bit
id	PM Schedule Record Id	int	vr_PMSchedule
interval_name	Interval Name	nvarchar
isGroup	Is Group	varchar
meter_name	Meter Name	nvarchar
mfg_name	Manufacturer Name	nvarchar
pm_active	Indicates if the Record is Active or Not	bit
pm_averageMeter	Average Meter	decimal
pm_con_fk	Contract Id	int	vr_contract
pm_cont_fk	Contractor Id	int	vr_Vendor
pm_createddate	Record Creation Date	datetime
pm_creator_fk	User Id (Record Creator)	int	vr_users
pm_cst_fk	Account Id	int	vr_account
pm_daysToComplete	Days To Complete	int
pm_dp_fk	Department Id	int	vr_Department
pm_estimatedTime	Estimated Time	decimal
pm_fixedDay	Indicates if the PM Schedule record is set to a fixed day	bit
pm_Floating	Indicates if the PM Schedule record is floating	bit
pm_floatStatus	Float Status	bit
pm_fo_fk	Task Id	int	vrpt_task
pm_ftr_fk	Trade Id	int	vr_Trade
pm_interval	Interval	int
pm_interval_fk	Interval Id	int
pm_item_fk	Item Id	int
pm_itemType_fk	Item Type Id	int
pm_lastDate	PM Schedule Last Date	datetime
pm_lastPMMeter	PM Schedule Last Meter	decimal
pm_meter_fk	Meter Id	int	vr_meter
pm_meterMarginPercentage	PM Schedule Meter Margin Percentage	decimal
pm_modifiedDate	Last Modified Date	datetime
pm_modifier_fk	User Id (Record Modifier)	int	vr_users
pm_nextDate	PM Schedule Next Date	datetime
pm_nextMeter	PM Schedule Next Meter	decimal
pm_pk	PM Schedule Id	int	vr_PMSchedule
pm_pri_fk	Priority Id	int	vr_Priority
pm_projNextDate	PM Schedule Projected Next Date	datetime
pm_rc_fk	Repair Center Id	int	vr_RepairCenter
pm_riskLevel	Risk Level	decimal
pm_rts_fk	Rate Schedule Id	int	vr_rateSchedule
pm_seasonEnd	PM Schedule Season End	datetime
pm_seasonStart	PM Schedule Season Start	datetime
pm_startDate	PM Schedule Start Date	datetime
pm_startMeter	PM Schedule Start Meter	decimal
pm_wc_fk	Work Order Type Id	int	vr_WorkOrderType
pm_wh_fk	Warehouse Id	int	vr_warehouse
pm_wk_fk	Technician Id	int	vrpt_Technician
pm_workorderCharge	Indicates if the PM Schedule record is chargeable	bit
pri_code	Priority Code	nvarchar
pri_description	Priority Description	nvarchar
rc_code	Repair Center Code	nvarchar
rc_name	Repair Center Name	nvarchar
rts_code	Rate Schedule Code	nvarchar
rts_description	Rate Schedule Description	nvarchar
ven_name	Vendor Name	nvarchar
wc_code	Work Order Type Code	nvarchar
wc_description	Work Order Type Description	nvarchar
wh_code	Warehouse Code	nvarchar
wh_name	Warehouse Name	nvarchar
wk_fullName	Technician Full Name	nvarchar
wk_id	Technician Record Id	nvarchar

Articles in this section