wsiSMSVehicle
Table: SV00113
Description: This will create/update vehicle records in SV00113.
Element Name | Data Type | Length | Required | Default | Description |
---|---|---|---|---|---|
@I_vAltitude | numeric | 19,5 | |||
@I_vLatitude | numeric | 19,5 | |||
@I_vLongitude | numeric | 19,5 | |||
@I_vOnlyValidate | tinyint |
| |||
@I_vReturnErrorText | tinyint |
| |||
@I_vServiceUserDefine1 | char | 21 | |||
@I_vServiceUserDefine10 | datetime |
| |||
@I_vServiceUserDefine11 | datetime |
| |||
@I_vServiceUserDefine12 | datetime |
| |||
@I_vServiceUserDefine18 | tinyint |
| |||
@I_vServiceUserDefine19 | tinyint |
| |||
@I_vServiceUserDefine2 | char | 21 | |||
@I_vServiceUserDefine20 | tinyint |
| |||
@I_vServiceUserDefine21 | tinyint |
| |||
@I_vServiceUserDefine22 | numeric | 19,5 | |||
@I_vServiceUserDefine23 | numeric | 19,5 | |||
@I_vServiceUserDefine24 | numeric | 19,5 | |||
@I_vServiceUserDefine25 | numeric | 19,5 | |||
@I_vServiceUserDefine3 | char | 31 | |||
@I_vServiceUserDefine4 | char | 31 | |||
@I_vServiceUserDefine5 | int |
| |||
@I_vServiceUserDefine6 | int |
| |||
@I_vServiceUserDefine7 | int |
| |||
@I_vServiceUserDefine8 | int |
| |||
@I_vServiceUserDefine9 | datetime |
| |||
@I_vTechnician | char | 11 | |||
@I_vUpdateIfExists | tinyint |
| |||
@I_vUSRDEFND1 | char | 50 | |||
@I_vUSRDEFND2 | char | 50 | |||
@I_vUSRDEFND3 | char | 50 | |||
@I_vUSRDEFND4 | varchar | 8000 | |||
@I_vUSRDEFND5 | varchar | 8000 | |||
@I_vVehicleDescription | char | 101 | |||
@I_vVehicleID | char | 101 | |||
@I_vVehicleStatus | char | 51 | |||
@I_vVIN | char | 31 | |||
@I_vWennSoftTablesOnly | tinyint |
| |||
@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 | |||
@O_iErrorState | int |
| |||
@oErrString | varchar | 255 |
Error Codes
Error Code | Description |
---|---|
51112 | The Customer Number does not exist. |
52194 | The Technician ID is invalid. |
52315 | Error inserting/updating the service vehicle master table (SV00113). |