wsiSMSTaskCodes
Table: SV00560
Element Name | Data Type | Length | Required | Default | Description |
---|---|---|---|---|---|
@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_vCoverageCode | smallint |
| |||
@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_vMaterialKitQuantity | int |
| |||
@I_vMaterialKitRequired | char | 31 | |||
@I_vOnlyValidate | tinyint |
| |||
@I_vOptional | tinyint |
| |||
@I_vReturnErrorText | tinyint |
| |||
@I_vRunUnits | numeric | 19,5 | |||
@I_vSchedule | smallint |
| |||
@I_vSkillLevel | char | 15 | |||
@I_vSub1 | char | 15 | |||
@I_vSub2 | char | 15 | |||
@I_vSub3 | char | 15 | |||
@I_vSub4 | char | 15 | |||
@I_vSVLanguageID | smallint |
| |||
@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_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 | |||
@O_iErrorState | int |
| |||
@ErrString | varchar | 255 |
Error Codes
Error Code | Description |
---|---|
52351 | WSReservedCB3 is invalid. Enter 0 or 1. |
52352 | WSReservedCB4 is invalid. Enter 0 or 1. |
52353 | WSReservedCB5 is invalid. Enter 0 or 1. |
52354 | WSReservedCB6 is invalid. Enter 0 or 1. |
52355 | WSReservedCB7 is invalid. Enter 0 or 1. |
52356 | WSReservedCB8 is invalid. Enter 0 or 1. |
52357 | WSReservedCB9 is invalid. Enter 0 or 1. |
52358 | WSReservedCB10 is invalid. Enter 0 or 1. |
52363 | WSReservedCB1 is invalid. Enter 0 or 1. |
52364 | WSReservedCB2 is invalid. Enter 0 or 1. |
52365 | The task code is blank. |
52366 | The skill level code is blank. |
52367 | The skill level code does not exist. |
52368 | The material kit required does not exist. |
52369 | The tool kit required does not exist. |
52370 | The task frequency is blank. |
52371 | The task frequency does not exist. |
52372 | The coverage code is blank. |
52373 | The System field entry was not found |
52374 | The sub 1 entry does not exist. |
52375 | The sub 2 entry does not exist. |
52376 | The sub 3 entry does not exist. |
52377 | The sub 4 entry does not exist. |
52378 | The Major field entry was not found. |
52383 | The suggested schedule does not exist. |
52384 | Error updating record in the SV00560 table. |
52385 | Error inserting record in the SV00560 table. |