vrpt_KeyIssued

Updated December 24, 2025 13:06

Field Name	Field Description	Data Type	FK Join
cst_code	Account Code	nvarchar
cst_pk	Account Id	int	vr_account
hasSignature	Indicates if the Key Transaction record has a signature	bit
Id	Key Transaction Id	int	vr_KeyTransaction
kh_email	Key Holder Email	nvarchar
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_cst_fk	Account Id	int	vr_account
ktr_date	Key Transaction Date	datetime
ktr_deposit	Key Transaction Deposit	decimal
ktr_depositReturn	Key Transaction Deposit Return	decimal
ktr_dueDate	Key Transaction Due Date	datetime
ktr_externalAccountNumber	Key Transaction External Account Number	nvarchar
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_issuer	Key Transaction Issuer	nvarchar
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_paymentType	Key Transaction Payment Type	nvarchar
ktr_pickupDate	Key Transaction Pick Up Date	datetime
ktr_pk	Key Transaction Id	int	vr_KeyTransaction
ktr_quantity	Key Transaction Quantity	int
ktr_referenceNumber	Key Transaction Reference Number	nvarchar
ktr_returnDate	Key Transaction Return Date	datetime
ktr_returnQuantity	Key Transaction Return Quantity	int
ktr_secondaryID	Key Transaction Secondary Id	nvarchar
ktr_serialNumber	Key Transaction Serial Number	nvarchar
ktr_transferDescription	Key Transaction Transfer Description	nvarchar
ky_description	Key Description	nvarchar
ky_number	Key Number	nvarchar
ky_rc_fk	Repair Center Id	int	vr_RepairCenter
user_initials	User Initials	nvarchar

Articles in this section