wsiSMSAppointment

Table: SV00301

Element Name	Data Type	Length
@I_vActualHours	int
@I_vAppointment	char	25
@I_vAppointmentDescription	char	51
@I_vAppointmentGroupID	char	25
@I_vAppointmentPriority	char	3
@I_vAppointmentStatus	char	11
@I_vAppointmentType	smallint
@I_vCancelledReason	char	25
@I_vCostCodeAlias	char	27
@I_vCreatedDate	datetime
@I_vCreatedUserID	char	15
@I_vEstimateHours	int
@I_vLaborOverride	tinyint
@I_vOnlyValidate	tinyint
@I_vOriginalTechnician	char	11
@I_vReturnErrorText		tinyint
@I_vServiceCallID	char	17
@I_vServiceUserDefine1	char	21
@I_vServiceUserDefine10	datetime
@I_vServiceUserDefine11	datetime
@I_vServiceUserDefine12	datetime
@I_vServiceUserDefine18	tinyint
@I_vServiceUserDefine19	tinyint
@I_vServiceUserDefine2	char	21
@I_vServiceUserDefine20	tinyint
@I_vServiceUserDefine21	tinyint
@I_vServiceUserDefine3	char	31
@I_vServiceUserDefine4	char	31
@I_vServiceUserDefine5	int
@I_vServiceUserDefine6	int
@I_vServiceUserDefine7	int
@I_vServiceUserDefine8	int
@I_vServiceUserDefine9	datetime
@I_vSkillLevel	char	15
@I_vSkipDoubleBookCheck	tinyint
@I_vSkipShiftCheck	tinyint
@I_vStartTime	datetime
@I_vSVCompletionDate	datetime
@I_vSVToolID	int
@I_vTaskDate	datetime
@I_vTechnician	char	11
@I_vTechnicianStatus	char	17
@I_vTimeEnteredCB	tinyint
@I_vUpdateIfExists	tinyint
@I_vUPRTRXCode	char	7
@I_vUserDefined1	char	21
@I_vUserDefined2	char	21
@I_vUserDefinedCB11	tinyint
@I_vUserDefinedCB21	tinyint
@I_vUserDefinedDate1	datetime
@I_vUserDefinedDate2	datetime
@I_vUserDefinedDollar11	numeric	19,5
@I_vUserDefinedDollar21	numeric	19,5
@I_vUSRDEFND1	char	50
@I_vUSRDEFND2	char	50
@I_vUSRDEFND3	char	50
@I_vUSRDEFND4	varchar	8000
@I_vUSRDEFND5	varchar	8000
@I_vWennSoftTablesOnly	tinyint
@I_vWSCostCode	int
@I_vWSJobNumber	char	17
@O_iErrorState	int
@oErrString	varchar	255

Error Codes

Error Code	Description
52018	The Cost Code does not exist for the Job.
52143	The Technician does not exist.
52386	You have entered an invalid Appointment Type.
52387	The service call does not exist.
52388	The Technician Status does not exist.
52389	The Job Number does not exist.
52391	The Skill Level does not exist.
52392	The Appointment Status does not exist.
52393	The Tool ID does not exist.
52394	A shift conflict exists.
52395	A double booking conflict exists.
52396	The Appointment Master update has failed.
52396	The Appointment Master update has failed.
52398	Enter a valid Task Date.