wsiSMSQuoteTask
Table: SV00545
Element Name | Data Type | Length | Required | Default | Description |
---|---|---|---|---|---|
@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 Code | Description |
---|---|
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). |