wsiSMSContractTask
Table Name: SV00582
Other tables affected: SV00585, SV00583, SV00586, SV00581
Other stored procedures called: SMS_Build_Contract_Task_SchedulePre, SMS_Build_Contract_Task_Schedule, SMS_Build_Contract_Task_SchedulePost, SMS_Calculate_First_Call, SMS_Calculate_Next_Call, SMS_Calculate_Week_ofMonth
Description:
This procedure allows the import of a task code to an existing contract with an existing attached piece of equipment. The import will also handle the creation of the sub task records, the tasking schedule, and any task code materials that may exist. When this procedure is used to update a task code on a contract the contract task schedule, subtasks and materials are deleted and will be created again.
| Element Name | Data Type | Length | Required | Default | Description |
|---|---|---|---|---|---|
@I_vCustomerNumber | char | 15 | Yes |
| Validated - RM00101 |
@I_vAddressCode | char | 15 | Yes |
| Validated - RM00102 |
@I_vCustomerContractNumber | char | 15 | No |
|
|
@I_vUserID | char | 15 | No |
|
|
@I_vWSContractNumber | char | 11 | Yes |
| Validated - SV00500 |
@I_vWSContractNumberSequence | int | 10 | Yes |
| Validated - SV00500 |
@I_vEquipmentID | char | 31 | Yes |
| Validated - SV00400 |
@I_vTaskCode | char | 11 | Yes |
| Validated - SV00560 |
@I_vContractTaskListID | char | 11 | No | ' | Added to SV00581 if not exists |
@I_vInactive | tinyint | 3 | No |
|
|
@I_vEstimateHours | int | 10 | No | !Leave empty.! Defaults from task code if sum is 0 - as will the other estimate fields. | Sum of estLabor1-5 hours |
@I_vEstimateLabor | numeric | 19,5 | No |
|
|
@I_vEstimateLabor1 | numeric | 19,5 | No |
|
|
@I_vEstimateLabor1Hours | int | 10 | No |
| 1 Hour = 100 |
@I_vEstimateLabor2 | numeric | 19,5 | No |
|
|
@I_vEstimateLabor2Hours | int | 10 | No |
| 1 Hour = 100 |
@I_vEstimateLabor3 | numeric | 19,5 | No |
|
|
@I_vEstimateLabor3Hours | int | 10 | No |
| 1 Hour = 100 |
@I_vEstimateLabor4 | numeric | 19,5 | No |
|
|
@I_vEstimateLabor4Hours | int | 10 | No |
| 1 Hour = 100 |
@I_vEstimateLabor5 | numeric | 19,5 | No |
|
|
@I_vEstimateLabor5Hours | int | 10 | No |
| 1 Hour = 100 |
@I_vEstimateEquipment | numeric | 19,5 | No |
|
|
@I_vEstimateMaterial | numeric | 19,5 | No |
|
|
@I_vEstimateSubs | numeric | 19,5 | No |
|
|
@I_vEstimateOther | numeric | 19,5 | No |
|
|
@I_vEstimateTotalCost | numeric | 19,5 | No |
|
|
@I_vBillableEquipment | numeric | 19,5 | No |
|
|
@I_vBillableMaterial | numeric | 19,5 | No |
|
|
@I_vBillableSubs | numeric | 19,5 | No |
|
|
@I_vBillableOther | numeric | 19,5 | No |
|
|
@I_vBillableLabor1 | numeric | 19,5 | No |
|
|
@I_vBillableLabor2 | numeric | 19,5 | No |
|
|
@I_vBillableLabor3 | numeric | 19,5 | No |
|
|
@I_vBillableLabor4 | numeric | 19,5 | No |
|
|
@I_vBillableLabor5 | numeric | 19,5 | No |
|
|
@I_vRunUnits | numeric | 19,5 | No |
|
|
@I_vCurrentRunUnits | numeric | 19,5 | No |
|
|
@I_vLastRunUnits | numeric | 19,5 | No |
|
|
@I_vWSFrequency | char | 15 | No |
| Validated - SV00541 against frequency schedule pair if provided |
@I_vSchedule | smallint | 5 | No | Defaults from task code if not provided | Validated - SV00541 against frequency schedule pair if provided |
@I_vOptional | tinyint | 3 | No |
|
|
@I_vSkillLevel | char | 15 | No |
|
|
@I_vMaterialKitRequired | char | 31 | No |
|
|
@I_vMaterialKitQuantity | int | 10 | No |
|
|
@I_vToolKitRequired | char | 15 | No |
|
|
@I_vCoverageCode | smallint | 5 | No |
|
|
@I_vTaskUserDefine1 | char | 21 | No |
|
|
@I_vTaskUserDefine2 | char | 21 | No |
|
|
@I_vTaskUserDefine3 | char | 31 | No |
|
|
@I_vTaskUserDefine4 | char | 31 | No |
|
|
@I_vTaskUserDefine5 | int | 10 | No |
|
|
@I_vTaskUserDefine6 | int | 10 | No |
|
|
@I_vTaskUserDefine7 | int | 10 | No |
|
|
@I_vTaskUserDefine8 | int | 10 | No |
|
|
@I_vTaskUserDefine9 | datetime |
| No |
|
|
@I_vTaskUserDefine10 | datetime |
| No |
|
|
@I_vTaskUserDefine11 | datetime |
| No |
|
|
@I_vTaskUserDefine12 | datetime |
| No |
|
|
@I_vTaskUserDefine13 | numeric | 19,5 | No |
|
|
@I_vTaskUserDefine14 | numeric | 19,5 | No |
|
|
@I_vTaskUserDefine15 | numeric | 19,5 | No |
|
|
@I_vTaskUserDefine16 | numeric | 19,5 | No |
|
|
@I_vTaskUserDefine17 | numeric | 19,5 | No |
|
|
@I_vTaskUserDefine18 | tinyint | 3 | No |
|
|
@I_vTaskUserDefine19 | tinyint | 3 | No |
|
|
@I_vTaskUserDefine20 | tinyint | 3 | No |
|
|
@I_vTaskUserDefine21 | tinyint | 3 | No |
|
|
@I_vTaskHours | int | 10 | No |
|
|
@I_vWeek1 | tinyint | 3 | No |
|
|
@I_vWeek2 | tinyint | 3 | No |
|
|
@I_vWeek3 | tinyint | 3 | No |
|
|
@I_vWeek4 | tinyint | 3 | No |
|
|
@I_vWeek5 | tinyint | 3 | No |
|
|
@I_vTimeZone | char | 3 | No |
|
|
@I_vSVLanguageID | smallint | 5 | No |
|
|
@I_vBaseCurrencyID | char | 15 | No |
|
|
@I_vBillingCurrencyID | char | 15 | No |
|
|
@I_vLocalCurrencyID | char | 15 | No |
|
|
@I_vWSReservedCB1 | tinyint | 3 | No |
|
|
@I_vWSReservedCB2 | tinyint | 3 | No |
|
|
@I_vWSReservedCB3 | tinyint | 3 | No |
|
|
@I_vWSReservedCB4 | tinyint | 3 | No |
|
|
@I_vWSReservedCB5 | tinyint | 3 | No |
|
|
@I_vWSReservedCB6 | tinyint | 3 | No |
|
|
@I_vWSReservedCB7 | tinyint | 3 | No |
|
|
@I_vWSReservedCB8 | tinyint | 3 | No |
|
|
@I_vWSReservedCB9 | tinyint | 3 | No |
|
|
@I_vWSReservedCB10 | tinyint | 3 | No |
|
|
@I_vWSReservedSTR1 | char | 11 | No |
|
|
@I_vWSReservedSTR2 | char | 11 | No |
|
|
@I_vPMGroup | char | 3 | No |
|
|
@I_vID1 | char | 11 | No |
|
|
@I_vID2 | char | 11 | No |
|
|
@I_vYRMOD | smallint | 5 | No |
|
|
@I_vYRREM | smallint | 5 | No |
|
|
@I_vUpdateIfExists | tinyint | 3 | Yes | 0 |
|
@I_vWennSoftTablesOnly | tinyint | 3 | Yes | 0 |
|
@I_vOnlyValidate | tinyint | 3 | Yes | 0 |
|
@I_vUSRDEFND1 | char | 50 | No |
|
|
@I_vUSRDEFND2 | char | 50 | No |
|
|
@I_vUSRDEFND3 | char | 50 | No |
|
|
@I_vUSRDEFND4 | varchar | 8000 | No |
|
|
@I_vUSRDEFND5 | varchar | 8000 | No |
|
|
@I_vReturnErrorText | tinyint | 3 | No | 1 |
|
@O_iErrorState | int | 10 | No | 0 |
|
@oErrString | varchar | 255 | No |
|
|