Repair Request Task

Repair Request Task Object (from repairs & CRM)

Description	Type	Direction	Data Type	Remarks
AccountCode	Property	Read Write	String	The account code for SOR
AttributeID	Property	Read Write	Long	?
AttributeLocationID	Property	Read Write	Long	?
CITScope	Property	Read Write	Long	?
CurrentWorksOrderLineID	Property	Read Write	Long	Assigned by Repairs or CRM
DeletionCodeID	Property	Read Write	Long	Reason for deletion of Repair Task
DeletionReason	Property	Read Write	String	Notes for deletion of Repair Task
EstimatedCompletion	Property	Read Write	Date	Assigned by Repairs or CRM on Save
EstimatedCost	Property	Read Write	Currency	Estimated cost of SOR
EstimatedStart	Property	Read Write	Date	Assigned by Repairs or CRM on Save
InsuranceReclaim	Property	Read Write	Boolean	Set to 1 if insurance reclaim. Updates the 'Exceptions' panel*
JobTypeID	Property	Read Write	Long	Type of Repair
LeaseholderRecharge	Property	Read Write	Boolean	Set to 1 if leaseholder recharge. Updates the 'Exceptions' panel*
NarrativeDescription	Property	Read Write	String	SOR Repair Description
PriorityID	Property	Read Write	Long	Priority for the Repair
Quantity	Property	Read Write	Single	Quantity of SOR items
ReasonForAddingTaskID	Property	Read Write	Long	?
RequestID	Property	Read Write	Long	Assigned by Repairs or CRM on Save
ScheduleID	Property	Read Write	Long	ID of SOR code
ServiceRechargeable	Property	Read Write	Boolean	Set to 1 if repair service is rechargeable. Updates the 'Exceptions' panel*
SetGatewayValueEx	Sub	Write		Initialises CRM Gateway field with supplied value
Parameters:	FieldName	String	OMFAX Repair Diagnostics field name
Value	Variant	Value to pass to ActiveH
SpecialInstructions	Property	Read Write	String	Special instructions for the repair
StatusID	Property	Read Write	Long	Assigned by Repairs or CRM
SystemUplift	Property	Read Write	Boolean	Assigned by Repairs or CRM on Save
TenantRecharge	Property	Read Write	Boolean	Set to 1 if repair if Rechargeable to tenant. Updates the 'Exceptions' panel*
TradeCodeID	Property	Read Write	Long	?
TradeCodeIDEx	Property	Read Write	Long	Trade code for SOR item
UnitOfMeasureCodeID	Property	Read Write	Long	Measurement unit for the SOR item
UpliftSubAccount	Property	Read Write	Boolean	?
WorksOrderID	Property	Read Write	Long	Assigned by Repairs or CRM

* Exceptions Panel The Repairs window contains an 'Exceptions Panel', an array of 6 checkboxes, and depending on your configuration, 4 of these can be set via a script as per the above table:

• InsuranceReclaim

• LeaseholderRecharge

• ServiceRechargeable

• TenantRecharge

Associated SQLActiveH database table data

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

Object property	Tasking_Tasks_T column	Datatype
AccountCode	AccountCode_CH	char(80)
ScheduleID	Schedule_ID	int
NarrativeDescription	NarrativeDescription_VC	varchar(500)
UnitOfMeasureCodeID	UnitOfMeasureCode_ID	int
Quantity	Quantity_DC	decimal
EstimatedCost	EstimatedCost_MN	money
PriorityID	Priority_ID	int
SpecialInstructions	SpecialInstructions_VC	varchar(500)
TenantRecharge	TenantRecharge_BT	bit
CITScope	CITScope_BT	bit
TradeCodeIDEx	TradeCode_ID	int
JobTypeID	Job_Type_ID	int

NOTE This data was correct at the time of writing, but Omfax recommend you consult with MIS-AMS regarding any database or object schema modifications unknown to Omfax Systems.