vr_POChangeOrder

Updated November 27, 2025 12:46

Field Name	Field Description	Data Type	FK Join
AccountCode	Account Code	nvarchar
AccountId	Account Id	int	vr_account
AccountName	Account Name	nvarchar
Active	Indicates if the Record is Active or Not	bit
AreaId	Area Id	int	vr_area
AreaLocationCode	Area Location Code (Location Id)	nvarchar
AssignedToCode	Assigned Technician Code	nvarchar
AssignedToId	Technician Id	int	vrpt_Technician
AssignedToName	Assigned Technician Name	nvarchar
AssignedToTypeId	Assigned To Type Id	int
AverageMeter	Average Meter	decimal
BuildingId	Building Id	int	vr_building
CDRouteAreaTaskId	Custodial Route Area Task Id	int	vrpt_cdRouteAreaTaskLinkFor
CDTaskDescription	Custodial Task Description	nvarchar
CDTemplateId	Custodial Template Id	int
ContractActive	Indicates if the Contract is Active or Not	bit
ContractEndDate	Contract End Date	datetime
ContractId	Contract Id	int	vr_contract
ContractNumber	Contract Number	nvarchar
ContractorCode	Contractor Code	nvarchar
ContractorId	Contractor Id	int
ContractorName	Contractor Name	nvarchar
ContractPmRate	Contract PM Rate	decimal
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
CrewDescription	Crew Description	nvarchar
CrewId	Crew Id	int	vrpt_crew
CrewTagNumber	Crew Tag Number	nvarchar
currentmeter	Current Meter	decimal
DaysToComplete	Days To Complete	int
DepartmentCode	Department Code	nvarchar
DepartmentId	Department Id	int	vr_Department
DepartmentName	Department Name	nvarchar
EstimatedTime	Estimated Time	decimal
FacilityId	Facility Id	int	vr_facility
FixedOrFloating	Fixed or Floating	varchar
FloorId	Floor Id	int	vr_floor
GRNTemplateId	Grounds Template Id	int
Id	PM Schedule Id	int
Interval	Interval	int
IntervalCombined	Interval Combined	nvarchar
IntervalId	Interval Id	int
IntervalName	Interval Name	nvarchar
IntervalNameCombined	Interval Name Combined	nvarchar
IoTDeviceId	Internet of Things Device Id	int
IoTDeviceObjectName	IoT Device Object Name	nvarchar
IsFixedDay	Indicates if this PM is on a Fixed Day	bit
IsFloating	Indicates if this PM is Floating	bit
IsFloatStatus	Indicates if this PM has a Floating Status	bit
IsItemActive	Indicates if this PM's Item is Active	bit
IsWorkOrderCharge	Indicates if the Work Order is Chargeable or Not	bit
ItemCode	Item Code	nvarchar
ItemDescription	Item Description	nvarchar
ItemId	Item Id	int
ItemTagNumber	Item Tag Number	nvarchar
ItemTypeId	Item Type Id	int
ItemTypeName	Item Type Name	nvarchar
LastDate	Last Date	datetime
LastMeter	Last Meter	decimal
LastPMMeter	Last PM Meter	decimal
MakeModelPMId	Make Model PM Id	int
MeterCalcWhenWOComplete	Indicates if the meter record is calculated when a work order is completed	bit
MeterId	Meter Id	int	vr_meter
MeterMarginPercentage	Meter Margin Percentage	decimal
MeterName	Meter Name	nvarchar
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
NextDate	Next Date	datetime
NextMeter	Next Meter	decimal
PmAdjustedSeasonEndDate	PM Adjusted Season End Date	datetime
PmAdjustedSeasonStartDate	PM Adjusted Season Start Date	datetime
PmTimeZoneId	Time Zone Id	int	bi_TimeZoneInfo
PMType	PM Type	varchar
PriorityCode	Priority Code	nvarchar
PriorityDescription	Priority Description	nvarchar
PriorityId	Priority Id	int	vr_Priority
ProjectedNextDate	Projected Next Date	datetime
RateScheduleActive	Indicates if this PM's Rate Schedule is Active	bit
RateScheduleCode	Rate Schedule Code	nvarchar
RateScheduleDescription	Rate Schedule Description	nvarchar
RateScheduleId	Rate Schedule Id	int	vr_rateSchedule
RecurrenceRule	Recurrence Rule	nvarchar
RepairCenter5or7DayPm	Repair Center 5 or 7 Day PM	smallint
RepairCenterActive	Indicates if this PM's Repair Center is Active	bit
RepairCenterCode	Repair Center Code	nvarchar
RepairCenterId	Repair Center Id	int	vr_RepairCenter
RepairCenterName	Repair Center Name	nvarchar
RepairCenterShortCode	Repair Center Short Code	nvarchar
RepairCenterWONumber	Repair Center Work Order Number	bigint
RiskLevel	Risk Level	int
SeasonEndDate	Season End Date	datetime
SeasonStartDate	Season Start Date	datetime
StartDate	Start Date	datetime
StartMeter	StartMeter	decimal
SupervisorName	SupervisorName	nvarchar
TagTypeId	Tag Type Id	int
TaskActive	Indicates if this PM's Task is Active	bit
TaskAutoTrackPurposeId	Task Auto Track Purpose Id	int
TaskAverageTime	Task Average Time	decimal
TaskCode	Task Code	nvarchar
TaskDescription	Task Description	nvarchar
TaskId	Task Id	int	vrpt_Task
TaskSubTypeCode	Task Sub Type Code	nvarchar
TaskSubTypeDescription	Task Sub Type Description	nvarchar
TaskSubTypeId	Task Sub Type Id	int
TaskTaskTypeCode	Task Type Code	nvarchar
TaskTaskTypeDescription	Task Type Description	nvarchar
TaskTaskTypeId	Task Type Id	int	vr_TaskType
TaskTypeCode	Task Type Code	nvarchar
TaskTypeDescription	Task Type Description	nvarchar
TaskTypeId	Task Type Id	int	vr_TaskType
TechnicianCode	Technician Code	nvarchar
TechnicianFirstName	Technician First Name	nvarchar
TechnicianId	Technician Id	int	vrpt_Technician
TechnicianLastName	Technician Last Name	nvarchar
TechnicianName	Technician Name	nvarchar
TechnicianShiftId	Technician Shift Id	int	vr_shift
TradeCode	Trade Code	nvarchar
TradeDescription	Trade Description	nvarchar
TradeId	Trade Id	int	vr_trade
TradeShopId	Trade Shop Id	int	vr_shop
VehicleId	Vehicle Id	int	vr_Vehicle
WarehouseCode	Warehouse Code	nvarchar
WarehouseId	Warehouse Id	int	vr_warehouse
WorkOrderSubTypeCode	Work Order Sub Type Code	nvarchar
WorkOrderSubTypeDescription	Work Order Sub Type Description	nvarchar
WorkOrderSubTypeId	Work Order Sub Type Id	int
WorkOrderTypeCode	Work Order Type Code	nvarchar
WorkOrderTypeDescription	Work Order Type Description	nvarchar
WorkOrderTypeId	Work Order Type Id	int	vr_WorkOrderType

Articles in this section