vr_ToolTransferDetails

Updated November 28, 2025 12:42

Field Name	Field Description	Data Type	FK Join
FromAccountCode	From Account Code	nvarchar
FromAccountId	From Account Id	int	vr_account
FromAreaDescription	From Area Description	nvarchar
FromAreaId	From Area Id	int	vr_area
FromAreaLocationCode	From Area Location Code (Location Id)	nvarchar
FromAreaRoomNumber	From Area Room Number	nvarchar
FromAssignedTechCode	From Assigned Tech Code	nvarchar
FromAssignedTechId	From Assigned Tech Id	int	vrpt_Technician
FromAssignedTechName	From Assigned Tech Name	nvarchar
FromBuildingCode	From Building Code	nvarchar
FromBuildingId	From Building Id	int	vr_building
FromBuildingName	From Building Name	nvarchar
FromDepartmentCode	From Department Code	nvarchar
FromDepartmentId	From Department Id	int	vr_Department
FromDepartmentName	From Department Name	nvarchar
FromDistrictCode	From District Code	nvarchar
FromDistrictId	From District Id	int	vr_district
FromDistrictName	From District Name	nvarchar
FromDivisionCode	From Division Code	nvarchar
FromDivisionId	From Division Id	int
FromDivisionName	From Division Name	nvarchar
FromFacilityCode	From Facility Code	nvarchar
FromFacilityId	From Facility Id	int	vr_facility
FromFacilityName	From Facility Name	nvarchar
FromFloorCode	From Floor Code	nvarchar
FromFloorId	From Floor Id	int	vr_floor
FromFloorName	From Floor Name	nvarchar
FromOwnerDepartmentCode	From Owner Department Code	nvarchar
FromOwnerDepartmentId	From Owner Department Id	int	vr_Department
FromOwnerDepartmentName	From Owner Department Name	nvarchar
FromRegionCode	From Region Code	nvarchar
FromRegionId	From Region Id	int	vr_region
FromRegionName	From Region Name	nvarchar
Id	Tool Transfer Id	int
ItemCode	Item Code	nvarchar
ItemId	Item Id	int
ItemModelNumber	Item Model Number	nvarchar
ItemName	Item Name	nvarchar
ItemSerialNumber	Item Serial Number	nvarchar
ToAccountCode	To Account Code	nvarchar
ToAccountId	To Account Id	int	vr_account
ToAreaDescription	To Area Description	nvarchar
ToAreaId	To Area Id	int	vr_area
ToAreaLocationCode	To Area Location Code (Location Id)	nvarchar
ToAreaRoomNumber	To Area Room Number	nvarchar
ToAssignedTechCode	To Assigned Technician Code	nvarchar
ToAssignedTechId	To Assigned Technician Id	int	vrpt_Technician
ToAssignedTechName	To Assigned Tech Name	nvarchar
ToBuildingCode	To Building Code	nvarchar
ToBuildingId	To Building Id	int	vr_building
ToBuildingName	To Building Name	nvarchar
ToDepartmentCode	To Department Code	nvarchar
ToDepartmentId	To Department Id	int	vr_Department
ToDepartmentName	To Department Name	nvarchar
ToDistrictCode	To District Code	nvarchar
ToDistrictId	To District Id	int	vr_District
ToDistrictName	To District Name	nvarchar
ToDivisionCode	To Division Code	nvarchar
ToDivisionId	To Division Id	int
ToDivisionName	To Division Name	nvarchar
ToFacilityCode	To Facility Code	nvarchar
ToFacilityId	To Facility Id	int	vr_facility
ToFacilityName	To Facility Name	nvarchar
ToFloorCode	To Floor Code	nvarchar
ToFloorId	To Floor Id	int	vr_floor
ToFloorName	To Floor Name	nvarchar
ToolTransferHeaderId	Tool Transfer Header Id	int	vr_ToolTransferHeader
ToOwnerDepartmentCode	To Owner Department Code	nvarchar
ToOwnerDepartmentId	To Owner Department Id	int	vr_Department
ToOwnerDepartmentName	To Owner Department Name	nvarchar
ToRegionCode	To Region Code	nvarchar
ToRegionId	To Region Id	int	vr_Region
ToRegionName	To Region Name	nvarchar

Articles in this section