Repair Request Inspection

Repair Request Inspection Object (from repairs & CRM)

Description:	Type	Direction	Data Type	Remarks
AccessRestrictions	Property	Read Write	String	Details of access to the property
Completion	Property	Read Write	Variant	?
CompletionAnalysisID	Property	Read Write	Long	?
DeletionNotes	Property	Read Write	String	Notes for deletion of Repair Inspection
DeletioReasonID	Property	Read Write	Long	Reason for deletion of Repair Inspection
Description	Property	Read Write	String	Inspection Description
Estimated	Property	Read Write	Variant	?
ExternalInspectorCodeID	Property	Read Write	Long	?
Inspection	Property	Read Write	VAriant	?
InspectionTypeID	Property	Read Write	Long	Type of inspection
InspectorCodeID	Property	Read Write	Long	Inspector assigned to Inspection
InternalExternal	Property	Read Write	String	Always '45' for Internal
LastIssued	Property	Read Write	Variant	?
Logged	Property	Read Write	Variant	?
LoggedBy	Property	Read Write	Long	User logging the Repair Inspection
MainWorkFlowProcessRan	Property	Read Write	Boolean	?
PriorityCodeID	Property	Read Write	Long	Priority for the Repair Inspection
RequestID	Property	Read Write	Long	Assigned by Repairs or CRM on Save
Results	Property	Read Write	String	?
WorkFlowProcessRan	Property	Read Write	Boolean	?

Associated SQLActiveH database table data

The MIS-AMS SQLActiveH Gateway's Repair Request Inspection Object (CRQInspection), is linked to the Repairs_Inspections_T table in the MIS-AMS SQLActiveH database.

When the object properties are written to by Keyfax, the MIS-AMS CRM processes the values and writes to the underlying database table. The following list identifies only those columns in the Repairs_Inspections_T table which Keyfax writes to in the current version:

Object property	Tasking_Tasks_T column	Datatype
Description	Description_VC	varchar(1500)
AccessRestrictions	AccessRestrictions_VC	varchar(1500)
InspectionTypeID	InspectionType_ID	int
PriorityCodeID	PriorityCode_ID	int
InternalExternal	InternalExternal_CH	char(2)

NOTE This data was correct at the time of writing, but Omfax suggest that MIS-AMS are consulted on any database or object schema modifications unknown to Omfax Systems.