vr_Lock

Updated November 26, 2025 17:11

Field Name	Field Description	Data Type	FK Join
Active	Indicates if the Record is Active or Not	bit
AreaDescription	Area Description	nvarchar
AreaDoorId	Area Door Id	int
AreaDoorLocationCode	Area Door Location Code	nvarchar
AreaDoorRoomNumber	Area Door Room Number	nvarchar
AreaId	Area Id	int	vr_area
AreaLocationCode	Area Location Code (Location Id)	nvarchar
AreaRoomNumber	Area Room Number	nvarchar
AssetId	Asset Id	int	vr_asset
AssetTagNumber	Asset Tag Number	nvarchar
BuildingCode	Building Code	nvarchar
BuildingDoorCode	Building Door Code	nvarchar
BuildingDoorId	Building Door Id	int
BuildingId	Building Id	int	vr_building
BuildingName	Building Name	nvarchar
Code	Lock Code	nvarchar
Codes	Lock Code	nvarchar
Comments	Comments	nvarchar
CoreType	Core Type	nvarchar
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
DepartmentId	Department Id	int	vr_Department
Description	Description	nvarchar
FacilityCode	Facility Code	nvarchar
FacilityDoorCode	Facility Door Code	nvarchar
FacilityDoorId	Facility Door Id	int
FacilityId	Facility Id	int	vr_facility
FacilityName	Facility Name	nvarchar
Finish	Finish	nvarchar
FloorCode	Floor Code	nvarchar
FloorDescription	Floor Description	nvarchar
FloorDoorCode	Floor Door Code	nvarchar
FloorDoorId	Floor Door Id	int
FloorId	Floor Id	int	vr_floor
FloorUniqueID	Floor Unique Id	nvarchar
Id	Lock Id	int
KeyBittingBitting	Key Bitting	nvarchar
KeyBittingId	Key Bitting Id	int	vr_KeyBitting
KeyDescription	Key Description	nvarchar
KeyId	Key Id	int	vr_Key
KeyKeyway	Keyway	nvarchar
KeyLockTypeCode	Key Lock Type Code	nvarchar
KeyLockTypeDescription	Key Lock Type Description	nvarchar
KeyLockTypeId	Key Lock Type Id	int
KeyNumber	Key Number	nvarchar
KeyRepairCenterId	Repair Center Id	int	vr_RepairCenter
KeySystemCode	Key System Code	nvarchar
KeySystemDescription	Key System Description	nvarchar
KeySystemId	Key System Id	int	vr_KeySystem
KeySystemIsAutoCoreNumber	Indicates if the key system is auto core number	bit
KeySystemIsAutoLockNumber	Indicates if the key system is auto lock number	bit
KeySystemIsInterchangeableCore	Inidicates if the key system is an interchangeable core	bit
LocationCode	Location Code	nvarchar
LocationId	Location Id	int
LocationName	Location Name	nvarchar
LocationTypeId	Location Type Id	int
LockCoreDescription	Lock Core Description	nvarchar
LockCoreId	Lock Core Id	int
LockCoreNumber	Lock Core Number	nvarchar
LockShopCode	Lock Shop Code	nvarchar
LockShopDescription	Lock Shop Description	nvarchar
LockShopId	Lock Shop Id	int
ModelNumber	Model Number	nvarchar
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Number	Lock Number	nvarchar
ReKeyDate	Rekey Date	datetime
VendorCode	Vendor Code	nvarchar
VendorId	Vendor Id	int	vr_Vendor
VendorName	Vendor Name	nvarchar

Articles in this section