Skip to main content
Skip table of contents

wsiSMSQuoteTask

Table: SV00545

Element NameData TypeLengthRequiredDefaultDescription

@I_vAddressCode

char

15




@I_vBaseCurrencyID

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_vBillingCurrencyID

char

15




@I_vCoverageCode

smallint

 




@I_vCurrentRunUnits

numeric

19,5




@I_vCustomerContractNumber

char

15




@I_vCustomerNumber

char

15




@I_vEndDate

datetime

 




@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_vID1

char

11




@I_vID2

char

11




@I_vInactive

tinyint

 




@I_vLastRunUnits

numeric

19,5




@I_vLocalCurrencyID

char

15




@I_vMaterialKitQuantity

int

 




@I_vMaterialKitRequired

char

31




@I_vOnlyValidate

tinyint

 




@I_vOptional

tinyint

 




@I_vPMGroup

char

3




@I_vQuoteNumber

char

11




@I_vQuoteTaskListID

char

11




@I_vReturnErrorText

tinyint

 




@I_vRunUnits

numeric

19,5




@I_vSchedule

smallint

 




@I_vSkillLevel

char

15




@I_vStartDate

datetime

 




@I_vSub1

char

15




@I_vSub2

char

15




@I_vSub3

char

15




@I_vSub4

char

15




@I_vSubcontractorID

char

15




@I_vSVLanguageID

smallint

 




@I_vTask_Description_Long

char

255




@I_vTask_Hierarchy

char

41




@I_vTaskCode

char

11




@I_vTaskDescription

char

61




@I_vTaskHours

int

 




@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_vTechnicianID

char

15




@I_vTechnicianTeam

char

15




@I_vTimeZone

char

3




@I_vToolKitRequired

char

15




@I_vUpdateIfExists

tinyint

 




@I_vUserID

char

15




@I_vUSRDEFND1

char

50




@I_vUSRDEFND2

char

50




@I_vUSRDEFND3

char

50




@I_vUSRDEFND4

varchar

8000




@I_vUSRDEFND5

varchar

8000




@I_vWeek1

tinyint

 




@I_vWeek2

tinyint

 




@I_vWeek3

tinyint

 




@I_vWeek4

tinyint

 




@I_vWeek5

tinyint

 




@I_vWennsoftAffiliate

char

15




@I_vWennsoftBranch

char

15




@I_vWennsoftCloseDate

datetime

 




@I_vWennsoftRegion

char

15




@I_vWennSoftTablesOnly

tinyint

 




@I_vWSFrequency

char

15




@I_vWSMajor

char

15




@I_vWSReservedCB1

tinyint

 




@I_vWSReservedCB10

tinyint

 




@I_vWSReservedCB2

tinyint

 




@I_vWSReservedCB3

tinyint

 




@I_vWSReservedCB4

tinyint

 




@I_vWSReservedCB5

tinyint

 




@I_vWSReservedCB6

tinyint

 




@I_vWSReservedCB7

tinyint

 




@I_vWSReservedCB8

tinyint

 




@I_vWSReservedCB9

tinyint

 




@I_vWSReservedSTR1

char

11




@I_vWSReservedSTR2

char

11




@I_vWSSystem

char

15




@I_vYRMOD

smallint

 




@I_vYRREM

smallint

 




@O_iErrorState

int

 




@oErrString

varchar

255




Error Codes

Error CodeDescription

51112

The Customer Number does not exist.

52027

The Address Code does not exist.

52213

The Equipment record does not exist.

52231

The Task Code does not exist.

52232

The frequency/schedule combination does not exist in the SV00541 table.

52307

Error inserting record into the quote sub task table (SV00546).

52308

Error inserting record into the quote task materials table (SV00549).

52311

Error inserting/updating the quote task table (SV00545).

52312

Error inserting into the quote task list master table (SV00544).

52313

Error inserting into the quote equipment master table (SV00402).

52314

The given quote does not exist in the quote master table (SV00502).

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.