wsiSMSServiceTasksMaster | WennSoft Documentation

/*<![CDATA[*/ div.rbtoc1765575865509 {padding: 0px;} div.rbtoc1765575865509 ul {list-style: disc;margin-left: 0px;} div.rbtoc1765575865509 li {margin-left: 0px;padding-left: 0px;} /*]]>*/ Table: SV00302 Error Codes

Table: SV00302

Element Name	Data Type	Length
@I_vAddressCode	char	15
@I_vBillableEquipment	numeric	19,5
@I_vBillableLabor1	numeric	19,5
@I_vBillableLabor2	numeric	19,5
@I_vBillableLabor3	numeric	19,5
@I_vBillableLabor4	numeric	19,5
@I_vBillableLabor5	numeric	19,5
@I_vBillableMaterial	numeric	19,5
@I_vBillableOther	numeric	19,5
@I_vBillableSubs	numeric	19,5
@I_vComponentFlag	tinyint
@I_vCoverageCode	smallint
@I_vCreatedDate	datetime
@I_vCreatedUserID	char	15
@I_vCurrentRunUnits	numeric	19,5
@I_vCustomerNumber	char	15
@I_vEquipmentID	char	31
@I_vEquipmentType	char	31
@I_vEstimateEquipment	numeric	19,5
@I_vEstimateHours	int
@I_vEstimateLabor	numeric	19,5
@I_vEstimateLabor1	numeric	19,5
@I_vEstimateLabor1Hours	int
@I_vEstimateLabor2	numeric	19,5
@I_vEstimateLabor2Hours	int
@I_vEstimateLabor3	numeric	19,5
@I_vEstimateLabor3Hours	int
@I_vEstimateLabor4	numeric	19,5
@I_vEstimateLabor4Hours	int
@I_vEstimateLabor5	numeric	19,5
@I_vEstimateLabor5Hours	int
@I_vEstimateMaterial	numeric	19,5
@I_vEstimateOther	numeric	19,5
@I_vEstimateSubs	numeric	19,5
@I_vEstimateTotalCost	numeric	19,5
@I_vItemType	smallint
@I_vLastRunUnits	numeric	19,5
@I_vLocationEquipment	char	51
@I_vMaterialKitQuantity	int
@I_vMaterialKitRequired	char	31
@I_vOnlyValidate	tinyint
@I_vOriginating_Call_Respons	text
@I_vResolutionCode	char	11
@I_vReturnErrorText	tinyint
@I_vRunUnits	numeric	19,5
@I_vServiceCallID	char	17
@I_vSkillLevel	char	15
@I_vSub1	char	15
@I_vSub2	char	15
@I_vSub3	char	15
@I_vSub4	char	15
@I_vSubTaskCode	char	11
@I_vSubTaskLineNumber	int
@I_vSVActualTime	int
@I_vSVCompletionDate	datetime
@I_vTask_Hierarchy	char	41
@I_vTaskCode	char	11
@I_vTaskComment1	char	121
@I_vTaskComment2	char	121
@I_vTaskComment3	char	121
@I_vTaskDescription	char	61
@I_vTaskDescriptionLong	char	255
@I_vTaskLineNumber	int
@I_vTaskListID	char	11
@I_vTaskStatus	char	11
@I_vTaskUserDefine1	char	21
@I_vTaskUserDefine10	datetime
@I_vTaskUserDefine11	datetime
@I_vTaskUserDefine12	datetime
@I_vTaskUserDefine13	numeric	19,5
@I_vTaskUserDefine14	numeric	19,5
@I_vTaskUserDefine15	numeric	19,5
@I_vTaskUserDefine16	numeric	19,5
@I_vTaskUserDefine17	numeric	19,5
@I_vTaskUserDefine18	tinyint
@I_vTaskUserDefine19	tinyint
@I_vTaskUserDefine2	char	21
@I_vTaskUserDefine20	tinyint
@I_vTaskUserDefine21	tinyint
@I_vTaskUserDefine3	char	31
@I_vTaskUserDefine4	char	31
@I_vTaskUserDefine5	int
@I_vTaskUserDefine6	int
@I_vTaskUserDefine7	int
@I_vTaskUserDefine8	int
@I_vTaskUserDefine9	datetime
@I_vTimeZone	char	3
@I_vToolKitRequired	char	15
@I_vTroubleCode	char	11
@I_vUpdateIfExists	tinyint
@I_vUserDefine1a	char	31
@I_vUSRDEFND1	char	50
@I_vUSRDEFND2	char	50
@I_vUSRDEFND3	char	50
@I_vUSRDEFND4	varchar	8000
@I_vUSRDEFND5	varchar	8000
@I_vWennsoftAffiliate	char	15
@I_vWennsoftBranch	char	15
@I_vWennsoftMasterEquipID	char	31
@I_vWennsoftRegion	char	15
@I_vWennSoftTablesOnly	tinyint
@I_vWSMajor	char	15
@I_vWSSystem	char	15
@O_iErrorState	int
@oErrString	varchar	255

Error Codes

Error Code	Description
52213	The Equipment record does not exist.
52231	The Task Code does not exist.
52387	The Service Call does not exist.
52391	The Skill Level does not exist.
52648	Insert/Update failed for table SV00302.