Repair Request

Repair Request Object (from Repairs & CRM)

Description	Type	Direction	Data Type	Remarks
AccessRestrictions	Property	Read Write	String	Details of access to the property
ContactContactID	Property	Read Write	Long	Assigned by Repairs or CRM
ContactUserID	Property	Read Write	Long	Assigned by Repairs or CRM
CRMReference	Property	Read Write	Long	Assigned by CRM
CRQTasks	Property	Read	Collection	Collection of Repair Tasks
DeletionNotes	Property	Read Write	String	Notes for deletion of Repair Request
DeletioReasonID	Property	Read Write	Long	Reason for deletion of Repair Request
Description	Property	Read Write	String	Fault Description
LoggedByID	Property	Read Write	Long	User logging the Repair
PriorityID	Property	Read Write	Long	Not required in SQL Repairs
RequestDT	Property	Read Write	Date	Assigned by Repairs or CRM
RequstedByContactID	Property	Read Write	Long	Assigned by Repairs or CRM
RequestedByUserID	Property	Read Write	Long	Assigned by Repairs or CRM
StatusID	Property	Read Write	Long	Assigned by Repairs or CRM
VoidEpisodeID	Property	Read Write	Long	Assigned by Repairs or CRM if property is Void

Associated SQLActiveH database table data

The MIS-AMS SQLActiveH Gateway's Repair Request Object (CRQRequest), is linked to the Repairs_Requests_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_Requests_T table which Keyfax writes to in the current version:

Object property :	Tasking_Tasks_T column :	Datatype:
Description	Description_VC	varchar(1500)
AccessRestrictions	Access_Restrictions_VC	varchar(1500)

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.