vr_KeyTransaction

Updated November 25, 2025 17:00

Field Name	Field Description	Data Type	FK Join
AccountCode	Account Code	nvarchar
AccountId	Account Id	int	vr_account
AccountName	Account Name	nvarchar
AvailableQuantity	Available Quantity	int
Comment	Comments	nvarchar
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
Date	Date	datetime
DepartmentCode	Department Code	nvarchar
DepartmentId	Department Id	int	vr_Department
DepartmentName	Department Name	nvarchar
Deposit	Deposit	decimal
DepositReturn	Deposit Return	decimal
DueDate	Due Date	datetime
ExternalAccountNumber	External Account Number	nvarchar
HasSignature	Indicates if the record has a signature	bit
Historical	Indicates if the record is historical	bit
Id	Key Transaction Id	int
Issuer	Issuer	nvarchar
KeyAdjustmentId	Key Adjustment Id	int
KeyAdjustmentTypeCode	Key Adjustment Type Code	nvarchar
KeyAdjustmentTypeDescription	Key Adjustment Type Description	nvarchar
KeyAdjustmentTypeId	Key Adjustment Type Id	int
KeyCabinetDescription	Key Cabinet Description	nvarchar
KeyCabinetId	Key Cabinet Id	int	vr_KeyCabinet
KeyCabinetTagNumber	Key Cabinet Tag Number	nvarchar
KeyDescription	Key Description	nvarchar
KeyHolderCode	Key Holder Code	nvarchar
KeyHolderEmail	Key Holder Email	nvarchar
KeyHolderFirstName	Key Holder First Name	nvarchar
KeyHolderId	Key Holder Id	int	vr_KeyHolder
KeyHolderLastName	Key Holder Last Name	nvarchar
KeyHolderName	Key Holder Name	nvarchar
KeyHolderRepairCenterId	Repair Center Id	int	vr_RepairCenter
KeyId	Key Id	int	vr_Key
KeyNumber	Key Number	nvarchar
KeyRepairCenterId	Repair Center Id	int	vr_RepairCenter
KeyRingDescription	Key Ring Description	nvarchar
KeyRingId	Key Ring Id	int	vr_KeyRing
KeyRingTagNumber	Key Ring Tag Number	nvarchar
KeySerialized	Indicates if the key is serialized	bit
KeySerializedId	Key Serialized Id	int
KeySerializedSerialNumber	Serial Number	nvarchar
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
ParentId	Parent Id	int	vr_KeyTransaction
PaymentType	Payment Type	nvarchar
PickUpDate	Pick Up Date	datetime
PostAdjustmentQuantity	Post Adjustment Quantity	int
Quantity	Quantity	int
ReferenceNumber	Reference Number	nvarchar
SecondaryCode	Secondary Code	nvarchar
TaskCode	Task Code	nvarchar
TaskId	Task Id	int	vrpt_Task
TransactionKeyHolder	Transaction Key Holder	nvarchar
TransactionKeyHolderCode	Transaction Key Holder Code	nvarchar
Transfer	Indicates if the record is a transfer	bit
TransferDescription	Transfer Description	nvarchar
UserInitials	User Initials	nvarchar
UserLogin	User Login	nvarchar
WorkOrderId	Work Order Id	int	vr_WorkOrder
WorkOrderNumber	Work Order Number	nvarchar
WorkOrderTaskId	Work Order Task Id	int	vr_WorkOrderTask

Articles in this section