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.

Last updated