vrpt_GenInspectionItemChecksXref

Updated December 22, 2025 16:44

Field Name	Field Description	Data Type	FK Join
fo_code	Task Code	nvarchar
fo_description	Task Description	nvarchar
ftr_code	Trade Code	nvarchar
ftr_description	Trade Description	nvarchar
GIC_COMMENTS	Comments	bit
GIC_CreatedDate	Record Creation Date	datetime
GIC_CREATOR_FK	User Id (Record Creator)	int	vr_Users
GIC_DEFAULT_FO_FK	Default Task Id	int	vrpt_task
GIC_DEFAULT_FTR_FK	Default Trade Id	int	vr_Trade
GIC_default_PRI_FK	Default Priority Id	int	vr_Priority
GIC_DEFAULT_RC_FK	Deafult Repair Center Id	int	vr_RepairCenter
GIC_DEFAULT_WC_FK	Default Work Order Type Id	int	vr_WorkOrderType
GIC_DESCRIPTION	Description	nvarchar
GIC_GIF_FK	General Inspeciton Form Id	int	vr_GeneralInspectionForm
GIC_ModifiedDate	Last Modified Date	datetime
GIC_MODIFIER_FK	User Id (Record Modifier)	int	vr_users
GIC_PASS	Pass	bit
GIC_PK	General Inspection Checks Id	int	vrpt_genInspectionCheck
GIC_READING	Reading	bit
GIC_UPDATEMETER	Indicates if the record will update associated meter record	bit
gif_pk	General Inspection Form Id	int	vr_GeneralInspectionForm
GIIC_CreatedDate	Record Creation Date	datetime
GIIC_CREATOR_FK	User Id (Record Creator)	int	vr_users
GIIC_GIC_FK	General Inspection Checks Id	int	vrpt_genInspectionCheck
GIIC_GII_FK	General Inspection Item Id	int
GIIC_ModifiedDate	Last Modified Date	datetime
GIIC_MODIFIER_FK	User Id (Record Modifier)	int	vr_users
GIIC_ORDER	Order	int
GIIC_PK	General Inspection Item Checks Xref Id	int
Id	General Inspection Item Checks Xref Id	int
pri_code	Priority Code	nvarchar
pri_description	Priority Description	nvarchar
rc_code	Repair Center Code	nvarchar
rc_name	Repair Center Name	nvarchar
wc_code	Work Order Type Code	nvarchar
wc_description	Work Order Type Description	nvarchar

Articles in this section