vrpt_WOItem

Updated January 27, 2026 12:50

Field Name	Field Description	Data Type
fm_bmp	Indicates if the equipment record is on a building maintenance program	bit
highrisk	Indicates if the work order item record is a high risk	bit
Id	Item Id	int
item_pk	Item Id	int
ItemAreaNumber	Item Area Number	nvarchar
ItemStatus	Item Status	nvarchar
itemSubType	Item Sub Type	nvarchar
itemType_fk	Item Type Id	int
jco_description	Joint Commission Description	nvarchar
lockout	Lockout	nvarchar
modelNumber	Model Number	nvarchar
riskFactor	Risk Factor	int
serialNumber	Serial Number	nvarchar
subLocation	Sub Location	nvarchar
tagDescription	Tag Description	nvarchar
tagNumber	Tag Number	nvarchar
typedesc	Type Description	nvarchar
ven_name	Vendor Name	nvarchar
warrantyDate	Warranty Date	datetime