vrpt_KeyHolderKeys

Updated December 24, 2025 13:04

Field Name	Field Description	Data Type	FK Join
Id	Key Transaction Id	int	vr_KeyTransaction
kh_firstName	Key Holder First Name	nvarchar
kh_id	Key Holder Id	nvarchar
kh_lastName	Key Holder Last Name	nvarchar
kh_name	Key Holder Name	nvarchar
kh_pk	Key Holder Record Id	int	vr_KeyHolder
kr_description	Key Ring Description	nvarchar
kr_pk	Key Ring Id	int	vr_KeyRing
kr_tagNumber	Key Ring Tag Number	nvarchar
ktr_action_fk	Key Transaction Action Id	int
ktr_comment	Key Transaction Comment	nvarchar
ktr_createdDate	Record Creation Date	datetime
ktr_creator_fk	User Id (Record Creator)	int	vr_users
ktr_date	Key Transaction Date	datetime
ktr_deposit	Key Transaction Deposit	decimal
ktr_dueDate	Key Transaction Due Date	datetime
ktr_foundDate	Key Transaction Found Date	datetime
ktr_foundQuantity	Key Transaction Found Quantity	int
ktr_issueDate	Key Transaction Issue Date	datetime
ktr_issueQuantity	Key Transaction Issue Quantity	int
ktr_keyHolder	Key Holder	nvarchar
ktr_kh_fk	Key Holder Record Id	int	vr_KeyHolder
KTR_KH_ID_CODE	Key Holder Id Code	nvarchar
ktr_kr_fk	Key Ring Id	int	vr_KeyRing
ktr_ky_fk	Key Id	int	vr_Key
ktr_lostDate	Key Transaction Lost Date	datetime
ktr_lostQuantity	Key Transaction Lost Quantity	int
ktr_modifiedDate	Last Modified Date	datetime
ktr_modifier_fk	User Id (Record Modifier)	int	vr_users
ktr_parent_fk	Key Transaction Parent Id	int	vr_KeyTransaction
ktr_pk	Key Transaction Id	int	vr_KeyTransaction
ktr_quantity	Key Transaction Quantity	int
ktr_returnDate	Key Transaction Return Date	datetime
ktr_returnQuantity	Key Transaction Return Quantity	int
ktr_serialNumber	Key Transaction Serial Number	nvarchar
ky_description	Key Description	nvarchar
ky_number	Key Number	nvarchar
user_initials	User Initials	nvarchar

Articles in this section