/*<![CDATA[*/ div.rbtoc1765575882313 {padding: 0px;} div.rbtoc1765575882313 ul {list-style: disc;margin-left: 0px;} div.rbtoc1765575882313 li {margin-left: 0px;padding-left: 0px;} /*]]>*/ Table: SV00113 Error Codes
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). |