Table Name: SV00403
Other stored procedures called: wsiSMSEquipmentContractPre, wsiSMSEquipmentContractPost
Description:
This procedure will allow you to insert/update records into the SV00403 equipment contract coverage table. This table establishes the relationship between contracts and the equipment that is assigned to them.
|
Element Name |
Data Type |
Length |
Required |
Default |
Description |
|---|---|---|---|---|---|
|
@I_vCustomerNumber |
char |
15 |
Yes |
|
Validated - RM00101 |
|
@I_vAddressCode |
char |
15 |
Yes |
|
Validated - RM00102 |
|
@I_vWSContractNumber |
char |
11 |
Yes |
|
Validated - SV00500 |
|
@I_vWSContractNumberSequence |
int |
10 |
Yes |
|
Validated - SV00500 |
|
@I_vEquipmentID |
char |
31 |
Yes |
|
Validated - SV00400 |
|
@I_vServiceUserDefine1 |
char |
21 |
No |
' |
|
|
@I_vServiceUserDefine2 |
char |
21 |
No |
' |
|
|
@I_vServiceUserDefine3 |
char |
31 |
No |
' |
|
|
@I_vServiceUserDefine4 |
char |
31 |
No |
' |
|
|
@I_vServiceUserDefine5 |
int |
10 |
No |
0 |
|
|
@I_vServiceUserDefine6 |
int |
10 |
No |
0 |
|
|
@I_vServiceUserDefine7 |
int |
10 |
No |
0 |
|
|
@I_vServiceUserDefine8 |
int |
10 |
No |
0 |
|
|
@I_vServiceUserDefine9 |
datetime |
|
No |
1/1/1900' |
|
|
@I_vServiceUserDefine10 |
datetime |
|
No |
1/1/1900' |
|
|
@I_vServiceUserDefine11 |
datetime |
|
No |
1/1/1900' |
|
|
@I_vServiceUserDefine12 |
datetime |
|
No |
1/1/1900' |
|
|
@I_vServiceUserDefine18 |
tinyint |
3 |
No |
0 |
|
|
@I_vServiceUserDefine19 |
tinyint |
3 |
No |
0 |
|
|
@I_vServiceUserDefine20 |
tinyint |
3 |
No |
0 |
|
|
@I_vServiceUserDefine21 |
tinyint |
3 |
No |
0 |
|
|
@I_vServiceUserDefine22 |
numeric |
19,5 |
No |
0 |
|
|
@I_vServiceUserDefine23 |
numeric |
19,5 |
No |
0 |
|
|
@I_vServiceUserDefine24 |
numeric |
19,5 |
No |
0 |
|
|
@I_vServiceUserDefine25 |
numeric |
19,5 |
No |
0 |
|
|
@I_vWSReservedCB1 |
tinyint |
3 |
No |
0 |
|
|
@I_vWSReservedCB2 |
tinyint |
3 |
No |
0 |
|
|
@I_vWSReservedCB3 |
tinyint |
3 |
No |
0 |
|
|
@I_vWSReservedCB4 |
tinyint |
3 |
No |
0 |
|
|
@I_vWSReservedCB5 |
tinyint |
3 |
No |
0 |
|
|
@I_vWSReservedCB6 |
tinyint |
3 |
No |
0 |
|
|
@I_vWSReservedCB7 |
tinyint |
3 |
No |
0 |
|
|
@I_vWSReservedCB8 |
tinyint |
3 |
No |
0 |
|
|
@I_vWSReservedCB9 |
tinyint |
3 |
No |
0 |
|
|
@I_vWSReservedCB10 |
tinyint |
3 |
No |
0 |
|
|
@I_vWSReservedSTR1 |
char |
11 |
No |
' |
|
|
@I_vWSReservedSTR2 |
char |
11 |
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 |
|
|