vr_KeyCabinet

Updated November 25, 2025 16:46

Field Name	Field Description	Data Type	FK Join
Active	Indicates if the Record is Active or Not	bit
AreaDescription	Area Description	nvarchar
AreaId	Area Id	int	vr_area
AreaLocationCode	Area Location Code (Location Id)	nvarchar
AreaRoomNumber	Area Room Number	nvarchar
BuildingId	Building Id	int	vr_building
BuildingName	Building Name	nvarchar
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
Description	Key Cabinet Description	nvarchar
FacilityId	Facility Id	int	vr_facility
FacilityName	Facility Name	nvarchar
FloorCode	Floor Code	nvarchar
FloorId	Floor Id	int	vr_floor
Id	Key Cabinet Id	int
KeySystemCode	Key System Code	nvarchar
KeySystemId	Key System Id	int	vr_KeySystem
LockShopCode	Lock Shop Code	nvarchar
LockShopId	Lock Shop Id	int
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Quantity	Quantity	decimal
TagNumber	Tag Number	nvarchar