vrpt_GenInspectionResult

Updated December 22, 2025 16:47

Field Name	Field Description	Data Type	FK Join
CheckedOutBy	Checked Out By	nvarchar
CheckedOutString	Checked Out String	varchar
dp_code	Department Code	nvarchar
dp_name	Department Name	nvarchar
fo_code	Task Code	nvarchar
fo_description	Task Description	nvarchar
ftr_code	Trade Code	nvarchar
ftr_defaultSupervisor	Trade Default Supervisor	nvarchar
ftr_description	Trade Description	nvarchar
GIN_CheckedOut	Checked Out	bit
GIN_CheckedOutBy_fk	Checked Out By Id	int	vr_users
GIN_CheckedOutDateTime	Checked Out Date Time	datetime
GIN_CODE	Code	nvarchar
GIN_COMMENT	Comment	nvarchar
GIN_createdDate	Record Creation Date	datetime
GIN_Creator_fk	User Id (Record Creator)	int	vr_users
GIN_DEFAULT_FO_FK	Defualt Task Id	int	vrpt_task
GIN_DEFAULT_FTR_FK	Defualt Trade Id	int	vr_Trade
GIN_DEFAULT_PRI_FK	Default Priority Id	int	vr_Priority
GIN_DEFAULT_RC_FK	Default Repair Center Id	int	vr_RepairCenter
GIN_DEFAULT_WC_FK	Default Work Order Type Id	int	vr_WorkOrderType
GIN_GIF_FK	General Inspection Form Id	int
GIN_InspectedBy_fk	Inspected By Id	int	vrpt_Technician
GIN_InspectedDateTime	Inspected Date Time	datetime
GIN_modifiedDate	Last Modified Date	datetime
GIN_MODIFIER_FK	User Id (Record Modifier)	int	vr_users
GIN_NAME	Name	nvarchar
GIN_PK	General Inspection Result Id	int
GIN_WorkNotDone	Indicates if this record	bit
GIN_WOTask_FK	Work Order Task Id	int	vr_WorkOrderTask
Id	General Inspection Result Id	int
InspectedBy	Inspected By	nvarchar
pri_code	Priority Code	nvarchar
pri_description	Priority Description	nvarchar
rc_code	Repair Center Code	nvarchar
rc_name	Repair Center Name	nvarchar
taskDuration	Task Duration	decimal
wc_code	Work Order Type Code	nvarchar
wc_description	Work Order Type Description	nvarchar
wc_pk	Work Order Type Id	int	vr_WorkOrderType
wcs_code	Work Order SubType Code	nvarchar
wcs_description	Work Order SubType Description	nvarchar
wcs_pk	Work Order SubType Id	int	vr_WorkOrderSubType
wo_charge	Indicates Whether the Work Order is Chargeable or Not	bit
wo_completionDate	Completion (Closed) Date	datetime
wo_finishdate	Finish Date	datetime
wo_number	Work Order Number	nvarchar
wo_pk	Work Order Id	int	vr_Workorder
wo_rc_fk	Repair Center Id	int	vr_RepairCenter
wo_requestDate	Request Date	datetime
wo_status	Work Order Status Note	nvarchar
woTask_CompletionDate	Completion Date (Closed Date)	datetime
woTask_FinishDate	Finish Date	datetime
woTask_Open	Indicates Whether the Work Order Task Is Open or Not	bit
woTask_workNotDone	Work Not Done	bit

Articles in this section