wsiSMSServiceTasksMaster

@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

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.