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.

Last updated