vrpt_KeyHolderHistory

Updated December 24, 2025 13:03

Field Name	Field Description	Data Type	FK Join
cst_code	Account Code	int
fo_code	Task Code	int
hasanyemail	Indicates if the Key Holder record has email	int
hasSignature	Indicates if the Key Transaction record has a signature	bit
Id	Key Holder Record Id	int	vr_KeyHolder
kh_email	Key Holder Email	nvarchar
kh_id	Key Holder Id	nvarchar
kh_name	Key Holder Name	nvarchar
kh_pk	Key Holder Record Id	int	vr_KeyHolder
ktr_action_fk	Key Transaction Action Id	int
ktr_comment	Key Transaction Comment	int
ktr_deposit	Key Transaction Deposit	int
ktr_dueDate	Key Transaction Due Date	int
ktr_externalAccountNumber	Key Transaction External Account Number	int
ktr_issueDate	Key Transaction Issue Date	datetime
ktr_issuer	Key Transaction Issuer	int
ktr_kh_fk	Key Holder Record Id	int	vr_KeyHolder
ktr_kser_fk	Key Serial Id	int
ktr_ky_fk	Key Id	int	vr_Key
ktr_lostDate	Key Transaction Lost Date	int
ktr_paymentType	Key Transaction Payment Type	int
ktr_pickUpDate	Key Transaction Pick Up Date	int
ktr_pk	Key Transaction Id	int	vr_KeyTransaction
ktr_quantity	Key Transaction Quantity	int
ktr_referenceNumber	Key Transaction Reference Number	int
ktr_returnDate	Key Transaction Return Date	datetime
ktr_secondaryID	Key Transaction Secondary Id	int
ktr_serialNumber	Key Transaction Serial Number	nvarchar
ktr_transferDescription	Key Transaction Transfer Description	int
ky_description	Key Description	nvarchar
ky_number	Key Number	nvarchar
ky_pk	Key Id	int	vr_Key
ky_rc_fk	Repair Center Id	int	vr_RepairCenter
pk	Key Transaction Id	int	vr_KeyTransaction
wo_number	Work Order Number	int