vr_InterchangeableCore

Updated November 25, 2025 16:15

Field Name	Field Description	Data Type	FK Join
AreaLocationCode	Area Location Code (Location Id)	nvarchar
AreaRoomNumber	Area Room Number	nvarchar
AssetTagNumber	Asset Tag Number	nvarchar
BuildingCode	Building Code	nvarchar
Code	Interchangeable Core Code	nvarchar
Comment	Comments	nvarchar
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
Description	Interchangeable Core Description	nvarchar
FacilityCode	Facility Code	nvarchar
Finish	Lock Core Finish	nvarchar
FloorCode	Floor Code	nvarchar
Id	Lock Core Id	int
KeyId	Key Id	int	vr_Key
KeyLockCode	Key Lock Code	nvarchar
KeyNumber	Key Number	nvarchar
KeySystemCode	Key System Code	nvarchar
KeySystemDescription	Key System Description	nvarchar
KeySystemId	Key System Id	int	vr_KeySystem
KeySystemIsAutoCoreNumber	Indicates if the Key System	bit
LockShopCode	Lock Shop Code	nvarchar
LockShopDescription	Lock Shop Description	nvarchar
LockShopId	Lock Shop Id	int
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Number	Interchangeable Core Number	nvarchar
PartCode	Part Code	nvarchar
PartDescription	Part Description	nvarchar
PartId	Part Id	int	vr_Part
Symbol	Lock Core Symbol	nvarchar
Type	Lock Core Type	nvarchar
VendorId	Vendor Id	int	vr_Vendor
VendorName	Vendor Name	nvarchar