vr_Key

Updated November 25, 2025 16:42

Field Name	Field Description	Data Type	FK Join
Active	Indicates if the Record is Active or Not	bit
Assigned	Indicates if this record is assigned	bit
BlindCode	Blind Code	nvarchar
Code	Key Code	nvarchar
Comments	Comments	nvarchar
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
Description	Description	nvarchar
EncryptionType	Encription Type	int
Id	Key Id	int
IsControl	Indicates if the key is a control key	bit
IsMiscellaneous	Indicates if the key is a miscellaneous key	bit
KeyBittingBitting	Key Bitting	nvarchar
KeyBittingBittingNoRpt	Key Bitting Number	nvarchar
KeyBittingBittingNoUnencrypted	Key Bitting Number Unencrypted	nvarchar
KeyBittingBittingNumber	Key Bitting Number	nvarchar
KeyBittingBittingRpt	Key Bitting Number	nvarchar
KeyBittingBittingUnencrypted	Key Bitting Unencrypted	nvarchar
KeyBittingEncryptionType	Key Bitting Encryption Type	int
KeyBittingId	Key Bitting Id	int	vr_KeyBitting
KeyBittingIsEncrypted	Indicates if the key bitting record is encrypted	bit
KeySystemCode	Key System Code	nvarchar
KeySystemDescription	Key System Description	nvarchar
KeySystemDetailId	Key System Detail Id	bit
KeySystemDetailLevel	Key System Detail Level	int
KeySystemId	Key System Id	int	vr_KeySystem
KeySystemIsBittingRequired	Indicates if the key system requires key bitting	bit
KeySystemIsInterchangeableCore	Indicates if the key system is interchangeable core	bit
KeySystemLevel	Key System Level	int
KeyTypeCode	Key Type Code	nvarchar
KeyTypeDescription	Key Type Description	nvarchar
KeyTypeId	Key Type Id	int
Keyway	Keyway	nvarchar
LockShopCode	Lock Shop Code	nvarchar
LockShopDescription	Lock Shop Description	nvarchar
LockShopId	Lock Shop Id	int
ManufacturerCode	Manufacturer Code	nvarchar
ManufacturerId	Manufacturer Id	int	vr_Vendor
ManufacturerName	Manufacturer Name	nvarchar
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
No	Key Number	nvarchar
Number	Key Number	nvarchar
ParentDescription	Parent Description	nvarchar
ParentId	Parent Id	int	vr_Key
ParentNo	Parent Number	nvarchar
ParentNumber	Parent Number	nvarchar
QuantityCreated	Quantity Created	int
QuantityDestroyed	Quantity Destroyed	int
QuantityIssued	Quantity Issued	int
QuantityKC	Quantity in Key Cabinet	int
QuantityKR	Quantity on Key Ring	int
QuantityLost	Quantity Lost	int
QuantityLostUnissued	Quantity Lost Unissued	int
QuantityRemain	Quantity Remain	int
RepairCenterId	Repair Center Id	int	vr_RepairCenter
RepairCenterName	Repair Center Name	nvarchar
Serialized	Indicates if the key is serialized	bit
Stamp	Stamp	nvarchar
SymbolDescription	Symbol Description	nvarchar
SymbolLevel	Symbol Level	int

Articles in this section